reliable_steel - Laravel Schema Designer

grade

id bigIncrements
name string
description text
active boolean
owner string
last_updated_by string
timestamps timestamps

finish

id bigIncrements
name string
description text
active boolean
owner string
last_updated_by string
timestamps timestamps

edge

id bigIncrements
name string
description text
active boolean
owner string
last_updated_by string
timestamps timestamps

email_verification

id bigIncrements
email string
token string
created_at timestamp

notification

id bigIncrements
user_id ^FK bigInteger
type string
text text
document_id bigInteger
read boolean
read_at datetime
owner string
last_updated_by string
timestamps timestamps

users

id bigIncrements
first_name string
last_name string
full_name string
avatar string
username string
password string
email string
email_verified_at timestamp
email_verification_code string
role string
active boolean
lang string (10)
first_login boolean
remember_token string (100)
owner string
last_updated_by string
timestamps timestamps

warehouse

id bigIncrements
name string
contact_name string
contact_no string
address text
lat string
long string
description text
active boolean
owner string
last_updated_by string
timestamps timestamps

buyer

id bigIncrements
name string
avatar string
member_since datetime
bucket_id ^FK bigInteger
contact_name string
contact_no string
email string
address text
description text
active boolean
owner string
last_updated_by string
timestamps timestamps

test_certificate

id bigIncrements
name string
alias string
document string
description text
owner string
last_updated_by string
timestamps timestamps

product

id bigIncrements
name string
avatar string
price double (8,2)
grade_id ^FK bigInteger
finish_id ^FK bigInteger
edge_id ^FK bigInteger
uom string
uom_id ^FK bigInteger
coil boolean
thickness double (8,2)
width integer
length integer
rsl integer
csl double (8,2)
description text
active boolean
owner string
last_updated_by string
timestamps timestamps

uom

id bigIncrements
name string
description text
active boolean
owner string
last_updated_by string
timestamps timestamps

buyer_favorite

id bigIncrements
buyer_id ^FK bigInteger
product_id ^FK bigInteger
owner string
last_updated_by string
timestamps timestamps

enquiry

id bigIncrements
buyer_id ^FK bigInteger
title string
owner string
last_updated_by string
timestamps timestamps

enquiry_product

id bigIncrements
enquiry_id ^FK bigInteger
product_id ^FK bigInteger
qty double (8,2)
owner string
last_updated_by string
timestamps timestamps

related_product

id bigIncrements
product_id ^FK bigInteger
related_product_id ^FK bigInteger
owner string
last_updated_by string
timestamps timestamps

bucket

id bigIncrements
name string
description text
active boolean
owner string
last_updated_by string
timestamps timestamps

product_discount

id bigIncrements
product_id ^FK bigInteger
bucket_id ^FK bigInteger
discount double (8,2)
owner string
last_updated_by string
timestamps timestamps

supplier

id bigIncrements
avatar string
name string
member_since date
contact_name string
contact_no string
email string
notes text
active boolean
owner string
last_updated_by string
timestamps timestamps

stock_entry

id bigIncrements
posting_date datetime
source_warehouse_id ^FK bigInteger
target_warehouse_id ^FK bigInteger
product_id ^FK bigInteger
invoice_date date
received_date date
qty double (8,2)
pcs integer
uom_id ^FK bigInteger
rate double (8,2)
test_certificate_id ^FK bigInteger
plate_no string
heat_no string
truck_no string
notes text
owner string
last_updated_by string
timestamps timestamps

activity

id increments
user_id ^FK bigInteger
module string
action string
document_id bigInteger
title string
owner string
last_updated_by string
timestamps timestamps

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