ggd

테이블 (26)

1:1 문의 (board_tbl)

  • board_code — bigint — 기본 키 — NOT NULL
  • product_code — bigint — NOT NULL
  • bnid — varchar(255) — NOT NULL
  • bnphonenum — varchar(20) — NOT NULL
  • board_content — varchar(300) — NOT NULL
  • board_date — datetime(6)
  • board_title — varchar(50) — NOT NULL
  • board_type — varchar(30) — NOT NULL
  • used_code — bigint — NOT NULL
  • productcode — bigint — NOT NULL

1:1 문의 파일 (board_file_tbl)

  • board_file_id — bigint — 기본 키 — NOT NULL
  • board_file_num (board_code) — bigint — 외래 키 → 1:1 문의.board_code — NOT NULL
  • board_file_oriname — varchar(50) — NOT NULL
  • board_file_sysname — varchar(50) — NOT NULL

Admin (member)

  • mid — varchar(255) — 기본 키 — NOT NULL
  • mmail — varchar(30) — NOT NULL
  • mname — varchar(20) — NOT NULL
  • mphone — varchar(20) — NOT NULL
  • mpwd — varchar(100) — NOT NULL

bmember_tbl

  • b_id — varchar(255) — 기본 키 — NOT NULL
  • b_address — varchar(100) — NOT NULL
  • b_baccunt — varchar(20) — NOT NULL
  • b_banknum — varchar(50) — NOT NULL
  • b_bday — varchar(10) — NOT NULL
  • b_breality — varchar(10) — NOT NULL
  • b_btype — varchar(20) — NOT NULL
  • b_cname — varchar(50) — NOT NULL
  • b_cnum — varchar(50) — NOT NULL
  • b_email — varchar(100) — NOT NULL
  • b_gender — int — NOT NULL
  • b_memail — varchar(100)
  • b_mname — varchar(10)
  • b_mphonenum — varchar(20)
  • b_name — varchar(10) — NOT NULL
  • b_phonenum — varchar(20) — NOT NULL
  • b_pw — varchar(100) — NOT NULL
  • b_pwcheck — varchar(100) — NOT NULL
  • b_signdt — datetime(6)
  • bsituation — varchar(255)
  • b_status — varchar(255)
  • b_ttype — varchar(30) — NOT NULL

bproduct_tbl

  • bpnum — bigint — 기본 키 — NOT NULL
  • b_id (bseller_id) — varchar(255) — 외래 키 → bmember_tbl.b_id — NOT NULL
  • bcondition — varchar(255)
  • bpdate — varchar(10) — NOT NULL
  • bpexplanation — varchar(2000) — NOT NULL
  • bpmaterial — varchar(50)
  • bpname — varchar(100) — NOT NULL
  • bpprestriction — int — NOT NULL
  • bpprice — int — NOT NULL
  • bprobid — varchar(255) — NOT NULL
  • bproduct_file_sysnamem — varchar(50)
  • bp_signdt — datetime(6)
  • bpsize — varchar(50)
  • bpwarestock — int — NOT NULL
  • bpwarstockdeduct — varchar(255)

bproductfile_tbl

  • bproductfilecode — bigint — 기본 키 — NOT NULL
  • bpnum (bproductfilenum) — bigint — 외래 키 → bproduct_tbl.bpnum — NOT NULL
  • b_id — varchar(255) — 외래 키 → bproduct_tbl.b_id — NOT NULL
  • bproductfileoriname — varchar(50) — NOT NULL
  • bproductfilesysname — varchar(50) — NOT NULL

cart_tbl

  • cart_code — bigint — 기본 키 — NOT NULL
  • n_id (cnid) — varchar(255) — 외래 키 → nmember_tbl.n_id — NOT NULL
  • cart_data — datetime(6)
  • product_stock — int — NOT NULL
  • quantity — int — NOT NULL
  • used_stock — int — NOT NULL
  • bpnum — bigint — 외래 키 → bproduct_tbl.bpnum — NOT NULL
  • used_code — bigint — 외래 키 → used_product_tbl.used_code — NOT NULL

