Home
bsbudget
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
StoresData
id
increments
CostCenter
integer
ChainNum
integer
ChainSlug
string
(10)
StoreName
string
(255)
RepCode
string
(100)
ContractNo
string
(100)
AreaManager
string
(255)
StoreFront
string
(10)
LocationType
string
(100)
State
string
(255)
PosCount
integer
SQMContract
integer
SQMSales
integer
RentSplit
integer
Top50JJ
boolean
StaffPerOpeningHours
decimal
OpenStoreVM
boolean
ComparableStatus
boolean
StatusType
string
(255)
ContractDate
date
ShopDate
date
TempClosingStartDate
date
TempClosingEndDate
date
RentContractStart
date
RentContractEnd
date
RentStore
decimal
RentStorage
decimal
RentOperationalCost
decimal
timestamps
timestamps
softDeletes
softDeletes
SpecialDays
id
increments
Name
string
(255)
StartDate
date
EndDate
date
DayType
integer
State
string
(255)
timestamps
timestamps
SalesData
id
increments
CostCenter
integer
Month
integer
Year
integer
GrossSales
decimal
GrossProfit
decimal
BasketSize
decimal
BasketQty
decimal
SalesPriceAvg
decimal
Transactions
integer
ConversionRate
float
CustomerCount
integer
SalesType
integer
timestamps
timestamps
softDeletes
softDeletes
WorkingHours
id
increments
CostCenter
integer
Month
integer
Year
integer
HoursType
integer
HoursTotal
integer
timestamps
timestamps
softDeletes
softDeletes
FinancialData
id
increments
CostCenter
integer
FinancialAccount
integer
Month
integer
Year
integer
Value
decimal
timestamps
timestamps
softDeletes
softDeletes
FinancialAccounts
id
increments
AccountID
integer
Name
string
(255)
timestamps
timestamps
softDeletes
softDeletes
DepreciationData
id
increments
CostCenter
integer
Month
integer
Year
integer
Value
decimal
timestamps
timestamps
softDeletes
softDeletes
StoreStaff
id
increments
LODASNo
integer
Firstname
string
(255)
Lastname
string
(255)
StartDate
date
EndDate
date
timestamps
timestamps
softDeletes
softDeletes
StoreStaffMonthly
id
increments
StaffID
FK
integer
Salary
decimal
Wage
decimal
Allowance
decimal
Month
integer
Year
integer
SVType
integer
ContractType
integer
ContractHours
decimal
Position
string
(255)
timestamps
timestamps
softDeletes
softDeletes
StoreStaffAssign
id
increments
StaffMonthlyID
FK
integer
CostCenter
integer
CostCenterShare
integer
timestamps
timestamps
softDeletes
softDeletes
StoreStaffAbsence
id
increments
StaffID
FK
integer
StartDate
date
EndDate
date
AbsenceType
string
(255)
timestamps
timestamps
softDeletes
softDeletes
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01