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)