category_tbl

  • category_code — bigint — 기본 키 — NOT NULL
  • category_code2 — bigint
  • category_name — varchar(30) — NOT NULL

dibs_tbl

  • dibs_code — bigint — 기본 키 — NOT NULL
  • n_id (dnid) — varchar(255) — 외래 키 → nmember_tbl.n_id — NOT NULL
  • dibs_date — datetime(6) — NOT NULL
  • bpnum — bigint — 외래 키 → bproduct_tbl.bpnum — NOT NULL
  • used_code — bigint — 외래 키 → used_product_tbl.used_code — NOT NULL

dmfile_tbl

  • df_num — bigint — 기본 키 — NOT NULL
  • dnum — bigint — 외래 키 → dmsg_tbl.dnum — NOT NULL
  • df_oriname — varchar(50) — NOT NULL
  • df_sysname — varchar(50) — NOT NULL
  • df_uid — bigint — NOT NULL

dmsg_tbl

  • dnum — bigint — 기본 키 — NOT NULL
  • c_date — datetime(6)
  • d_comment — varchar(255)
  • d_content — varchar(255)
  • d_status — varchar(255)
  • d_title — varchar(255)
  • r_date — datetime(6)
  • d_uid (n_id) — varchar(255) — 외래 키 → nmember_tbl.n_id — NOT NULL

iwc_comment_tbl

  • iwc_comment_id — bigint — 기본 키 — NOT NULL
  • iwc_code — bigint — 외래 키 → iwc_tbl.iwc_code — NOT NULL
  • n_id (user_id) — varchar(255) — 외래 키 → nmember_tbl.n_id — NOT NULL
  • created_at — datetime(6)
  • iwc_comment_content — varchar(255) — NOT NULL
  • iwc_contents_category — varchar(255)
  • iwc_contents_code — bigint
  • iwc_contents_name — varchar(255)

iwc_contents_tbl

  • iwc_contents_code — bigint — 기본 키 — NOT NULL
  • iwc_code (iwc_contents_iwc_code) — bigint — 외래 키 → iwc_tbl.iwc_code — NOT NULL
  • n_id — varchar(255) — 외래 키 → iwc_tbl.n_id — NOT NULL
  • iwc_content_finalcount — bigint
  • iwc_content_vscount — bigint
  • iwc_content_wincount — bigint
  • iwc_contents_name — varchar(50)
  • iwc_contents_oriname — varchar(50) — NOT NULL
  • iwc_contents_sysname — varchar(50) — NOT NULL
  • iwc_contents_category (category_code) — bigint — 외래 키 → category_tbl.category_code — NOT NULL

iwc_like_tbl

  • iwc_like_id — bigint — 기본 키 — NOT NULL
  • iwc_code — bigint — 외래 키 → iwc_tbl.iwc_code — NOT NULL
  • n_id (like_nid) — varchar(255) — 외래 키 → nmember_tbl.n_id — NOT NULL
  • iwc_like_date — datetime(6)

iwc_tbl

  • iwc_code — bigint — 기본 키 — NOT NULL
  • n_id — varchar(255) — 외래 키 → nmember_tbl.n_id — NOT NULL
  • iwc_complete — bigint
  • iwc_date — datetime(6)
  • iwc_explanation — varchar(100) — NOT NULL
  • iwc_first_image — varchar(50)
  • iwc_first_name — varchar(50)
  • iwc_genre — varchar(100)
  • iwc_like — bigint
  • iwc_name — varchar(50) — NOT NULL
  • iwc_public — int
  • iwc_second_image — varchar(50)
  • iwc_second_name — varchar(50)
  • iwc_views — bigint

nmember_tbl

  • n_id — varchar(255) — 기본 키 — NOT NULL
  • n_address — varchar(200) — NOT NULL
  • n_bday — varchar(10) — NOT NULL
  • n_email — varchar(100) — NOT NULL
  • n_gender — int — NOT NULL
  • n_name — varchar(10) — NOT NULL
  • n_nickname — varchar(30) — NOT NULL
  • n_phonenum — varchar(20) — NOT NULL
  • n_pw — varchar(100) — NOT NULL
  • n_pwcheck — varchar(100) — NOT NULL
  • n_signdt — datetime(6)
  • nsituation — varchar(255) — NOT NULL
  • n_status (ug_id) — int — 외래 키 → usergrade_tbl.ug_id — NOT NULL

