tennis
Tables (10)
club_ranking
- club_ranking_id — Primary key — NOT NULL
- user_id
- club_id
- ranking_date
- rank
- create_at
- updated_at
clubs
- club_id — varchar — Primary key — NOT NULL
- club_name — varchar
- established_year — date
- contact_info — varchar
- description — varchar
courts
- court_id — Primary key — NOT NULL
- court_name
- location
- surface_type
- is_outdoor
- description
- created_at
- updated_at
events
- event_id — Primary key — NOT NULL
- event_date
- event_type
- created_at
- updated_at
global_ranking (Untitled)
- global_ranking_id — Primary key — NOT NULL
- user_id
- ranking_date
- rank
- created_at
- updated_at
matches
- match_id — Primary key — NOT NULL
- event_id — NOT NULL
- match_date (match_dadte) — date
- court_id
- weather_condition
- round_number
- pair_a_player1_id
- pair_a_player2_id
- pair_b_player1_id
- pair_b_player2_id
- pair_a_result
- pair_b_result
- winner
- start_date
- end_time
- created_at
- updated_at
participations
- participation_id — Primary key — NOT NULL
- event_id
- user_id
- created_at
- updated_at
user_clubs
- user_club_id — varchar — Primary key — NOT NULL
- user_id — varchar — Foreign key → users.user_id — NOT NULL
- club_id (club_id2) — varchar — Foreign key → clubs.club_id — NOT NULL
- inactive_status (Field2) — boolean — NOT NULL
- membership_level — varchar — NOT NULL
- last_activity_date (inactive_status) — varchar
- updated_at — date
- join_date — date
user_sns_accounts
- sns_account_id — Primary key — NOT NULL
- user_id (user_id2) — varchar — Foreign key → users.user_id — NOT NULL
- sns_provider — varchar — sns 제공자
- sns_user_id — varchar
- sns_access_token — varchar
- sns_refresh_token
- sns_email
- created_at
- updated_at
users
- user_id — varchar — Primary key — NOT NULL
- pw_hash — varchar
- social_id — varchar
- user_nickname — varchar — NOT NULL
- start_date — varcahr — 시작연월
- last_acitivity_date (last_activity_date) — date
- inactive_status — Boolean
- email — varchar
- phone_number — varchar
- create_at — date
- updated_at — date