공생 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