furniture
Tables (5)
member
- mem_id — varchar(20)
- mem_pwd — varchar(20)
- mem_name — varchar(20)
- mem_birth — varchar(30)
- mem_tel — varchar(30)
- mem_email — varchar(50)
- mem_addr1 — varchar(200)
- mem_addr2 — varchar(200)
orderManage
- order_num — int
- order_pd_name — varchar(40)
- order_date — datetime
- order_mem_name — varchar(20)
- order_mem_id — varchar(20)
- order_mem_address — varchar(200)
product
- pd_num — varchar(20)
- pd_main_category — varchar(50)
- pd_sub_category — varchar(50)
- pd_kr_name — varchar(40)
- pd_price — int
- pd_qt — int
- pd_sale — int
- pd_like — int
- 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)
productDetail
- pd_num — varchar(20)
- pd_info — varchar(1000)
- pd_enviro — varchar(1000)
- pd_package — varchar(500)
- pd_rate — int
record
- record_num — int
- record_title — varchar(100)
- record_content — varchar(2048)
- record_date — datetime