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