tantan

Tables (27)

amenity

  • id — BIGINT — Primary key — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • icon_key — VARCHAR(255)
  • sort_order — INT
  • active — TINYINT(1)

chat_message

  • id — BIGINT — Primary key — NOT NULL
  • chat_room_id — BIGINT — Foreign key → chat_room.id — NOT NULL
  • sender_id — BIGINT — Foreign key → user.id — NOT NULL
  • chat_message — VARCHAR(2000) — NOT NULL
  • is_read — VARCHAR(1) — NOT NULL
  • del_yn — VARCHAR(1) — NOT NULL
  • created_time — DATETIME
  • updated_time — DATETIME

chat_room

  • id — BIGINT — Primary key — NOT NULL
  • user1_id — BIGINT — Foreign key → user.id — NOT NULL
  • user2_id — BIGINT — Foreign key → user.id — NOT NULL
  • del_yn — VARCHAR(1) — NOT NULL
  • created_time — DATETIME
  • updated_time — DATETIME

chat_room_participant

  • id — BIGINT — Primary key — NOT NULL
  • chat_room_id — BIGINT — Foreign key → chat_room.id — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • last_read_message_id — BIGINT
  • left_at — DATETIME
  • visible_yn — VARCHAR(7) — NOT NULL
  • created_time — DATETIME
  • updated_time — DATETIME

email_verify_redis

  • id — BIGINT — Primary key — NOT NULL
  • key_name — VARCHAR(255) — NOT NULL
  • key_type — VARCHAR(20) — NOT NULL
  • value_text — VARCHAR(255)
  • ttl_seconds — INT
  • db_index — INT — NOT NULL
  • description — VARCHAR(500)

gym

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • address — VARCHAR(255)
  • latitude — DOUBLE
  • longitude — DOUBLE
  • description — VARCHAR(255)
  • category_tag — VARCHAR(255)
  • tel — VARCHAR(255)
  • is_initialized — TINYINT(1)
  • registry_num — VARCHAR(255) — NOT NULL
  • del_yn — VARCHAR(1)
  • user_id — BIGINT — Foreign key → user.id
  • created_time — DATETIME
  • updated_time — DATETIME

gym_amenity

  • id — BIGINT — Primary key — NOT NULL
  • gym_id — BIGINT — Foreign key → gym.id — NOT NULL
  • amenity_id — BIGINT — Foreign key → amenity.id — NOT NULL

gym_favorite_redis_hash

  • id — BIGINT — Primary key — NOT NULL
  • redis_key — VARCHAR(255) — NOT NULL
  • hash_field — VARCHAR(100) — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • gym_id — BIGINT — Foreign key → gym.id — NOT NULL
  • created_at — DATETIME
  • db_index — INT — NOT NULL

gym_follower_redis_set

  • id — BIGINT — Primary key — NOT NULL
  • redis_key — VARCHAR(255) — NOT NULL
  • member_user_id — BIGINT — Foreign key → user.id — NOT NULL
  • gym_id — BIGINT — Foreign key → gym.id — NOT NULL
  • db_index — INT — NOT NULL

gym_hour

  • id — BIGINT — Primary key — NOT NULL
  • gym_id — BIGINT — Foreign key → gym.id — NOT NULL
  • day_of_week — VARCHAR(20) — NOT NULL
  • open_time — TIME
  • close_time — TIME
  • is_closed — TINYINT(1)
  • created_time — DATETIME
  • updated_time — DATETIME

gym_hour_exception

  • id — BIGINT — Primary key — NOT NULL
  • gym_id — BIGINT — Foreign key → gym.id — NOT NULL
  • specific_date — DATE — NOT NULL
  • open_time — TIME
  • close_time — TIME
  • is_closed — TINYINT(1)
  • description — VARCHAR(255)
  • created_time — DATETIME
  • updated_time — DATETIME

gym_notice

  • id — BIGINT — Primary key — NOT NULL
  • gym_id — BIGINT — Foreign key → gym.id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — VARCHAR(1000) — NOT NULL
  • del_yn — VARCHAR(1)
  • created_time — DATETIME
  • updated_time — DATETIME

gym_product

  • id — BIGINT — Primary key — NOT NULL
  • gym_id — BIGINT — Foreign key → gym.id — NOT NULL
  • product_name — VARCHAR(255) — NOT NULL
  • price — INT — NOT NULL

image_table

  • img_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • img_name — VARCHAR(255) — NOT NULL
  • img_original_name — VARCHAR(255) — NOT NULL
  • file_path — VARCHAR(255) — NOT NULL
  • del_yn — VARCHAR(1) — NOT NULL
  • ref_id — VARCHAR(20) — NOT NULL
  • ref_type — VARCHAR(20) — NOT NULL
  • created_time — DATETIME
  • updated_time — DATETIME

