BT
Tables (9)
delivery
- d_num — int — Primary key — NOT NULL
- m_id — varchar(15) — Foreign key → member.m_id
- d_name — varchar(20) — NOT NULL
- d_phone — varchar(20) — NOT NULL
- d_addr1 — varchar(10) — NOT NULL
- d_addr2 — varchar(100) — NOT NULL
- d_addr3 — varchar(100) — NOT NULL
member
- m_id — varchar(15) — Primary key
- m_pw — varchar(15) — NOT NULL
- m_name — varchar(15) — NOT NULL
- m_birth — varchar(20)
- m_phone — varchar(20) — NOT NULL
- m_addr1 — varchar(10) — NOT NULL
- m_addr2 — varchar(100) — NOT NULL
- m_addr3 — varchar(100) — NOT NULL
- m_grade — varchar(10) — NOT NULL
- m_yn — int(10)
notice
- n_num — int — Primary key — NOT NULL
- n_name — varchar(15) — Foreign key → member.m_id
- n_pw — varchar(15) — NOT NULL
- n_tit — varchar(20) — NOT NULL
- n_cont — varchar(1000) — NOT NULL
- n_file — varchar(50) — NOT NULL
- n_date — date — NOT NULL
order_item
- oi_num — int — Primary key — NOT NULL
- o_num — int — Foreign key → p_order.o_num — NOT NULL
- p_num — varchar(20) — Foreign key → product.p_num
- oi_qty — int
p_inout
- i_num — int — Primary key — NOT NULL
- oi_num — int — Foreign key → order_item.oi_num — NOT NULL
- p_num — varchar(20) — Foreign key → product.p_num
- i_date — date — NOT NULL
- i_status — varchar(10)
- p_qty — int
p_order
- o_num — int — Primary key — NOT NULL
- m_id — varchar(15) — Foreign key → member.m_id
- d_num — int — Foreign key → delivery.d_num — NOT NULL
- o_status — varchar(20) — NOT NULL
- o_date — date — NOT NULL
- o_total — int
- o_fee — int
- o_memo — varchar(50)
p_qna
- q_id — int — Primary key — NOT NULL
- m_id — varchar(15) — Foreign key → member.m_id
- p_num — varchar(20) — Foreign key → product.p_num
- q_pw — varchar(15) — NOT NULL
- q_tit — varchar(20) — NOT NULL
- q_cont — varchar(1000) — NOT NULL
- q_file — varchar(50) — NOT NULL
- q_ref — int — NOT NULL
- q_lev — int — NOT NULL
- q_step — int — NOT NULL
- q_date — date — NOT NULL
p_rev
- r_id — int — Primary key — NOT NULL
- m_id — varchar(15) — Foreign key → member.m_id
- p_num — varchar(20) — Foreign key → product.p_num
- r_cont — varchar(500) — NOT NULL
- r_file — varchar(50) — NOT NULL
- r_date — date — NOT NULL
product
- p_num — varchar(20) — Primary key
- c_num — varchar(15) — NOT NULL
- p_name — varchar(20) — NOT NULL
- p_img1 — varchar(500) — NOT NULL
- p_img2 — varchar(500)
- p_img3 — varchar(500)
- p_price — int — NOT NULL
- p_onoff — int
- p_saleyn — int