basketball community

Tables (9)

badge_types

  • id — bigint
  • code — text — NOT NULL
  • name_en — text — NOT NULL
  • name_ko — text — NOT NULL
  • description_en — text
  • description_ko — text
  • created_at — timestamptz — NOT NULL

event_participants

  • id — uuid
  • event_id — uuid — NOT NULL
  • user_id — uuid — NOT NULL
  • role — participant_role — NOT NULL
  • status — participant_status — NOT NULL
  • checkin_at — timestamptz
  • joined_at — timestamptz — NOT NULL

events

  • id — uuid
  • sport_id — bigint — NOT NULL
  • host_user_id — uuid — NOT NULL
  • location_id — uuid
  • title — text — NOT NULL
  • title_en — text
  • title_ko — text
  • description — text
  • description_en — text
  • description_ko — text
  • start_at — timestamptz — NOT NULL
  • end_at — timestamptz — NOT NULL
  • capacity — integer — NOT NULL
  • min_players — integer
  • allow_waitlist — boolean — NOT NULL
  • gender_filter — gender_type — NOT NULL
  • min_age — smallint
  • max_age — smallint
  • min_skill — skill_level
  • max_skill — skill_level
  • price_cents — integer
  • currency — char(3)
  • language_code — text — NOT NULL
  • visibility_public — boolean — NOT NULL
  • status — event_status — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • deleted_at — timestamptz
  • deleted_YN — char(1)
  • deleted_id (Field3)

locations

  • id — uuid
  • name — text — NOT NULL
  • address_line — text
  • district — text
  • city — text
  • latitude — numeric(9,6)
  • longitude — numeric(9,6)
  • indoor — boolean
  • court_count — smallint
  • court_type — text
  • amenities — jsonb
  • contact_info — jsonb
  • verified — boolean — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

mvp_votes

  • id — uuid
  • event_id — uuid — NOT NULL
  • voter_user_id — uuid — NOT NULL
  • nominee_user_id — uuid — NOT NULL
  • created_at — timestamptz — NOT NULL

reviews

  • id — uuid
  • event_id — uuid — NOT NULL
  • reviewer_user_id — uuid — NOT NULL
  • reviewee_user_id — uuid — NOT NULL
  • rating — smallint — NOT NULL
  • tags — jsonb
  • comment — text — ex
  • created_at — timestamptz — NOT NULL

sports

  • id — bigint
  • code — text — NOT NULL
  • name_en — text — NOT NULL
  • name_ko — text — NOT NULL
  • created_at — timestamptz — NOT NULL

user_badges

  • id — uuid
  • user_id — uuid — NOT NULL
  • badge_type_id — bigint — NOT NULL
  • granted_by_user_id — uuid
  • event_id — uuid
  • granted_at — timestamptz — NOT NULL

users

  • id — uuid
  • username — citext
  • email — citext
  • phone — text
  • display_name — text — NOT NULL
  • language_code — text — NOT NULL
  • timezone — text — NOT NULL
  • gender — gender_type
  • birth_year — smallint
  • height_cm — smallint
  • weight_kg — numeric(5,2)
  • skill_level — skill_level
  • temperature_score — numeric(4,1) — NOT NULL
  • bio — text
  • avatar_url — text
  • is_active — boolean — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL