myUniform - Laravel Schema Designer

order_info

order_id increments
type string (50)
gender string (10)
Institute ^FK integer
quantity integer
class string (10)
fk_customer_id ^FK integer
order_total decimal (10,2)
division string (20)
district string (20)
sub_district string (20)
details_address longText
status string (20)
delivery_date string (15)
delivery_fee decimal
payment_type string (30)
payment_status string (10)
timestamps timestamps
softDeletes softDeletes

order_item_measurement

item_measurement_id increments
fk_order_item_id ^FK integer
fk_dressType ^FK integer
fk_measurement_header ^FK integer
size string (10)
timestamps timestamps
softDeletes softDeletes

payment

payment_id increments
fk_order_id ^FK integer
type string (30)
amount decimal
timestamps timestamps
softDeletes softDeletes

style

style_id increments
fk_order_item_id ^FK integer
fk_header ^FK integer
size string (10)
fabric string (10)
timestamps timestamps
softDeletes softDeletes

school

school_id increments
name text
timestamps timestamps
softDeletes softDeletes

classes

classes_id increments
fk_school ^FK integer
name string (20)
timestamps timestamps
softDeletes softDeletes

order_item

order_item_id increments
fk_order_id ^FK integer
fk_dressType ^FK integer
timestamps timestamps
softDeletes softDeletes

order_status_log

status_id increments
fk_order_id ^FK integer
staus_name string (10)
added_by ^FK integer
timestamps timestamps
softDeletes softDeletes

ordered_addons

ordered_addon_id increments
fk_order_id ^FK integer
fk_addons ^FK integer
timestamps timestamps
softDeletes softDeletes

user

user_id increments
name string (20)
email string (40)
email_verified_at timestamp
password string (255)
remember_token string (100)
type string (10)
timestamps timestamps
softDeletes softDeletes

customer

customer_id increments
fk_user_id ^FK integer
phone string (20)
timestamps timestamps
softDeletes softDeletes

company

company_id increments
name string (20)
price string (20)
timestamps timestamps
softDeletes softDeletes

corporate_style_category

style_category_id increments
fk_company ^FK integer
category_name string (15)
category_image string
timestamps timestamps
softDeletes softDeletes

corporate_style_sub_category

sub_category_id increments
category_id ^FK integer
name string (10)
image string (15)
timestamps timestamps
softDeletes softDeletes

school_class_measurement

school_class_measurement_id increments
fk_school ^FK integer
fk_class_dress ^FK integer
fk_measurement_header ^FK integer
timestamps timestamps
softDeletes softDeletes

measurements

measurement_id increments
fk_dress_type ^FK integer
sidebar_image string (50)
image string (50)
measurement_header string (20)
video_link string (100)
timestamps timestamps
softDeletes softDeletes

company_measurement

company_measurement_id increments
fk_company ^FK integer
fk_measurement_header ^FK integer
timestamps timestamps
softDeletes softDeletes

addons

id increments
name string (15)
fk_dress ^FK integer
price decimal (10,2)
fk_company ^FK integer
timestamps timestamps
softDeletes softDeletes

dress_type

dress_type_id increments
type_name string (20)
dress_for string (15)
image string (50)
price string (15)
order_quantity text
order_color text
timestamps timestamps
softDeletes softDeletes

dresses

dresses_id increments
fk_class ^FK integer
fk_dress_type ^FK integer
price decimal (10,2)
gender string (10)
timestamps timestamps
softDeletes softDeletes

order_corporate

corporate_order_id increments
type string (20)
order_for string (20)
quantity integer
color string (15)
with_embrodary string (15)
with_print string (15)
customer_name string (25)
email string (50)
phone string (20)
order_note text
timestamps timestamps
softDeletes softDeletes

delivery_fee

delivery_fee_id increments
location string (30)
amount decimal (10,2)
timestamps timestamps
softDeletes softDeletes

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