We-tness

Tables (17)

badge

  • id — BIGINT — Primary key — NOT NULL
  • event_name — VARCHAR(45) — NOT NULL — 도전과제명
  • detail — VARCHAR(100) — NOT NULL — 도전과제 내용

block

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • target_id — BIGINT — NOT NULL
  • ban_date — TIMESTAMP — NOT NULL
  • INDEX — `block_user_user_id_idx`

follow

  • follower_id — BIGINT — Foreign key → user.id — NOT NULL
  • following_id — BIGINT — Foreign key → user.id — NOT NULL
  • follow_date — TIMESTAMP — NOT NULL
  • INDEX — `follow_following_id_user_id_idx`

game

  • id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → room.id — NOT NULL
  • workout_id — BIGINT — Foreign key → workout.id — NOT NULL
  • create_date — TIMESTAMP — NOT NULL
  • terminate_date — TIMESTAMP
  • INDEX — `game_room_id_room_id_idx`
  • INDEX — `game_workout_id_workout_id_idx`

gugun_code

  • gugun_code — VARCHAR(10) — Primary key — NOT NULL
  • gugun_name — VARCHAR(30)

logged_in

  • id — BIGINT — Primary key — NOT NULL
  • date — VARCHAR(30) — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • consecutively — INT — NOT NULL
  • INDEX — `logged_in_user_id_user_id_idx`

notification

  • id — BIGINT — Foreign key → user.id — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • notify_date — TIMESTAMP — NOT NULL
  • check — BIT(1) — NOT NULL
  • notify_type — VARCHAR(45) — NOT NULL
  • Field — BIT(1)
  • room_code — VARCHAR(45)
  • follower_id — BIGINT
  • badge_id — BIGINT
  • INDEX — `notification_user_id_user_id_idx`

rank

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT
  • sido_code — VARCHAR(45)
  • workout_id — BIGINT
  • score — DOUBLE
  • date — TIMESTAMP
  • INDEX — `rank_user_id_user_id_idx`
  • INDEX — `rank_sido_code_sido_code_sido_code'_idx`

report

  • id — BIGINT — Primary key — NOT NULL
  • reporter_id — BIGINT — Foreign key → user.id — NOT NULL
  • accused_id — BIGINT — Foreign key → user.id — NOT NULL
  • content — VARCHAR(45) — NOT NULL
  • report_date — TIMESTAMP — NOT NULL
  • process — BIT(1) — NOT NULL
  • INDEX — `report_reporter_id_user_id_idx`
  • INDEX — `report_reporter_id_user_id_idx1`

room

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(45) — NOT NULL
  • password — VARCHAR(45)
  • workout_id — BIGINT — Foreign key → workout.id — NOT NULL
  • scope — ENUM('public', 'private') — NOT NULL
  • create_date — TIMESTAMP — NOT NULL
  • terminate_date — TIMESTAMP
  • INDEX — `room_workout_id_workout_id_idx`

sido_code

  • sido_code — VARCHAR(10) — Primary key — NOT NULL
  • sido_name — VARCHAR(30)

today_rank

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id
  • sido_code — VARCHAR(45) — Foreign key → sido_code.sido_code
  • workout_id — BIGINT — Foreign key → workout.id
  • total_score — DOUBLE
  • date — TIMESTAMP
  • INDEX — `today_rank_user_id_user_id_idx`
  • INDEX — `today_rank_sido_code_sido_code_sido_code_idx`
  • INDEX — `today_rank_workout_id_workout_id_idx`

user

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(45) — NOT NULL
  • password — VARCHAR(45) — NOT NULL
  • nickname — VARCHAR(45) — NOT NULL
  • si_code — VARCHAR(45) — Foreign key → sido_code.sido_code
  • gun_code — VARCHAR(45) — Foreign key → gugun_code.gugun_code
  • gender — ENUM('male', 'female')
  • height — DOUBLE
  • weight — DOUBLE
  • social — VARCHAR(45) — NOT NULL
  • role — VARCHAR(45) — NOT NULL
  • social_code — VARCHAR(100)
  • ban_state — BIT(1)
  • ban_date — DATETIME
  • INDEX — `user_si_code_sido_code_sido_code_idx`
  • INDEX — `user_gun_code_gun_code_gun_code_idx`

user_badge

  • user_id — BIGINT(20) — Foreign key → user.id — NOT NULL
  • badge_id — BIGINT(20) — Foreign key → badge.id — NOT NULL
  • receive_date — TIMESTAMP — NOT NULL
  • INDEX — `user_badge_badge_id_badge_id_idx`

user_game

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL — user 테이블의 id 참조
  • game_id — BIGINT — Foreign key → game.id — NOT NULL — game 테이블의 id 참조
  • workout_id — BIGINT — Foreign key → workout.id — NOT NULL — workout 테이블의 id 참조
  • score — DOUBLE — NOT NULL
  • rank — INT
  • INDEX — `user_game_game_id_idx`
  • INDEX — `user_game_user_id_user_id_idx`
  • INDEX — `user_game_workout_id_workout_id_idx`

workout

  • id — BIGINT — Primary key — NOT NULL
  • type — VARCHAR(45) — NOT NULL
  • calorie — DOUBLE — NOT NULL

workout_diary

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • file_name — VARCHAR(100) — NOT NULL — TIMESTAMP + USERID
  • date — TIMESTAMP — NOT NULL
  • user_game_id — BIGINT — Foreign key → user_game.game_id — NOT NULL — user_game테이블 참조
  • INDEX — `workout_diary_user_id_user_id_idx`
  • INDEX — `workout_diary_user_game_id_user_game_id_idx`