Mini-PLM
Tables (8)
Customer (Untitled2)
- customerid (Key) — text — Primary key — NOT NULL
- customername (Field) — text — NOT NULL
- customerregion (Field5) — text — NOT NULL
Order (주문(장비제작요청서))
- orderid (Key) — integer — Primary key — NOT NULL
- customerid (Key2) — text — Foreign key → Customer.customerid — NOT NULL
- orderdate (Field) — date — NOT NULL
- requestdate (Field3) — date — NOT NULL
- orderregion (Field4) — text — NOT NULL
- status (Field5) — integer — NOT NULL
Order_Product (CopyOfUntitled2)
- orderid (Key2) — integer — Foreign key → Order.orderid — NOT NULL
- productid (Key3) — text — Foreign key → Product.productid — NOT NULL
- options (Field2) — json
Part (Untitled4)
- partid (Key) — text — Primary key — NOT NULL
- partname (Field2) — text — NOT NULL
- vendorid (Key2) — text — Foreign key → Vendor.vendorid — NOT NULL
Product (Untitled)
- productid (Key) — text — Primary key — NOT NULL
- productname (Field2) — text — NOT NULL
- productsegment (Field4) — text — NOT NULL
- productversion (Field3) — text — NOT NULL
- productweight (Field6) — number
- productcost (Field7) — number
- productprice (Field8) — number
Product_Part (Untitled3)
- productpartid (Key3) — text — Primary key — NOT NULL
- partid (Key4) — text — Foreign key → Part.partid — NOT NULL
- productid (Key5) — text — Foreign key → Product.productid — NOT NULL
- upperproductpartid (Key32) — text — Foreign key → Product_Part.productpartid — NOT NULL
- level (Field) — integer — NOT NULL
- isleaf (Field2) — binary — NOT NULL
- optionlist (Field3) — list
StandardInfo (Untitled6)
- tablename (Key) — text — Primary key — NOT NULL
- columnname (Key2) — text — Primary key — NOT NULL
- valuelist (Field) — list — NOT NULL
Vendor (Untitled5)
- vendorid (Key) — text — Primary key — NOT NULL
- vendorname (Field) — text — NOT NULL
- region (Field3) — text — NOT NULL