StoriaGate - Laravel Schema Designer

children

id increments
timestamps timestamps
name string (100)
age integer
child_id ^FK integer
interests string (255)
guiding_values string (255)
additional_suggestions string (255)
store_id integer
gender enum

work_flow

id increments
timestamps timestamps
bundle_id integer
assign_date date
completed_at date
audited_at date
uploaded_at date
pending_at date
pending_reason string (255)
softDeletes softDeletes
userable_type string (100)
userable_id integer
status string (100)
file text
notes text

users

id increments
timestamps timestamps
user_name string (255)
email string (100)
password string (255)

it_employees

id increments
timestamps timestamps
user_id ^FK integer

writers

id increments
user_id ^FK integer
timestamps timestamps

character_designers

id increments
timestamps timestamps
user_id ^FK integer

designers

id increments
timestamps timestamps
user_id ^FK integer

bundles

id increments
timestamps timestamps
name string (255)
general_notes string (255)
lang string (100)
message string (255)
package string (100)
country string (100)
options string (255)
price float
status string (100)
order_id integer
last_updated_at datetime
department string (100)
writer_handover string (100)
designer_handover string (100)
it_handover string
character_handover string (100)
number_of_edits integer

orders

id increments
timestamps timestamps
code string (100)
phone string (100)
adress string (255)
reference string (100)
routed string (100)
payment_methode string (100)
payment_status string (100)
deposite float
descount float
total float
grant_total float
confirmation_status string (100)
confirmation_date date
eta date
refusion_reason string (100)
order_status string (100)
delivery_status string (100)
delivery_date date

transactions

id increments
timestamps timestamps
order_id ^FK integer
total float
type enum

transaction_payments

id increments
timestamps timestamps
reason string (255)
amount float
transaction_id ^FK integer

feedbacks

id increments
timestamps timestamps
user_name string (100)
userable_type string (100)
userable_id integer
message text
risk integer

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