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`