공생 ERD

테이블 (20)

게시판 (board)

  • board_idx — INT — 기본 키 — NOT NULL
  • member_id — VARCHAR(500) — 외래 키 → 회원.member_id — NOT NULL
  • board_subject — VARCHAR(100) — NOT NULL
  • board_content — VARCHAR(1000) — NOT NULL
  • board_date — DATETIME — NOT NULL
  • board_main_category — INT — NOT NULL
  • board_sub_category — INT — NOT NULL
  • board_img1 — VARCHAR(500)
  • board_img2 — VARCHAR(500)
  • board_img3 — VARCHAR(500)
  • board_readcount — INT — NOT NULL

결제 (payment)

  • pay_num — VARCHAR(100) — 기본 키 — NOT NULL
  • res_num — INT
  • com_idx — INT — 외래 키 → 사업체.com_idx — NOT NULL
  • class_idx — INT — 외래 키 → 클래스.class_idx — NOT NULL
  • member_id — VARCHAR(500) — 외래 키 → 회원.member_id — NOT NULL
  • payment — INT — NOT NULL
  • discount_payment — INT — NOT NULL
  • pay_method — VARCHAR(100) — NOT NULL
  • pay_date — DATETIME — NOT NULL
  • pay_card_co — VARCHAR(100)
  • per_Info_consent — TINYINT — NOT NULL
  • pay_status — INT — NOT NULL
  • pay_category — INT — NOT NULL
  • pay_cal_status — INT — NOT NULL
  • res_visit_date — VARCHAR(100) — NOT NULL
  • res_visit_time — VARCHAR(100) — NOT NULL
  • res_member_count — INT — NOT NULL
  • refund_request_date — DATETIME
  • refund_date — DATETIME

계좌 (account)

  • account_idx — INT — 기본 키 — NOT NULL
  • member_id — VARCHAR(500) — 외래 키 → 회원.member_id — NOT NULL
  • access_token — VARCHAR(500) — NOT NULL
  • refresh_token — VARCHAR(500) — NOT NULL
  • user_seq_no — VARCHAR(100) — NOT NULL
  • account_user_ci — VARCHAR(100)
  • account_user_name — VARCHAR(100) — NOT NULL
  • fintech_use_num — VARCHAR(100) — NOT NULL
  • account_num_masked — VARCHAR(100) — NOT NULL
  • account_bank — VARCHAR(100)
  • account_date — DATETIME

댓글 (tiny_reply_community)

  • reply_idx — INT — 기본 키 — NOT NULL
  • board_idx — INT — 외래 키 → 게시판.board_idx — NOT NULL
  • member_id — VARCHAR(500) — 외래 키 → 회원.member_id — NOT NULL
  • reply_content — VARCHAR(1000) — NOT NULL
  • reply_re_ref — INT — NOT NULL
  • reply_re_lev — INT — NOT NULL
  • reply_re_seq — INT — NOT NULL
  • reply_date — DATETIME — NOT NULL

리뷰 (review)

  • review_idx — INT — 기본 키 — NOT NULL
  • member_id — VARCHAR(500) — 외래 키 → 회원.member_id — NOT NULL
  • review_content — VARCHAR(1000) — NOT NULL
  • review_score — DOUBLE — NOT NULL
  • pay_num — VARCHAR(100) — 외래 키 → 결제.pay_num
  • class_idx — INT — 외래 키 → 클래스.class_idx — NOT NULL
  • review_regdate — DATETIME — NOT NULL
  • review_img_1 — VARCHAR(500)
  • review_status — INT
  • review_tags (review_kind) — INT — NOT NULL
  • review_like — TINYINT — NOT NULL
  • review_like_count — INT — NOT NULL

리뷰 답글 (comment)

  • comment_num — INT — 기본 키 — NOT NULL
  • review_idx — INT — 외래 키 → 리뷰.review_idx — NOT NULL
  • member_id — VARCHAR(500) — 외래 키 → 회원.member_id — NOT NULL
  • comment_category — INT — NOT NULL
  • comment_content — VARCHAR(1000) — 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

메일인증 (mail_auth)

  • mail_auth_idx — INT — 기본 키 — NOT NULL
  • member_id — VARCHAR(500) — 외래 키 → 회원.member_id
  • mail_auth_code — VARCHAR(500) — NOT NULL
  • mail_auth_email — VARCHAR(500)

북마크 (bookmark)

  • bookmark_idx — INT — 기본 키 — NOT NULL
  • member_id — VARCHAR(500) — 외래 키 → 회원.member_id — NOT NULL
  • class_idx — INT — 외래 키 → 클래스.class_idx — NOT NULL

사업체 (company)

  • com_idx — INT — 기본 키 — NOT NULL
  • com_img — VARCHAR(500)
  • member_id — VARCHAR(500) — 외래 키 → 회원.member_id — NOT NULL
  • com_name — VARCHAR(100) — NOT NULL
  • com_category — VARCHAR(100) — NOT NULL
  • com_post_code — VARCHAR(10) — NOT NULL
  • com_address1 — VARCHAR(100) — NOT NULL
  • com_address2 — VARCHAR(100) — NOT NULL
  • com_tel — VARCHAR(100) — NOT NULL
  • com_email — VARCHAR(100)
  • com_introduction — VARCHAR(1000)
  • com_bank — VARCHAR(100) — NOT NULL
  • com_account — VARCHAR(100) — NOT NULL
  • com_account_name — VARCHAR(100) — NOT NULL
  • com_status — INT — NOT NULL
  • com_date — DATETIME — NOT NULL

