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