USSEO
Tables (37)
challenges_challenge
- id — UUID — Primary key — NOT NULL — PK
- is_delete — BOOLEAN — NOT NULL — Delete
- is_active — BOOLEAN — NOT NULL — Active
- name — VARCHAR(127) — NOT NULL — Challenge
- type — challengetype — NOT NULL — Challenge
- open_at — TIMESTAMP — NOT NULL — Challenge
- close_at — TIMESTAMP — NOT NULL — Challenge
- submission_deadline — TIMESTAMP — NOT NULL — Submission
- team_freeze_at — INTEGER
- organization_id — UUID — NOT NULL
challenges_challenge_keyword
- id — SERIAL — Primary key — NOT NULL — PK
- challenge_id — UUID — Foreign key → challenges_challenge.id — NOT NULL — Challenge
- keyword — VARCHAR(50) — NOT NULL — Keyword
- delete_at — TIMESTAMP — Deleted
challenges_challenge_modify_history
- id — SERIAL — Primary key — NOT NULL — PK
- user_id — UUID — Foreign key → users_user.id — NOT NULL — User
- challenge_id — UUID — Foreign key → challenges_challenge.id — NOT NULL — Challenge
- created_at — TIMESTAMP — NOT NULL
- raw_data — VARCHAR — NOT NULL
challenges_challenge_participant_dashboard
- id — SERIAL — Primary key — NOT NULL — PK
- user_id — UUID — Foreign key → users_user.id — NOT NULL — Participant
- challenge_id — UUID — Foreign key → challenges_challenge.id — NOT NULL — Challenge
- is_delete — BOOLEAN — NOT NULL
- is_active — BOOLEAN — NOT NULL — Active
- is_coach — BOOLEAN — NOT NULL — Coach
- created_at — TIMESTAMP — NOT NULL — Created
- team_id — UUID — Foreign key → teams_team.id — NOT NULL — Team
challenges_challenge_resource_description
- challenge_id — UUID — Foreign key → challenges_challenge.id — NOT NULL — Challenge
- resource_id — UUID — Foreign key → resources_resource.id — NOT NULL — Resource
- is_delete — BOOLEAN — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
challenges_challenge_round
- id — UUID — Primary key — NOT NULL — PK
- challenge_id — UUID — Foreign key → challenges_challenge.id — NOT NULL — Challenge
- is_delete — BOOLEAN — NOT NULL — Delete
- is_active — BOOLEAN — NOT NULL — Active
- created_at — TIMESTAMP — NOT NULL — Created
- order — INTEGER — NOT NULL — Order
- round_type — challengeroundtype — NOT NULL — Round
- open_at — TIMESTAMP — NOT NULL — Round
- close_at — TIMESTAMP — NOT NULL — Round
- point — INTEGER — NOT NULL — Points
- score_reveal_delay — INTEGER — NOT NULL — Score
- thumbnail_resource_id — UUID — NOT NULL — Resource
challenges_challenge_round_extra_info
- id — Primary key — NOT NULL — PK
- round_id — UUID — Foreign key → challenges_challenge_round.id — NOT NULL — Round
- order — INTEGER — NOT NULL — Order
- name — VARCHAR(56)
- location — VARCHAR(255)
- submission_method — challengeroundsubmittype
- Field
challenges_challenge_round_submission
- id — UUID — Primary key — NOT NULL — PK
- user_id — UUID — Foreign key → users_user.id — NOT NULL — Submitter
- round_id — UUID — Foreign key → challenges_challenge_round.id — NOT NULL — Round
- created_at — TIMESTAMP — NOT NULL — Created
- deleted_at — TIMESTAMP — Deleted
- dashboard_id — INTEGER — NOT NULL — Challenge
- custom_link — VARCHAR — Custom
challenges_challenge_round_submission_resource
- resource_id — UUID
- round_submission_id — UUID — NOT NULL — Assignment
challenges_challenge_round_submission_score
- id — SERIAL — Primary key — NOT NULL — PK
- round_submission_id — UUID — Foreign key → challenges_challenge_round_submission.id — NOT NULL — Assignment
- score — INTEGER — NOT NULL — Score
- author_id — UUID — NOT NULL — Grader
- created_at — TIMESTAMP — NOT NULL — Created
- deleted_at — TIMESTAMP — Deleted
- deleted_by_id — UUID — NOT NULL — Deleted
challenges_user_wishlist
- user_id — UUID — Foreign key → users_user.id — NOT NULL — User
- challenge_id — UUID — Foreign key → challenges_challenge.id — NOT NULL — Challenge
- created_at — TIMESTAMP — NOT NULL — Created
organizations_organization
- id — UUID — Primary key — NOT NULL — PK
- is_delete — BOOLEAN — NOT NULL
- is_active — BOOLEAN — NOT NULL — Active
- created_at — TIMESTAMP — NOT NULL — Created
- assign_staff_id — UUID — NOT NULL — Assigned
- name — VARCHAR — NOT NULL — Organization
organizations_organization_user_link
- id — SERIAL
- user_id — UUID — Foreign key → users_user.id — NOT NULL — User
- organization_id — UUID — Foreign key → organizations_organization.id — NOT NULL — Organization
- created_at — TIMESTAMP — NOT NULL — Created
- role — participationrole — NOT NULL — Role
payments_discount
- id — SERIAL — ID
- challenge_id — UUID — Foreign key → challenges_challenge.id — NOT NULL — Challenge
- is_delete — BOOLEAN — NOT NULL
- is_active — BOOLEAN — NOT NULL — Active
- start_date — TIMESTAMP — NOT NULL — Discount
- end_date — TIMESTAMP — NOT NULL — Discount
- amount — REAL — NOT NULL — Discount
payments_gateway_event_log
- id — SERIAL
- type — VARCHAR — NOT NULL — Event
- raw — VARCHAR — NOT NULL — PG
payments_order
- id — UUID — Primary key — NOT NULL — PK
- user_id — UUID — Foreign key → users_user.id — NOT NULL — Users
- challenge_id — UUID — Foreign key → challenges_challenge.id — NOT NULL — Challenge
- created_at — TIMESTAMP — NOT NULL — Created
- currency — VARCHAR(3) — NOT NULL — Payment
- amount — REAL — NOT NULL — Order
- request_id — VARCHAR(255) — NOT NULL — Stripe
- discount_id — INTEGER — NOT NULL — Discount
- refunded_at — TIMESTAMP — Refunded
- is_active — BOOLEAN — NOT NULL — Active
payments_order_receipt
- order_id — UUID — Foreign key → payments_order.id — NOT NULL — Orders
- created_at — TIMESTAMP — NOT NULL
- request_id — VARCHAR(255) — NOT NULL — Stripe
- response_log — VARCHAR — PG
points_user_point
- user_id — UUID — Foreign key → users_user.id — NOT NULL — User
- balance — INTEGER — NOT NULL — Point
points_user_point_history
- id — SERIAL
- user_id — UUID — Foreign key → users_user.id — NOT NULL — User
- created_at — TIMESTAMP — NOT NULL — Created
- point_change — INTEGER — NOT NULL — Point
- balance_after — INTEGER — NOT NULL — Balance
- reason — VARCHAR — NOT NULL — Change
resources_resource
- id — UUID — Primary key — NOT NULL — PK
- created_at — TIMESTAMP — NOT NULL — Created
- resource_type — resourcetype — NOT NULL — Resource
- user_id — UUID — NOT NULL — User
resources_resource_extra_info
- id — UUID — Primary key — NOT NULL — PK
- created_at — TIMESTAMP — NOT NULL — Created
- value — VARCHAR — NOT NULL — Value
- resource_id — UUID — Foreign key → resources_resource.id — NOT NULL — Resource
resources_resource_item
- id — UUID — Primary key — NOT NULL — PK
- resource_id — UUID — Foreign key → resources_resource.id — NOT NULL — Resource
- created_at — TIMESTAMP — NOT NULL — Created
- name — VARCHAR — NOT NULL — Name
- url — VARCHAR — NOT NULL — URL
resources_resource_type
- id — SERIAL — Primary key — NOT NULL — PK
- is_support_detail — BOOLEAN — NOT NULL — Detail
- is_support_thumb — BOOLEAN — NOT NULL — Thumbnail
- is_support_media_extra — BOOLEAN — NOT NULL — Media
- support_extensions — VARCHAR — NOT NULL — Allowed
- resource_type — resourcetype — NOT NULL — Resource
teams_team
- id — UUID — Primary key — NOT NULL — PK
- is_delete — BOOLEAN — NOT NULL
- is_active — BOOLEAN — NOT NULL — Active
- created_at — TIMESTAMP — NOT NULL — Created
- name — VARCHAR(128) — NOT NULL — Team
- challenge_id — UUID — NOT NULL — Challenge
- reader_id — UUID — NOT NULL — Coach
teams_team_invites
- id — UUID — Primary key — NOT NULL — PK
- team_id — UUID — Foreign key → teams_team.id — NOT NULL — Team
- user_id — UUID — Foreign key → users_user.id — NOT NULL — User
- status — teaminvitestatus — NOT NULL — Invitation
- invited_at — TIMESTAMP — NOT NULL — Invited
- responded_at — TIMESTAMP — Responded
teams_team_leave
- invite_id — UUID — Foreign key → teams_team_invites.id — NOT NULL — Invite
- created_at — TIMESTAMP — NOT NULL
teams_team_pending_invites
- id — SERIAL
- created_at — TIMESTAMP — NOT NULL — Created
- user_id — UUID — Foreign key → users_user.id — NOT NULL — Unregistered
- team_id — UUID — Foreign key → teams_team.id — NOT NULL — Team
users_auth_access_token
- id — SERIAL
- user_id — UUID — Foreign key → users_user.id — NOT NULL — User
- token — VARCHAR(64) — NOT NULL
- device_fingerprint — VARCHAR(64) — NOT NULL
- expires_at — TIMESTAMP
users_auth_password
- user_id — UUID — Foreign key → users_user.id — NOT NULL — User
- email — VARCHAR — NOT NULL — Email
- password — VARCHAR(128) — NOT NULL — Password
- verified_at — TIMESTAMP — Verified
users_auth_refresh_token
- id — SERIAL
- access_token_id — INTEGER — NOT NULL
- token — VARCHAR(64) — NOT NULL — Refresh
- expires_at — TIMESTAMP — Expiration
users_auth_reset_password_verify_codes
- id — SERIAL
- user_id — UUID — Foreign key → users_user.id — NOT NULL — User
- created_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- expires_in — INTEGER — NOT NULL
- code — VARCHAR(32) — NOT NULL — Verification
- change_at — TIMESTAMP — Password
users_auth_signup_verify_codes
- id — SERIAL
- user_id — UUID — Foreign key → users_user.id — NOT NULL — User
- code — VARCHAR(32) — NOT NULL — Verification
- expires_in — INTEGER — NOT NULL — Expiration
- created_at — TIMESTAMP — NOT NULL — Created
- deleted_at — TIMESTAMP — Deleted
users_invited_user
- id — UUID
- user_id — UUID — Foreign key → users_user.id — NOT NULL — User
- created_at — TIMESTAMP — NOT NULL — Created
- email — VARCHAR — NOT NULL — Email
- role — participationrole — NOT NULL — Role
users_user
- id — UUID — Primary key — NOT NULL — PK
- is_staff — BOOLEAN — NOT NULL — Staff
- is_delete — BOOLEAN — NOT NULL — Delete
- is_active — BOOLEAN — NOT NULL — Active
- role — participationrole — NOT NULL — Role
- created_at — TIMESTAMP — NOT NULL — Created
users_user_funnels
- user_id — UUID — Foreign key → users_user.id — NOT NULL — User
- source — funnelssource — NOT NULL
- user_input — VARCHAR — NOT NULL — User
users_user_profile
- user_id — UUID — Foreign key → users_user.id — NOT NULL — User
- email — VARCHAR — NOT NULL — Email
- gender — VARCHAR — Gender
- city — VARCHAR — City
- first_name — VARCHAR — First
- last_name — VARCHAR — Last
- date_of_birth — VARCHAR — Date
- country — VARCHAR — Country
users_user_profile_primary_contacts
- user_id — UUID — Foreign key → users_user.id — NOT NULL — User
- first_name — VARCHAR — First
- last_name — VARCHAR — Last
- relation — primarycontactrelation — NOT NULL — Relationship
- phone_number — VARCHAR — NOT NULL — Phone
- email — VARCHAR — NOT NULL — Email
- relation_user_input — VARCHAR — User