notification

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • ref_type — VARCHAR(30) — NOT NULL
  • ref_id — BIGINT — NOT NULL
  • message — VARCHAR(500) — NOT NULL
  • is_read — TINYINT(1) — NOT NULL
  • created_time — DATETIME
  • updated_time — DATETIME

post

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • category — VARCHAR(255) — NOT NULL
  • del_yn — VARCHAR(1)
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • workout_id — BIGINT — Foreign key → workout.id
  • like_count — BIGINT — NOT NULL
  • comment_count — BIGINT — NOT NULL
  • created_time — DATETIME
  • updated_time — DATETIME

post_comment

  • id — BIGINT — Primary key — NOT NULL
  • contents — VARCHAR(1000) — NOT NULL
  • del_yn — VARCHAR(255) — NOT NULL
  • post_id — BIGINT — Foreign key → post.id — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • parent_comment_id — BIGINT — Foreign key → post_comment.id
  • created_time — DATETIME
  • updated_time — DATETIME

post_like

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • post_id — BIGINT — Foreign key → post.id — NOT NULL
  • created_time — DATETIME
  • updated_time — DATETIME

refresh_token_redis

  • id — BIGINT — Primary key — NOT NULL
  • key_name — VARCHAR(255) — NOT NULL
  • key_type — VARCHAR(20) — NOT NULL
  • value_text — TEXT — NOT NULL
  • ttl_seconds — INT
  • db_index — INT — NOT NULL
  • description — VARCHAR(500)

report

  • id — BIGINT — Primary key — NOT NULL
  • reporter_user_id — BIGINT — Foreign key → user.id — NOT NULL
  • ref_id — BIGINT — NOT NULL
  • ref_type — VARCHAR(20) — NOT NULL
  • reason — VARCHAR(500) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_time — DATETIME
  • updated_time — DATETIME

reservation

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id
  • reservation_slot_id — BIGINT — Foreign key → reservation_slot.id
  • reservation_date_time — DATETIME — NOT NULL
  • status — VARCHAR(20)
  • cancel_reason — VARCHAR(500)
  • del_yn — VARCHAR(1)
  • created_time — DATETIME
  • updated_time — DATETIME

reservation_slot

  • id — BIGINT — Primary key — NOT NULL
  • gym_id — BIGINT — Foreign key → gym.id
  • slot_date_time — DATETIME — NOT NULL
  • max_capacity — INT — NOT NULL
  • reserved_count — INT — NOT NULL
  • is_closed — TINYINT(1)
  • del_yn — VARCHAR(1)
  • created_time — DATETIME
  • updated_time — DATETIME

review

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • gym_id — BIGINT — Foreign key → gym.id — NOT NULL
  • rating — INT — NOT NULL
  • comment — TEXT — NOT NULL
  • del_yn — VARCHAR(1) — NOT NULL
  • created_time — DATETIME
  • updated_time — DATETIME

user

  • id — BIGINT — Primary key — NOT NULL
  • user_name — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • nick_name — VARCHAR(255)
  • role — VARCHAR(20)
  • del_yn — VARCHAR(1)
  • social_id — VARCHAR(255)
  • social_type — VARCHAR(20)
  • account_status — VARCHAR(20)
  • suspended_until — DATETIME
  • suspend_reason — VARCHAR(255)
  • created_time — DATETIME
  • updated_time — DATETIME

user_suspension_history

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • suspended_by_admin_id — BIGINT
  • suspended_by_admin_email — VARCHAR(255)
  • reason — VARCHAR(500) — NOT NULL
  • suspended_at — DATETIME — NOT NULL
  • suspended_until — DATETIME — NOT NULL
  • released_at — DATETIME
  • release_type — VARCHAR(20)
  • released_by_admin_id — BIGINT
  • released_by_account — VARCHAR(255)
  • created_time — DATETIME
  • updated_time — DATETIME

workout

  • id — BIGINT — Primary key — NOT NULL
  • workout_date — DATETIME
  • workout_condition — VARCHAR(255)
  • del_yn — VARCHAR(1)
  • user_id — BIGINT — Foreign key → user.id — NOT NULL

workout_detail

  • id — BIGINT — Primary key — NOT NULL
  • workout_name — VARCHAR(255)
  • weight — INT
  • set_count — INT
  • rep — INT
  • workout_id — BIGINT — Foreign key → workout.id — NOT NULL