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