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