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