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 — 사용자