USSEO

Tables (40)

alembic_version

  • version_num — character — NOT NULL

challenges_challenge

  • id — uuid — NOT NULL
  • is_delete — boolean — NOT NULL — 삭제
  • is_active — boolean — NOT NULL — 활성화
  • name — character — NOT NULL — 챌린지
  • type — public.challengetype — NOT NULL — 챌린지
  • open_at — timestamp — NOT NULL — 챌린지
  • close_at — timestamp — NOT NULL — 챌린지
  • submission_deadline — timestamp — NOT NULL — 접수
  • team_freeze_at — integer — NOT NULL — 팀
  • price — double — NOT NULL — 참가금
  • organization_id — uuid — NOT NULL — 조직
  • kit_size — public.challengekitsize — NOT NULL — 키트
  • age_group — public.challengeagegroup — NOT NULL — 연령대

challenges_challenge_entry

  • id — uuid — NOT NULL
  • challenge_id — uuid — NOT NULL — 챌린지
  • user_id — uuid — NOT NULL
  • team_id — uuid — NOT NULL

challenges_challenge_keyword

  • id — integer — NOT NULL
  • challenge_id — uuid — NOT NULL — 챌린지
  • keyword — character — NOT NULL — 키워드
  • delete_at — timestamp — 삭제

challenges_challenge_modify_history

  • created_at — timestamp — NOT NULL
  • id — integer — NOT NULL — ID
  • user_id — uuid — NOT NULL — 변경자
  • challenge_id — uuid — NOT NULL — 챌린지
  • raw_data — character — NOT NULL

challenges_challenge_participant_dashboard

  • is_delete — boolean — NOT NULL
  • is_active — boolean — NOT NULL — 활성화
  • id — integer — NOT NULL — ID
  • challenge_id — uuid — NOT NULL — 챌린지
  • user_id — uuid — NOT NULL — 참가자
  • team_id — uuid — 소속
  • is_coach — boolean — NOT NULL — 코치
  • created_at — timestamp — NOT NULL — 생성
  • name — character — 참가자/코치
  • email — character — 참가자/코치
  • phone_number — character — 참가자/코치
  • relation_to_contact — character — 연락처와의

challenges_challenge_resource_description

  • is_delete — boolean — NOT NULL
  • is_active — boolean — NOT NULL — 활성화
  • created_at — timestamp — NOT NULL — 생성일시
  • challenge_id — uuid — NOT NULL — 챌린지
  • resource_id — uuid — NOT NULL — 리소스

challenges_challenge_resource_thumbnail

  • is_delete — boolean — NOT NULL
  • is_active — boolean — NOT NULL — 활성화
  • created_at — timestamp — NOT NULL — 생성일시
  • challenge_id — uuid — NOT NULL — 챌린지
  • resource_id — uuid — NOT NULL — 리소스

challenges_challenge_round

  • is_delete — boolean — NOT NULL
  • is_active — boolean — NOT NULL — 활성화
  • id — uuid — NOT NULL — ID
  • created_at — timestamp — NOT NULL — 생성
  • challenge_id — uuid — NOT NULL — 챌린지
  • order — integer — NOT NULL
  • round_type — public.challengeroundtype — NOT NULL — 회차
  • open_at — timestamp — NOT NULL — 라운드
  • close_at — timestamp — NOT NULL — 라운드
  • thumbnail_resource_id — uuid — NOT NULL — 리소스
  • score_reveal_delay — integer — NOT NULL — 점수
  • point — integer — NOT NULL — 배점

challenges_challenge_round_extra_info

  • id — integer — NOT NULL
  • round_id — uuid — NOT NULL — 라운드
  • order — integer — NOT NULL
  • name — character
  • location — character
  • submission_method — public.challengeroundsubmittype

challenges_challenge_round_submission

  • id — uuid — NOT NULL
  • created_at — timestamp — NOT NULL — 생성
  • round_id — uuid — NOT NULL — 라운드
  • user_id — uuid — NOT NULL — 제출자
  • custom_link — character — 자유
  • deleted_at — timestamp — 삭제
  • dashboard_id — integer — NOT NULL — 챌린지

