cool - 2022-10-27 16:20:59
Tables (5)
customer (Untitled)
- c_id (Key) — varchar(30) — Primary key — NOT NULL
- c_name (Field) — varchar(30)
- c_pw (Field2) — varchar(30)
- c_email (Field3) — varchar(40)
- c_pnum (Field4) — varchar(30)
item (Untitled2)
- i_num (Key) — int — Primary key — NOT NULL
- i_id (Key2) — varchar(30) — Foreign key → customer.c_id — NOT NULL
- i_pic (Field) — varchar(30)
- i_name (Field3) — varchar(30)
- i_price (Field4) — int
- i_type (Field5) — varchar(30)
- i_intro (Field6) — varchar(100)
- i_date (Field7) — varchar(30)
- i_ing (Field2) — varchar(10)
od (order)
- o_num (Key) — int — Primary key — NOT NULL
- o_sellid (Key4) — varchar(30) — Foreign key → customer.c_id — NOT NULL
- o_inum (Key5) — int — Foreign key → item.i_num — NOT NULL
- o_buyid (Key22) — varchar(30) — Foreign key → item.i_id — NOT NULL
- o_date (Field3) — varchar(30)
- o_price (Field4) — int
- o_item (Field5) — int
s_log (search log)
- s_id (Key2) — varchar(30) — Foreign key → customer.c_id — NOT NULL
- s_key (Field) — varchar(30)
wish (wish list)
- w_id (Key3) — varchar(30) — Foreign key → customer.c_id — NOT NULL
- w_inum (Key4) — int — Foreign key → item.i_num — NOT NULL