test
Tables (6)
basket (Untitled5)
- bas_no (Key) — Primary key — NOT NULL
- user_id (userId) — Foreign key → customer.user_id — NOT NULL
- prd_no (Field)
- totqty (Field3)
category (Untitled)
- cat_no (Key) — Primary key — NOT NULL
- cat_name (Field)
customer
- user_id (userId) — Primary key — NOT NULL
- user_pwd (userPwd)
- user_name (userName)
- addr
- contact
order (Untitled3)
- ord_no (Key) — Primary key — NOT NULL
- user_id (userId) — Foreign key → customer.user_id — NOT NULL
- order_date (Field)
- order_addr (Field3)
- rec_name (Field2)
- rec_contact (Field4)
- tot_qty (Field5)
- tot_price (Field6)
- point (Field7)
- ord_type (Field8)
order detail (Untitled4)
- det_no (Key) — Primary key — NOT NULL
- ord_no (Key2) — Foreign key → order.ord_no — NOT NULL
- user_id (userId) — Foreign key → order.user_id — NOT NULL
- prd_no (Field)
- ord_qty (Field2)
product
- prd_no (prdNo) — Primary key — NOT NULL
- bas_no (Key) — Foreign key → basket.bas_no — NOT NULL
- user_id (userId) — Foreign key → basket.user_id — NOT NULL
- det_no (Key2) — Foreign key → order detail.det_no — NOT NULL
- ord_no (Key22) — Foreign key → order detail.ord_no — NOT NULL
- user_id (userId2) — Foreign key → order detail.user_id — NOT NULL
- prd_name (prdName)
- prd_ctgr (prdCtgr)
- prd_price (prdPrice)
- prd_desc (prdDesc)
- cat_no (Key3) — Foreign key → category.cat_no — NOT NULL