x-cubator
Tables (18)
account (계정)
- account_id (아이디) — Bigint — Primary key — NOT NULL
- username (이름) — varchar(50)
- email (이메일) — varchar(255)
- password (패스워드) — varchar(500)
- belong (소속) — varchar(50)
- phone_number (핸드폰번호) — varchar(11)
- profile_url (프로필주소) — varchar(500)
- role (권한) — varchar(20)
- is_enable (사용가능 여부) — bit(1)
- service_policy (서비스 이용 약관 동의) — bit(1)
- personal_info_policy (개인 정보 수집 및 이용 동의) — bit(1)
- over_14_years_old_policy (만 14세 이상입니다) — bit(1)
- sms_receive_agree (Sms 수신동의 여부) — bit(1)
- email_receive_agree (email 수신 동의 여부) — bit(1)
- created_at (생성날짜) — datetime(6)
- updated_at (수정날짜) — datetime(6)
- deleted_at (삭제날짜) — datetime(6)
- deleted_reason (탈퇴사유) — varchar(255)
- email_check (이메일인증) — bit(1)
- email_check_token (이메일인증 토큰) — varchar(255)
- email_check_expired (이메일인증 기간) — datetime(6)
- title (제목) — varchar(255)
- description (설명) — varchar(1000)
account_ additional_info (계정 추가 정보)
- account_ additional_info_id (아이디) — Bigint — Primary key — NOT NULL
- account_id (엑스큐베이터) — Bigint — Foreign key → account.account_id — NOT NULL
- sns_url (sns_링크) — varchar(500)
- history (주요 경력 및 활동 내역) — varchar(255)
- classify (분류) — varchar(20)
- created_at (생성날짜) — datetime(6)
- updated_at (수정날짜) — datetime(6)
account_hash_tag (계정_해시태그)
- account_hash_tag_id (아이디) — Bigint — Primary key — NOT NULL
- account_id (엑스큐베이터) — Bigint — Foreign key → account.account_id — NOT NULL
- hash_tag_id (해시태그) — Bigint — Foreign key → hash_tag.hash_tag_id — NOT NULL
- created_at (생성일자) — datetime(6)
- updated_at (수정일자) — datetime(6)
apply_additional_info (엑스큐베이터 신청 추가 정보)
- apply_additional_info_id (아이디) — Bigint — Primary key — NOT NULL
- apply_info_id (엑스큐베이터 신청 정보) — Bigint — Foreign key → apply_info.apply_info_id — NOT NULL
- sns_url (sns링크) — varchar(500)
- history (주요 경력 및 활동 내역) — varchar(255)
- classify (분류) — varchar(20)
- created_at (생성일자) — datetime(6)
- updated_at (수정일자) — datetime(6)
apply_info (엑스큐베이터 신청 정보)
- apply_info_id (아이디) — Bigint — Primary key — NOT NULL
- username (이름) — varchar(50)
- belong (소속) — varchar(50)
- phone_number (핸드폰번호) — varchar(11)
- email (이메일) — varchar(255)
- status (상태) — varchar(30)
- created_at (생성일자) — datetime(6)
- updated_at (수정일자) — datetime(6)
category (카테고리)
- category_id (아이디) — Bigint — Primary key — NOT NULL
- name (이름) — varchar(50)
- created_at (생성일자) — datetime(6)
- updated_at (수정일자) — datetime(6)
coaching (강좌)
- coaching_id (아이디) — Bigint — Primary key — NOT NULL
- account_id (엑스큐베이터) — Bigint — Foreign key → account.account_id — NOT NULL
- category_id (카테고리) — Bigint — Foreign key → category.category_id — NOT NULL
- title (제목) — varchar(255)
- subtitle (소개 문구) — varchar(255)
- coaching_hours (코칭시간) — int
- price (1회당 비용) — int
- additional_money (추가금액) — int
- maximum_number (최대인원) — int
- is_enable (사용가능 여부) — bit(1)
- is_confirmed (컨펌여부) — bit(1)
- youtube_url (유튜브링크) — varchar(500)
- content_url (콘텐츠링크) — varchar(500)
- content (콘텐츠) — varchar(3000)
- perfomance_url (퍼포먼스링크) — varchar(500)
- created_at (생성일자) — datetime(6)
- updated_at (수정일자) — datetime(6)
coaching_answer (코칭 사전 질문 답변)
- coaching_answer_id (아이디) — Bigint — Primary key — NOT NULL
- reservation_id (예약) — Bigint — Foreign key → reservation.reservation_id — NOT NULL
- coaching_question_id (코칭질문) — Bigint — Foreign key → coaching_question.coaching_question_id — NOT NULL
- answer (답변) — varchar(255)
- created_at (생성일자) — datetime(6)
- updated_at (수정일자) — datetime(6)
coaching_default_time (기본설정시간)
- default_time_id (아이디) — Bigint — Primary key — NOT NULL
- coaching_id (아이디2) — Bigint — Foreign key → coaching.coaching_id — NOT NULL
- default_day (요일) — varchar(20)
- default_time (기본설정시간) — time
- created_at (생성일자) — datetime(6)
- updated_at (수정일자) — datetime(6)
coaching_hash_tag (코칭_해시태그)
- course_hash_tag_id (아이디) — Bigint — Primary key — NOT NULL
- coaching_id (코스) — Bigint — Foreign key → coaching.coaching_id — NOT NULL
- hash_tag_id (해시태그) — Bigint — Foreign key → hash_tag.hash_tag_id — NOT NULL
- created_at (생성일자) — datetime(6)
- updated_at (수정일자) — datetime(6)
coaching_question (코칭 사전 질문)
- coaching_question_id (아이디) — Bigint — Primary key — NOT NULL
- coaching_id (아이디2) — Bigint — Foreign key → coaching.coaching_id — NOT NULL
- question (질문) — varchar(255)
- seq (순서) — int
- created_at (생성일자) — datetime(6)
- updated_at (수정일자) — datetime(6)
follow (팔로우)
- follow_id (아이디) — Bigint — Primary key — NOT NULL
- user_id (유저아이디) — Bigint — Foreign key → account.account_id — NOT NULL
- xcubator_id (엑스큐베이터_아이디) — Bigint — Foreign key → account.account_id — NOT NULL
- created_at (생성날짜) — datetime(6)
- updated_at (수정날짜) — datetime(6)
hash_tag (해시태그)
- hash_tag_id (아이디) — Bigint — Primary key — NOT NULL
- tag (태그) — varchar(255)
- created_at (생성일자) — datetime(6)
- updated_at (수정일자) — datetime(6)
payment (결제)
- payment_id (아이디) — Bigint — Primary key — NOT NULL
- reservation_id (아이디2) — Bigint — Foreign key → reservation.reservation_id — NOT NULL
- amount (금액) — int
- imp_uid (아임포트 고유 아이디) — varchar(255)
- pay_method (결제 메소드) — varchar(50)
- pg_provider (pg사) — varchar(50)
- pg_tid — varchar(255)
- failed_reason (실패사유) — varchar(255)
- refund_policy (환불정책) — varchar(50)
- refund_reason (환불사유) — varchar(255)
- status (결제상태) — varchar(30)
- created_at (생성일자) — datetime(6)
- updated_at (수정일자) — datetime(6)
reservation (예약)
- reservation_id (아이디) — Bigint — Primary key — NOT NULL
- account_id (계정) — Bigint — Foreign key → account.account_id — NOT NULL
- coaching_id (코칭) — Bigint — Foreign key → coaching.coaching_id — NOT NULL
- title (제목) — varchar(255)
- reservation_date_time (예약날짜) — datetime(6)
- coaching_hours (코칭시간) — int
- price (1회당 비용) — int
- additional_money (추가금액) — int
- additional_number (추가인원) — int
- amount (총금액) — int
- username (예약자 이름) — varchar(50)
- belong (소속) — varchar(50)
- phone_number (핸드폰번호) — varchar(11)
- email (이메일) — varchar(255)
- status (예약상태) — varchar(30)
- policy (정책동의) — bit(1)
- created_at (생성일자) — datetime(6)
- updated_at (수정일자) — datetime(6)
- review_id (아이디2) — Bigint — Foreign key → review.review_id — NOT NULL
reservation_date_time (예약 시간)
- reservation_date_time_id (아이디) — Bigint — Primary key — NOT NULL
- reservation_id (예약) — Bigint — Foreign key → reservation.reservation_id — NOT NULL
- reservation_date_time (예약날짜) — datetime(6)
- created_at (생성일자) — datetime(6)
- updated_at (수정일자) — datetime(6)
review (후기)
- review_id (아이디) — Bigint — Primary key — NOT NULL
- rating (별점) — int
- content (내용) — varchar(3000)
- created_at (생성일자) — datetime(6)
- updated_at (수정일자) — datetime(6)
uncoachable_date_time (코칭불가날짜)
- uncoachable_date_time_id (아이디) — Bigint — Primary key — NOT NULL
- coaching_id (코칭) — Bigint — Foreign key → coaching.coaching_id — NOT NULL
- disabled_date_time (비활성화 날짜) — datetime(6)
- created_at (생성일자) — datetime(6)
- updated_at (수정일자) — datetime(6)