softwarekadai
Tables (5)
Customer (Untitled)
- uid (PK) — INT — Primary key — NOT NULL
- name (Field) — VARCHAR
- address (Field2) — VARCHAR
- phone (Field3) — VARCHAR
- email (Field4) — VARCHAR
- industry (Field5) — VARCHAR
- region (Field6) — VARCHAR
Inventory (Untitled3)
- id (PK) — INT — Foreign key → Product.product_id — NOT NULL
- quantity (Field) — INT
- used_quantity (Field2) — INT
Order (Untitled4)
- order_id (PK) — INT — Primary key — NOT NULL
- uid (FK) — INT — Foreign key → Customer.uid — NOT NULL
- order_date (Field) — DATETIME
OrderDetail (Untitled5)
- id (PK) — Primary key — NOT NULL
- order_id (FK1) — INT — Foreign key → Order.order_id — NOT NULL
- uid (FK2) — INT — Foreign key → Order.uid — NOT NULL
- product_id (FK3) — INT — Foreign key → Product.product_id — NOT NULL
- quantity (Field) — INT
- due_date (Field2) — DATETIME
- subtotal (Field3) — DECIMAL
Product (Untitled2)
- product_id (PK) — INT — Primary key — NOT NULL
- name (Field) — VARCHAR
- category (Field2) — VARCHAR
- price (Field3) — DECIMAL
- lead_time (Field4) — INT