20221223

Tables (4)

Admin (adm)

  • Admin ID (id) — VARCHAR(10) — Primary key — NOT NULL
  • Password (pwd) — VARCHAR(10)
  • Level (lev) — INT

Customer (cust)

  • Customer ID (id) — VARCHAR(10) — Primary key — NOT NULL
  • Password (pwd) — VARCHAR(10)
  • Name (name) — VARCHAR(10)

Product (item)

  • Item No. (id) — INT — Primary key — NOT NULL
  • Name (name) — VARCHAR(20)
  • Price (price) — INT
  • Image Name (imgname) — VARCHAR(30)
  • Register Date (rdate) — DATETIME

Shopping cart (cart)

  • Cart No. (id) — INT — Primary key — NOT NULL
  • Customer ID (cust_id) — VARCHAR(10) — Foreign key → Customer.Customer ID — NOT NULL
  • Item No. (item_id) — INT — Foreign key → Product.Item No. — NOT NULL
  • Item Count (cnt) — INT
  • Register Date (rdate) — DATE