신고 (report)

  • report_idx — INT — 기본 키 — NOT NULL
  • review_idx — INT — 외래 키 → 리뷰.review_idx
  • class_idx — INT — 외래 키 → 클래스.class_idx
  • member_id — VARCHAR(500) — 외래 키 → 회원.member_id — NOT NULL
  • report_reason — INT — NOT NULL
  • report_content — VARCHAR(1000) — NOT NULL
  • member_email — VARCHAR(100) — NOT NULL
  • report_status — INT — NOT NULL
  • member_phone — VARCHAR(100)
  • report_category — INT — NOT NULL
  • report_date — DATETIME — NOT NULL

알림 (alert)

  • alert_idx — INT — 기본 키 — NOT NULL
  • member_id — VARCHAR(500) — 외래 키 → 회원.member_id — NOT NULL
  • alert_content — VARCHAR(1000) — NOT NULL
  • alert_category — INT — NOT NULL
  • alert_datetime — DATETIME — NOT NULL
  • alert_read — INT — NOT NULL

장바구니 (cart)

  • cart_idx — INT — 기본 키 — NOT NULL
  • member_id — VARCHAR(500) — 외래 키 → 회원.member_id — NOT NULL
  • class_idx — INT — 외래 키 → 클래스.class_idx — NOT NULL
  • res_visit_date — VARCHAR(100) — NOT NULL
  • res_visit_time — VARCHAR(100) — NOT NULL
  • res_member_count — INT — NOT NULL

채팅 (chat)

  • chat_idx — INT — 기본 키 — NOT NULL
  • list_idx — INT — 외래 키 → 채팅방.list_idx — NOT NULL
  • chat_date — DATETIME(3) — NOT NULL
  • chat_content — VARCHAR(1000) — NOT NULL
  • chat_sender — VARCHAR(100) — NOT NULL
  • chat_receiver — VARCHAR(100) — NOT NULL
  • chat_read — INT — NOT NULL

채팅방 (chat_list)

  • list_idx — INT — 기본 키 — NOT NULL
  • list_date — DATETIME — NOT NULL
  • member_id — VARCHAR(500) — 외래 키 → 회원.member_id — NOT NULL

캐쉬 (cash)

  • cash_idx — INT — 기본 키 — NOT NULL
  • member_id — VARCHAR(500) — 외래 키 → 회원.member_id — NOT NULL
  • cash_value — INT — NOT NULL
  • cash_category — INT — NOT NULL
  • cash_reason — VARCHAR(100) — NOT NULL
  • cash_date — DATETIME — NOT NULL

쿠폰 (coupon)

  • coupon_idx — INT — 기본 키 — NOT NULL
  • coupon_name — VARCHAR(500) — NOT NULL
  • member_id — VARCHAR(500) — 외래 키 → 회원.member_id — NOT NULL
  • com_idx — INT — 외래 키 → 사업체.com_idx — NOT NULL
  • coupon_value — DOUBLE — NOT NULL
  • coupon_Issue_date — DATE — NOT NULL
  • coupon_valid_date — DATE — NOT NULL
  • coupon_status — INT — NOT NULL
  • coupon_min_price — VARCHAR(100) — NOT NULL

클래스 (class)

  • class_idx — INT — 기본 키 — NOT NULL
  • member_id — VARCHAR(500) — 외래 키 → 회원.member_id — NOT NULL
  • class_title — VARCHAR(100) — NOT NULL
  • class_category — INT — NOT NULL
  • class_times — INT — NOT NULL
  • class_price — VARCHAR(100) — NOT NULL
  • class_date — DATE — NOT NULL
  • class_start_time — TIME — NOT NULL
  • class_end_time — TIME — NOT NULL
  • class_start_date — DATE — NOT NULL
  • class_end_date — DATE — NOT NULL
  • class_day — VARCHAR(100) — NOT NULL
  • class_member_count — INT — NOT NULL
  • class_pic1 — VARCHAR(500) — NOT NULL
  • class_post_code — VARCHAR(100)
  • class_address1 — VARCHAR(100) — NOT NULL
  • class_address2 — VARCHAR(100) — NOT NULL
  • class_introduction — VARCHAR(500) — NOT NULL
  • class_curriculum1 — VARCHAR(500) — NOT NULL
  • class_curriculum_detail1 — VARCHAR(500) — NOT NULL
  • class_main_category — INT — NOT NULL
  • class_sub_category — VARCHAR(100) — NOT NULL
  • class_offering — VARCHAR(500)
  • class_caution — VARCHAR(1000)
  • class_tag — VARCHAR(1000)
  • class_question1 — VARCHAR(500)
  • class_answer1 — VARCHAR(500)

팔로잉 (following)

  • following_idx — INT — 기본 키 — NOT NULL
  • member_id — VARCHAR(500) — 외래 키 → 회원.member_id — NOT NULL
  • com_idx — INT — 외래 키 → 사업체.com_idx — NOT NULL

포인트 (point)

  • point_idx — INT — 기본 키 — NOT NULL
  • member_id — VARCHAR(500) — 외래 키 → 회원.member_id — NOT NULL
  • point_value — INT — NOT NULL
  • point_category — INT — NOT NULL
  • point_reason — VARCHAR(100)
  • point_status — INT — NOT NULL
  • point_date — DATETIME — NOT NULL

회원 (member)

  • member_id — VARCHAR(500) — 기본 키 — NOT NULL
  • member_passwd — VARCHAR(100)
  • member_nick — VARCHAR(100) — NOT NULL
  • member_email — VARCHAR(100) — NOT NULL
  • member_name — VARCHAR(100) — NOT NULL
  • member_birthday — VARCHAR(100) — NOT NULL
  • member_gender — INT — NOT NULL
  • member_phone — VARCHAR(100)
  • member_img — VARCHAR(500)
  • member_status — INT — NOT NULL
  • member_category — INT — NOT NULL
  • member_date — DATETIME — NOT NULL
  • member_alert_status — VARCHAR(100) — NOT NULL