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