furniture
Tables (9)
board1
- b_idx — int(11) — Primary key — NOT NULL
- b_title — varchar(100)
- b_email — varchar(50)
- b_content — varchar(2048)
- b_regdate — datetime
- b_hit — int(11)
- b_ip — varchar(100)
comment1
- c_idx — int(11) — Primary key — NOT NULL
- c_userID — varchar(20)
- c_boardidx — int(11)
- c_content — varchar(100)
- c_regdate — datetime
- c_ip — varchar(20)
mem_order
- order_num — int(11) — Primary key — NOT NULL
- order_pd_category_id — int(11) — Foreign key → product_category.pd_category_id
- order_pd_num — int(11) — Foreign key → product.pd_num
- order_pd_option — varchar(100)
- order_date — date
- order_mem_name — varchar(20)
- order_mem_id — varchar(20)
- order_mem_addr1 — varchar(200)
- order_mem_addr2 — varchar(200)
member
- mem_id — varchar(20) — Primary key — NOT NULL
- mem_pwd — varchar(100)
- mem_name — varchar(20)
- mem_birth — varchar(30)
- mem_tel — varchar(30)
- mem_email — varchar(50)
- mem_addr1 — varchar(200)
- mem_addr2 — varchar(200)
product
- pd_num — int(11) — Primary key — NOT NULL
- pd_category_id — int(11) — Foreign key → product_category.pd_category_id
- pd_category_name — varchar(50)
- pd_kr_name — varchar(40)
- pd_eng_name — varchar(40)
- pd_price — int(11)
- pd_qt — int(11)
- pd_sale — int(11)
- pd_like — int(11)
- pd_main_img — varchar(100)
- pd_sub_img1 — varchar(100)
- pd_sub_img2 — varchar(100)
- pd_sub_img3 — varchar(100)
- pd_sub_img4 — varchar(100)
- pd_top_info — varchar(512)
product_category
- pd_category_id — int(11) — Primary key — NOT NULL
- pd_category_name — varchar(30)
- pd_category_kr_name — varchar(30)
product_detail
- pd_num — int(11) — Foreign key → product.pd_num
- pd_info — varchar(2048)
- pd_enviro — varchar(2048)
- pd_package — varchar(1024)
- pd_rate — int(11)
record
- record_num — int(11) — Primary key — NOT NULL
- record_mem_id — varchar(20) — Foreign key → member.mem_id
- record_content — varchar(2048)
- record_date — datetime
- record_category — varchar(50)
report
- report_num — int(11) — Primary key — NOT NULL
- report_mem_id — varchar(20) — Foreign key → member.mem_id
- report_title — varchar(100)
- report_content — varchar(2048)
- report_date — datetime