11111111111
Tables (8)
board
- board_id — INT — Primary key
- b_user_id — INT — Foreign key → customer.user_id — NOT NULL
- b_item_id — INT — Foreign key → product.item_id — NOT NULL
- n_type — VARCHAR(1) — NOT NULL
- title — VARCHAR(100) — NOT NULL
- board_date — DATETIME
- content — VARCHAR(300) — NOT NULL
- rate — INT
cart
- cart_id — INT — Primary key
- c_user_id — INT — Foreign key → customer.user_id — NOT NULL
- c_item_id — INT — Foreign key → product.item_id — NOT NULL
- cnt — INT
- price_sum — INT
- item_id (item_id2) — INT — Foreign key → product.item_id — NOT NULL
customer
- user_id — INT — Primary key — NOT NULL
- user_email — VARCHAR(50) — NOT NULL
- user_name — VARCHAR(15) — NOT NULL
- user_pwd — VARCHAR(150) — NOT NULL
- user_phonenum — VARCHAR(15) — NOT NULL
- user_gender — ENUM('남성', '여성', '기타')
delivery
- delivery_id — INT — Primary key
- d_order_id — INT — Foreign key → orders.order_id
- takep_name — VARCHAR(15) — NOT NULL
- takep_phonenum — VARCHAR(15) — NOT NULL
- takep_address — TEXT — NOT NULL
- takep_request — VARCHAR(100)
- deliver_action — VARCHAR(20)
orders
- order_id — INT — Primary key
- o_user_id — INT — Foreign key → customer.user_id — NOT NULL
- o_item_id — INT — Foreign key → orders_item.orders_item — NOT NULL
- o_cnt — INT
- o_price_sum — INT
- order_date — DATETIME
orders_item
- orders_item — INT — Primary key
- oi_item_id — INT — Foreign key → product.item_id
product
- item_id — INT — Primary key — NOT NULL
- item_name — VARCHAR(150) — NOT NULL
- item_exp — TEXT
- img — TEXT
- item_price — INT — NOT NULL
- cnt — INT
- category_name — VARCHAR(30) — NOT NULL
wish
- wish_id — INT — Primary key
- w_user_id — INT — Foreign key → customer.user_id — NOT NULL
- w_item_id — INT — Foreign key → product.item_id — NOT NULL