테이블찜콩 ERD
테이블 (13)
결제 (payment)
- pay_idx — INT — 기본 키 — NOT NULL
- pay_num — VARCHAR(200) — NOT NULL
- res_idx — INT — 외래 키 → 예약.res_idx — NOT NULL
- user_idx — INT — 외래 키 → 회원.user_idx — NOT NULL
- pay_method — INT — NOT NULL
- pay_per_price — INT — NOT NULL
- pay_po_price — INT — NOT NULL
- pay_date — DATETIME — NOT NULL
- pay_card_co — VARCHAR(200)
- per_Info_consent — TINYINT — NOT NULL
- pay_status — INT — NOT NULL
- pay_on_site — INT — NOT NULL
고객센터 (cs_board)
- cs_board_num — INT — 기본 키 — NOT NULL
- user_id — VARCHAR(200) — 외래 키 → 회원.user_id — NOT NULL
- cs_board_subject — VARCHAR(1000) — NOT NULL
- cs_board_content — VARCHAR(5000) — NOT NULL
- cs_board_re_ref — INT — NOT NULL
- cs_board_re_lev — INT — NOT NULL
- cs_board_re_seq — INT — NOT NULL
- cs_board_readcount — INT — NOT NULL
- cs_board_date — DATETIME — NOT NULL
- cs_board_category_user — INT — NOT NULL
- cs_board_category_main — INT — NOT NULL
- cs_board_category_sub — INT — NOT NULL
- cs_board_img_1 — VARCHAR(2000)
- cs_board_img_2 — VARCHAR(2000)
- cs_board_img_3 — VARCHAR(2000)
- cs_board_img_4 — VARCHAR(2000)
- cs_board_img_5 — VARCHAR(2000)
댓글 (comment)
- comment_num — INT — 기본 키 — NOT NULL
- review_num — INT — 외래 키 → 리뷰.review_num — NOT NULL
- user_id — VARCHAR(200) — 외래 키 → 회원.user_id — NOT NULL
- comment_category — INT — NOT NULL
- comment_content — VARCHAR(5000) — NOT NULL
- comment_update — DATETIME — NOT NULL
- comment_status — INT — NOT NULL
- comment_re_ref — INT — NOT NULL
- comment_re_lev — INT — NOT NULL
- comment_re_seq — INT — NOT NULL
리뷰 (review)
- review_num — INT — 기본 키 — NOT NULL
- res_idx — INT — 외래 키 → 예약.res_idx — NOT NULL
- user_id — VARCHAR(200) — 외래 키 → 회원.user_id — NOT NULL
- com_id — INT — 외래 키 → 업체.com_id — NOT NULL
- review_hits — INT — NOT NULL
- review_subject — VARCHAR(1000) — NOT NULL
- review_content — VARCHAR(5000) — NOT NULL
- review_score — INT — NOT NULL
- review_no_keyword (review_tags) — VARCHAT(20) — NOT NULL
- review_like — TINYINT — NOT NULL
- review_like_count — INT — NOT NULL
- review_update — DATETIME — NOT NULL
- review_img_1 — VARCHAR(2000)
- review_img_2 — VARCHAR(2000)
- review_img_3 — VARCHAR(2000)
- review_img_4 — VARCHAR(2000)
- review_img_5 — VARCHAR(2000)
- review_status — INT — NOT NULL
메뉴 (menu)
- menu_idx — INT — 기본 키 — NOT NULL
- com_id — INT — 외래 키 → 업체.com_id — NOT NULL
- menu_name — VARCHAR(200) — NOT NULL
- menu_price — INT — NOT NULL
- menu_describe — VARCHAR(2000)
- menu_img — VARCHAR(2000) — NOT NULL
메일인증 (email_auth)
- auth_idx — INT — 기본 키 — NOT NULL
- user_id — VARCHAR(200) — 외래 키 → 회원.user_id
- auth_code — VARCHAR(300) — NOT NULL
- user_email — VARCHAR(200) — 외래 키 → 회원.user_email
북마크 (bookmark)
- bookmark_idx — INT — 기본 키 — NOT NULL
- com_id — INT — 외래 키 → 업체.com_id — NOT NULL
- user_idx — INT — 외래 키 → 회원.user_idx — NOT NULL
선주문 (pre_order)
- pre_idx — INT — 기본 키 — NOT NULL
- res_idx — INT — 외래 키 → 예약.res_idx — NOT NULL
- menu_idx — INT — 외래 키 → 메뉴.menu_idx — NOT NULL
- pre_num — INT — NOT NULL
신고 (report)
- report_num — INT — 기본 키 — NOT NULL
- com_id — INT — 외래 키 → 업체.com_id
- review_num — INT — 외래 키 → 리뷰.review_num
- user_id — VARCHAR(200) — 외래 키 → 회원.user_id — NOT NULL
- report_reason — INT — NOT NULL
- report_person — INT — NOT NULL
- report_content — VARCHAR(5000) — NOT NULL
- user_email — VARCHAR(200)
- user_phone — VARCHAR(200)
- report_category — TINYINT — NOT NULL
- report_status — INT — NOT NULL
업체 (company)
- com_id — INT — 기본 키 — NOT NULL
- user_idx — INT — 외래 키 → 회원.user_idx — NOT NULL
- com_name — VARCHAR(200) — NOT NULL
- com_category — VARCHAR(200) — NOT NULL
- com_ceo — VARCHAR(200) — NOT NULL
- com_address — VARCHAR(500) — NOT NULL
- com_tel — VARCHAR(200) — NOT NULL
- com_gugun — VARCHAR(200) — NOT NULL
- com_open_time — VARCHAR(20)
- com_close_time — VARCHAR(20)
- com_breakStart_time — VARCHAR(20)
- com_breakEnd_time — VARCHAR(20)
- com_num — VARCHAR(100) — NOT NULL
- com_img — VARCHAR(2000) — NOT NULL
- com_max_people — INT — NOT NULL
- com_tag_window (com_tags) — VARCHAR(20) — NOT NULL
- com_hyg_rank — VARCHAR(200)
- com_hyg_start_date — DATE
- com_status — INT — NOT NULL
- com_ad_grade — INT — NOT NULL
- com_search_tag — VARCHAR(1000)
- com_reg_date — DATETIME — NOT NULL
- open_date — VARCHAR(10)
예약 (reservation)
- res_idx — INT — 기본 키 — NOT NULL
- res_num — VARCHAR(1000) — NOT NULL
- com_id — INT — 외래 키 → 업체.com_id — NOT NULL
- user_idx — INT — 외래 키 → 회원.user_idx — NOT NULL
- res_date — VARCHAR(1000) — NOT NULL
- res_time — VARCHAR(100) — NOT NULL
- res_table_price — INT — NOT NULL
- res_person — INT — NOT NULL
- res_name — VARCHAR(100) — NOT NULL
- res_phone — VARCHAR(45) — NOT NULL
- res_status — INT — NOT NULL
- res_now — DATETIME — NOT NULL
- res_pay_status — INT — NOT NULL
- res_request — VARCHAR(5000)
포인트 (point)
- point_idx — INT — 기본 키 — NOT NULL
- user_idx — INT — 외래 키 → 회원.user_idx — NOT NULL
- point_value — INT — NOT NULL
- point_category — INT — NOT NULL
- point_category_idx — INT
- point_status — INT — NOT NULL
- point_date — DATETIME — NOT NULL
회원 (user)
- user_idx — INT — 기본 키 — NOT NULL
- user_id — VARCHAR(200) — NOT NULL
- user_passwd — VARCHAR(200) — NOT NULL
- user_nick — VARCHAR(200)
- user_email — VARCHAR(200) — NOT NULL
- user_name — VARCHAR(200) — NOT NULL
- user_birth — DATE — NOT NULL
- com_num — VARCHAR(200)
- user_reg_date — DATETIME — NOT NULL
- user_phone — VARCHAR(200) — NOT NULL
- user_level — INT — NOT NULL
- user_img — VARCHAR(2000)
- user_status — INT — NOT NULL
- user_category — INT — NOT NULL