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)