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