Orderprocessing20251030

Tables (7)

Addr (Untitled7)

  • zipcode (Key) — char(5) — Primary key — NOT NULL
  • do (Field) — nchar(10)
  • city (Field2) — nchar(10)
  • dong (Field3)

Customer (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • Lastname (Field) — nchar(30)
  • FirstName (Field2) — nchar(30)
  • Country (Field3) — nchar(30)
  • tel (Field4) — char(14)
  • zipcode (Field10) — char(5)
  • do (Field5)
  • city (Field6)
  • dong (Field7)
  • detail_addr (Field9)

OrderItem (Untitled4)

  • id (Key) — int — Primary key — NOT NULL
  • quantity (Field) — int
  • productid (Key2) — int — Foreign key → Product.id — NOT NULL
  • orderid (Key3) — int — Foreign key → _order.id — NOT NULL

Product (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • productName (Field) — char(30)
  • unitproce (Field2) — int
  • Field3

Supplier (Untitled5)

  • id (Key) — int — Primary key — NOT NULL
  • Field — char(14)
  • Field2

Supplier (Untitled6)

  • id (Key) — Primary key — NOT NULL

_order (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • orderdate (Field) — datetime2
  • TotalAmount (Field2) — int
  • customerid (Key2) — int — Foreign key → Customer.id — NOT NULL