usc - Laravel Schema Designer

discounts

id increments
timestamps timestamps
title string
slug string
description text
price float

services

id increments
programId ^FK integer
timestamps timestamps
title string
description text
slug string

services_providers

id increments
timestamps timestamps
serviceId ^FK integer
userId ^FK integer

agreements

id increments
timestamps timestamps
customerId ^FK integer
adminFirstName string
adminLastName string
adminEmail string
adminPhone string
startDate timestamp
endDate timestamp
paymentType string
accountNumber integer
fundingSource string
signature string
signatureAuthorized string
scopeOfWork text
serviceId ^FK integer
userId ^FK integer
helpSpotTicketID integer
formStackId integer
scopeFileId ^FK integer

service_items

id increments
serviceId ^FK integer
description text
note text
rateFrequency enum
amount float
percentageEffort integer
timestamps timestamps

programs

id increments
timestamps timestamps
title string
slug string

users

id increments
timestamps timestamps
firstName string
lastName string
email string
phone string
password string
salt string
reset string
type string

customers

id increments
timestamps timestamps
firstName string
lastName string
email string
phone string
notes text

files

id increments
timestamps timestamps
type string
filename string
size string

agreement_estimates

id increments
timestamps timestamps
agreementId ^FK integer

estimates

id increments
timestamps timestamps
agreementEstimateId ^FK integer
serviceItemId ^FK integer
discountId ^FK integer
notes text
frequency enum
frequencyTotal float
percentageEffort string
amount float

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01