MINIERP2 - Laravel Schema Designer

Customers

id integer
Cus_no string (30)
timestamps timestamps
softDeletes softDeletes
Created_by string (30)
Updated_by string (30)
parent_id integer
Title string (30)
Name string (255)
Taxid string (20)
Contact string (255)
Address1 string (255)
Address2 string (255)
zipcode string (10)
Phone string (150)
fax string (150)
maps text
maxcardit decimal
Cardit_day integer
websites string (255)
email string (255)
categoryid ^FK integer
rating integer
province ^FK integer
Notes text

Suppliers

ID increments
timestamps timestamps
softDeletes softDeletes
Created_by string (30)
Updated_by string (30)
Supplier_no string (30)
Title string
Name string (255)
Address1 string (255)
Address2 string (255)
Taxid string (20)
Phone string (150)
Fax string (150)
zipcode string (10)
Website string (255)
Email string (255)
Contact string (255)
Maps string (255)
Conditions string (255)
photo1 text
rating integer
province integer
category_id ^FK integer
Notes text

Products

id increments
Product_id string
Name string
Barcode string
Description text
timestamps timestamps
softDeletes softDeletes
Unit_id ^FK integer
UnitCost decimal
Price decimal
Category_id integer
Created_by string (30)
Updated_by string (30)
parent_id integer
Status enum
photo1 text
photo2 text
photo3 text
photo4 text
onHand decimal
Incoming string
Stock decimal
ref1 string (255)
ref2 string (255)
ref3 string (255)
ref4 string (255)
Notes text
pomotion_ref string (255)

ProductGroupDetail

timestamps timestamps
softDeletes softDeletes
Product_id string
Ref_product_id string
qty integer

Product_locate

id increments
timestamps timestamps
softDeletes softDeletes
warehouse_id ^FK integer

WareHouses

timestamps timestamps
softDeletes softDeletes
name string
company_id integer
id increments

purchaseorders

id increments
timestamps timestamps
Status enum
Supplier_id ^FK integer
Ref_Doc string
Doc_date datetime
Created_by string (30)
Updated_by string (30)
Notes text
deliverydate date
delivery_by string (255)
deliveryto string (255)
ref1 string (255)
ref2 string (255)
ref3 string (255)
ref4 string (255)
ref5 string (255)
Doc_No string (30)
Description string (255)
total decimal
discount decimal
discount_ref string (255)
total_after_discount decimal
Vat integer
vatadmount decimal
Empi integer
Totalamount decimal

Invoices

id increments
timestamps timestamps
Status integer
cus_id ^FK integer
Ref_Doc string
Doc_date datetime
Created_by string (30)
Updated_by string (30)
Notes text
deliverfydate date
delivery_by string (255)
delivertyto string (255)
ref1 string (255)
ref2 string (255)
ref3 string (255)
ref4 string (255)
ref5 string (255)
Doc_No string (30)
Description string (255)
Total decimal
discount decimal
discount_ref string (255)
total_after_discount decimal
Vat decimal
vatadmount decimal
Totalamount decimal
Empid integer

Usr

id increments
timestamps timestamps
softDeletes softDeletes
usr_id string
usr_level string
Name string
Lastname string
Telephone string
username string
Password string
usr_branch string

Receipt_Order

id increments
timestamps timestamps
purchaseOrder_id string

Product_GET

id increments
timestamps timestamps
purchaseOrger_id string
product_id string
qty string
warehouse_id string
receiptOrder_id string

Company

timestamps timestamps
id increments

Company_address

id increments
timestamps timestamps

ProductTrans

id increments
timestamps timestamps
DocsNo string (30)
Types enum
Product_id ^FK integer
Lot_id ^FK integer
Qty integer
Cost decimal
Amount decimal
Unitprice decimal
discount decimal
Unit_id integer

Units

id increments
timestamps timestamps
UnitOfMeasur string (80)
val string (30)
parent_id integer
per_parent decimal
barcode string (13)

LOTs

id increments
timestamps timestamps
Created_by string (30)
Updated_by string (30)

Istabs

id increments
timestamps timestamps
Group integer
Description string (80)
Val_int integer
Val_number decimal
Val_string string (80)
Val_tf boolean
seq integer
vals string (255)
comment text

Product_Categorys

id increments
timestamps timestamps
product_id ^FK integer
cate_id ^FK integer
Created_by string (30)
Updated_by string (30)

Promotions

id increments
group string (250)
Status enum
Start_date datetime
Expire_date datetime
priority integer
Name string (150)
Description text
condition text
functions text
parametors string (255)
timestamps timestamps
softDeletes softDeletes
Updated_by string (30)
Created_by string (30)

Members

id increments
timestamps timestamps
softDeletes softDeletes
Created_by string (30)
Updated_by string (30)
cus_no ^FK integer
telephone string (30)
Member_date datetime

Contacts

id increments
timestamps timestamps
softDeletes softDeletes
Created_by string (30)
Updated_by string (30)
Supplier_id ^FK integer
types enum
name string (255)
email string (255)
socials string (255)
phone string (255)
fax string (255)

Shippingaddresses

id increments
timestamps timestamps
softDeletes softDeletes
Created_by string (30)
Updated_by string (30)
cus_id ^FK integer
ReceiveName string (255)
Address1 string (255)
Address2 string (255)
zipcode string (10)
Phone string (150)
Fax string (150)
Email string (255)
Maps text
photo1 text
photo2 text
photo3 text

Promotion_Customer

id increments
timestamps timestamps
softDeletes softDeletes
Created_by string (30)
Updated_by string (30)
promotion_id ^FK integer
cus_id ^FK integer
status enum

SupCus_Details

id increments
timestamps timestamps
softDeletes softDeletes
Created_by string (30)
Updated_by string (30)
No string (30)
val1 string (255)
val2 string (255)
val3 decimal
val4 boolean
val5 text
default integer
rating integer
ref string (255)
type enum

Saleprices

id increments
timestamps timestamps
softDeletes softDeletes
Created_by string (30)
Updated_by string (30)
Istabid ^FK integer
cus_id ^FK integer
product_id ^FK integer
price decimal

Employees

id increments
timestamps timestamps
softDeletes softDeletes
Created_by string (30)
Updated_by string (30)
Firstname string (255)
Lastname string (255)
tax string (30)
idcardno string (20)
Brithday date
Start_Job_date date
status integer
email string (255)
socials string (255)
addres1 string (255)
address2 string (255)
province string (150)
zipcode string (10)
phone string (255)