armansa_services - Laravel Schema Designer

services

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
code string (100)
service_category_id ^FK integer

service_categories

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
description string (1000)

attributes

id increments
timestamps timestamps
softDeletes softDeletes
key string (100)
code string (100)
value string (1000)
extra_fee double (22,2)
attribute_category_id ^FK integer

colors

id increments
softDeletes softDeletes
timestamps timestamps
name string (100)
code string (100)

sizes

id increments
softDeletes softDeletes
timestamps timestamps
name string (100)
code string (100)

papers

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
code string (100)

bindings

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
code string (100)

cellophane

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
code string (100)

service_details

id increments
timestamps timestamps
softDeletes softDeletes
service_id ^FK integer
size_id ^FK integer
color_id ^FK integer
paper_id ^FK integer
binding_id ^FK integer
cellophane_id ^FK integer
price double (22,2)
preview_media_id integer
status enum
discount float (22,2)
discount_type enum
cover_id ^FK integer

service_attributes

id increments
service_id ^FK integer
attribute_id ^FK integer

attribute_categories

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
description string (1000)

invoices

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
status enum
additional_discount float (22,2)
additional_price float (22,2)
tax float (22,2)

invoice_details

id increments
timestamps timestamps
invoice_id ^FK integer
service_detail_id ^FK integer
quantity integer

payments

id increments
timestamps timestamps
softDeletes softDeletes
invoice_id ^FK integer
status enum
amount double (22,2)
reterival_ref_no string (255)
system_trace_no string (255)
transaction_date datetime
transaction_result string (2000)
verification_result string (2000)

covers

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
code string (100)

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