challenges_challenge_round_submission_resource

  • resource_id — uuid — NOT NULL
  • round_submission_id — uuid — NOT NULL — 과제

challenges_challenge_round_submission_score

  • id — integer — NOT NULL
  • round_submission_id — uuid — NOT NULL — 과제
  • score — integer — NOT NULL — 점수
  • author_id — uuid — NOT NULL — 채점자
  • created_at — timestamp — NOT NULL — 생성
  • deleted_at — timestamp — 삭제
  • deleted_by_id — uuid — NOT NULL — 삭제자

challenges_user_wishlist

  • user_id — uuid — NOT NULL
  • challenge_id — uuid — NOT NULL — 챌린지
  • created_at — timestamp — NOT NULL — 생성

organizations_organization

  • is_delete — boolean — NOT NULL
  • is_active — boolean — NOT NULL — 활성화
  • created_at — timestamp — NOT NULL — 생성일시
  • id — uuid — NOT NULL — ID
  • assign_staff_id — uuid — NOT NULL — 할당한
  • name — character — NOT NULL — 조직명

organizations_organization_user_link

  • organization_id — uuid — NOT NULL
  • user_id — uuid — NOT NULL
  • approval_status — public.userorganizationapprovalstatus — NOT NULL

payments_discount

  • is_delete — boolean — NOT NULL
  • is_active — boolean — NOT NULL — 활성화
  • id — integer — NOT NULL — ID
  • challenge_id — uuid — NOT NULL — 챌린지
  • start_date — timestamp — NOT NULL — 할인
  • end_date — timestamp — NOT NULL — 할인
  • amount — double — NOT NULL — 할인

payments_gateway_event_log

  • id — integer — NOT NULL
  • type — character — NOT NULL — 이벤트
  • raw — character — NOT NULL — PG사

payments_order

  • id — uuid — NOT NULL
  • created_at — timestamp — NOT NULL — 생성
  • challenge_id — uuid — NOT NULL — 챌린지
  • currency — character — NOT NULL — 결제
  • amount — double — NOT NULL — 주문
  • request_id — character — NOT NULL — Stripe
  • user_id — uuid — NOT NULL — 사용자
  • discount_id — integer — 할인
  • refunded_at — timestamp — 환불
  • is_active — boolean — NOT NULL — 활성화
  • price_id — character
  • product_id — character

payments_order_receipt

  • created_at — timestamp — NOT NULL
  • order_id — uuid — NOT NULL — 주문
  • request_id — character — NOT NULL — Stripe
  • response_log — character — PG사

points_user_point

  • user_id — uuid — NOT NULL
  • balance — integer — NOT NULL — 잔여포인트

points_user_point_history

  • created_at — timestamp — NOT NULL
  • id — integer — NOT NULL — ID
  • point_id — uuid — NOT NULL
  • amount — integer — NOT NULL — 수량
  • transaction_type — public.pointhistorytransactiontype — NOT NULL — 적요

resources_resource

  • id — uuid — NOT NULL
  • created_at — timestamp — NOT NULL — 생성일시
  • resource_type — public.resourcetype — NOT NULL — 리소스
  • user_id — uuid — NOT NULL — 사용자

resources_resource_extra_info

  • id — integer — NOT NULL
  • raw_width — integer — NOT NULL — 원본
  • raw_height — integer — NOT NULL — 원본
  • resource_id — uuid — NOT NULL — 리소스

resources_resource_item

  • id — uuid — NOT NULL
  • key_path — character — NOT NULL
  • resource_scale — public.resourcescale — NOT NULL — 스케일
  • is_assigned — boolean — NOT NULL — 할당
  • resource_id — uuid — NOT NULL — 리소스

