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