notice_file_tbl

  • nf_num — bigint — 기본 키 — NOT NULL
  • n_num (nf_aid) — bigint — 외래 키 → notice_tbl.n_num — NOT NULL
  • nf_oriname — varchar(50) — NOT NULL
  • nf_sysname — varchar(50) — NOT NULL

notice_tbl

  • n_num — bigint — 기본 키 — NOT NULL
  • is_pinned — int
  • n_content — varchar(255)
  • n_title — varchar(255)
  • r_date — datetime(6)
  • n_admin_id (mid) — varchar(255) — 외래 키 → Admin.mid — NOT NULL

order_detail_tbl

  • order_detail_id — bigint — 기본 키 — NOT NULL
  • price — int
  • product_name — varchar(255)
  • product_where — varchar(255)
  • quantity — int
  • seller_id — varchar(255)
  • total_price — int
  • order_id — bigint — 외래 키 → order_tbl.order_id — NOT NULL
  • product_code (bpnum) — bigint — 외래 키 → bproduct_tbl.bpnum — NOT NULL
  • product_code (used_code) — bigint — 외래 키 → used_product_tbl.used_code — NOT NULL

order_tbl

  • order_id — bigint — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • payment_method — varchar(255)
  • payment_status — varchar(255)
  • provider — varchar(255)
  • status — varchar(255)
  • total_amount — int
  • transaction_id — varchar(255)
  • updated_at — datetime(6)
  • user_name — varchar(255)
  • n_id (user_id) — varchar(255) — 외래 키 → nmember_tbl.n_id — NOT NULL

report_file_tbl

  • rf_num — bigint — 기본 키 — NOT NULL
  • r_num — bigint — 외래 키 → report_tbl.r_num — NOT NULL
  • n_id — varchar(255) — 외래 키 → report_tbl.n_id — NOT NULL
  • rf_oriname — varchar(50) — NOT NULL
  • rf_sysname — varchar(50) — NOT NULL

report_tbl

  • r_num — bigint — 기본 키 — NOT NULL
  • n_id (r_uid) — varchar(255) — 외래 키 → nmember_tbl.n_id — NOT NULL
  • from_code — bigint
  • r_content — varchar(255)
  • r_date — datetime(6)
  • r_from — varchar(255)
  • r_reason — varchar(255)
  • r_status — varchar(255)

uproductreview_tbl

  • u_num — bigint — 기본 키 — NOT NULL
  • n_id (u_id) — varchar(255) — 외래 키 → nmember_tbl.n_id — NOT NULL
  • u_preivew — varchar(255)
  • u_product — varchar(255)
  • u_rdate — datetime(6)
  • used_code (u_code) — bigint — 외래 키 → used_product_tbl.used_code — NOT NULL

used_product_tbl

  • used_code — bigint — 기본 키 — NOT NULL
  • n_id — varchar(255) — 외래 키 → nmember_tbl.n_id — NOT NULL
  • used_date — datetime(6)
  • used_detail — varchar(200) — NOT NULL
  • used_limit — int — NOT NULL
  • used_name — varchar(40) — NOT NULL
  • used_seller — int — NOT NULL
  • used_stock — int — NOT NULL
  • category_code — varchar(255) — NOT NULL
  • usedseller_id — varchar(255) — NOT NULL

usedproduct_file_tbl

  • used_file_code — bigint — 기본 키 — NOT NULL
  • used_code — bigint — 외래 키 → used_product_tbl.used_code — NOT NULL
  • n_id — varchar(255) — 외래 키 → used_product_tbl.n_id — NOT NULL
  • used_file_num — bigint — NOT NULL
  • used_file_oriname — varchar(50) — NOT NULL
  • used_file_sysname — varchar(50) — NOT NULL

usergrade_tbl

  • ug_id — int — 기본 키 — NOT NULL
  • ug_duration — bigint
  • ug_name — varchar(255)