resources_resource_type

  • id — integer — NOT NULL
  • is_support_detail — boolean — NOT NULL — 디테일
  • is_support_thumb — boolean — NOT NULL — 썸네일
  • is_support_media_extra — boolean — NOT NULL — 미디어
  • support_extensions — character — NOT NULL — 허용되는
  • resource_type — public.resourcetype — NOT NULL — 디테일

teams_team

  • is_delete — boolean — NOT NULL
  • is_active — boolean — NOT NULL — 활성화
  • id — uuid — NOT NULL — ID
  • created_at — timestamp — NOT NULL — 생성일시
  • name — character — NOT NULL — 팀
  • challenge_id — uuid — NOT NULL — 챌린지
  • reader_id — uuid — NOT NULL — 코치

teams_team_invites

  • id — integer — NOT NULL
  • team_id — uuid — NOT NULL
  • user_id — uuid — NOT NULL — 사용자
  • status — public.teaminvitestatus — NOT NULL — 초대
  • invited_at — timestamp — NOT NULL — 초대
  • responded_at — timestamp — 응답

teams_team_leave

  • created_at — timestamp — NOT NULL
  • invite_id — integer — NOT NULL

teams_team_pending_invites

  • id — integer — NOT NULL
  • created_at — timestamp — NOT NULL — 생성일시
  • team_id — uuid — NOT NULL
  • user_id — uuid — NOT NULL — 미가입

users_auth_access_token

  • id — integer — NOT NULL
  • user_id — uuid — NOT NULL
  • token — character — NOT NULL
  • device_fingerprint — character — NOT NULL
  • expires_at — timestamp

users_auth_password

  • user_id — uuid — NOT NULL — 사용자
  • email — character — NOT NULL — 이메일
  • password — character — NOT NULL — 비밀번호
  • verified_at — timestamp — 인증

users_auth_refresh_token

  • id — integer — NOT NULL
  • access_token_id — integer — NOT NULL
  • token — character — NOT NULL — 리프레시
  • expires_at — timestamp — 만료일시

users_auth_reset_password_verify_codes

  • id — integer — NOT NULL
  • user_id — uuid — NOT NULL
  • created_at — timestamp — NOT NULL — 생성
  • deleted_at — timestamp — 삭제
  • expires_in — integer — NOT NULL — 만료
  • code — character — NOT NULL — 인증
  • change_at — timestamp — 비밀번호

users_auth_signup_verify_codes

  • id — integer — NOT NULL
  • user_id — uuid — NOT NULL — 사용자
  • code — character — NOT NULL — 인증
  • expires_in — integer — NOT NULL — 만료
  • created_at — timestamp — NOT NULL — 생성
  • deleted_at — timestamp — 삭제

users_invited_user

  • id — uuid — NOT NULL
  • created_at — timestamp — NOT NULL — 생성일시
  • email — character — NOT NULL — 이메일
  • role — public.participationrole — NOT NULL — 역할
  • user_id — uuid — 가입된

users_user

  • created_at — timestamp — NOT NULL — 생성일시
  • is_delete — boolean — NOT NULL — 삭제
  • is_active — boolean — NOT NULL — 활성화
  • id — uuid — NOT NULL — ID
  • role — public.participationrole — NOT NULL — 역할
  • is_staff — boolean — NOT NULL — 관리자
  • is_email_verified — boolean — NOT NULL — 이메일

users_user_funnels

  • user_id — uuid — NOT NULL
  • source — public.funnelssource — NOT NULL
  • user_input — character — NOT NULL — 사용자

users_user_profile

  • email — character — NOT NULL — 이메일
  • gender — character — 이름
  • city — character — 도시
  • first_name — character — 이름
  • last_name — character — 성
  • date_of_birth — character — 생년월일
  • user_id — uuid — NOT NULL — 사용자
  • country — character — 국가

users_user_profile_primary_contacts

  • user_id — uuid — NOT NULL
  • first_name — character — 이름
  • last_name — character — 성
  • relation — public.primarycontactrelation — NOT NULL — 관계
  • phone_number — character — NOT NULL — 연락처
  • email — character — NOT NULL — 이메일
  • relation_user_input — character — 사용자