테이블찜콩 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