erd1
Tables (3)
order (주문)
- order_id (Key) — int(11) — Primary key — NOT NULL
- user_id (Key2) — varchar(55) — Foreign key → user.user_id — NOT NULL
- product_id — int(11) — Foreign key → product.product_id — NOT NULL
- order_date (Field2) — Date
- sum_price (Field3) — int(11)
- order_state (Field4) — varchar(20)
product (제품)
- product_id — int(11) — Primary key — NOT NULL
- product_name — varchar(55) — NOT NULL
- product_price (Field) — int(11) — NOT NULL
- category (Field2) — varchar(55)
user (회원)
- user_id (Key) — varchar(55) — Primary key — NOT NULL
- user_pw (Field) — varchar(55)
- user_name (Field2) — varchar(55)
- address (Field3) — varchar(100)
- phone (Field4) — varchar(55)
- homrtel (Field5) — varchar(55)