20241129_WebServerProgrammingLecture_1

Tables (4)

order_items

  • order_item_id (Key) — INT — Primary key — NOT NULL
  • order_id (Field) — INT
  • product_id (Field2) — INT
  • quantity (Field3) — INT
  • price (Field4) — INT

orders

  • order_id (Key) — INT — Primary key — NOT NULL
  • user_id (Field) — INT
  • total_price (Field2) — INT
  • order_date (Field3) — DATETIME
  • order_item_id (Key2) — INT — Foreign key → order_items.order_item_id — NOT NULL

products

  • id (PK) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(255)
  • description (Field2) — TEXT
  • price (Field3) — DECIMAL(10,2)
  • image (Field4) — VARCHAR(255)
  • order_item_id (Key) — INT — Foreign key → order_items.order_item_id — NOT NULL

userinfo

  • iduserinfo (PK) — INT — Primary key — NOT NULL
  • userId (Field) — VARCHAR(45)
  • userPw (Field2) — VARCHAR(45)
  • userName (Field3) — VARCHAR(45)
  • userPhoneNumber (Field4) — VARCHAR(45)
  • userAddress (Field5) — VARCHAR(45)
  • Field6 — VARCHAR(45)
  • order_id (Key) — INT — Foreign key → orders.order_id — NOT NULL