ㅁ
Tables (11)
chat_message
- id — BIGINT
- room_id — BIGINT — Foreign key → chat_room.id — NOT NULL
- sender_id — BIGINT — Foreign key — NOT NULL
- message — TEXT — NOT NULL
- created_at — DATETIME
- Key — Foreign key → users.id — NOT NULL
chat_room
- id — BIGINT
- user_id — BIGINT — Foreign key — NOT NULL
- gym_id — BIGINT — Foreign key → gym.id — NOT NULL
- Key — Foreign key → users.id — NOT NULL
comment
- id — BIGINT
- post_id — BIGINT — Foreign key → post.id — NOT NULL
- author_id — BIGINT — Foreign key — NOT NULL
- parent_id — BIGINT — Foreign key → comment.id
- content — TEXT
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME
- Key — Foreign key → users.id — NOT NULL
gym
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- address — VARCHAR(255)
- owner_id — BIGINT — Foreign key — NOT NULL
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME
- Key — Foreign key → users.id — NOT NULL
gym_favorite
- id — BIGINT
- user_id — BIGINT — Foreign key — NOT NULL
- gym_id — BIGINT — Foreign key → gym.id — NOT NULL
- Key — Foreign key → users.id — NOT NULL
notification
- id — BIGINT
- user_id — BIGINT — Foreign key — NOT NULL
- type — VARCHAR(50)
- ref_id — BIGINT
- is_read — BOOLEAN
- created_at — DATETIME
- Key — Foreign key → users.id — NOT NULL
post
- id — BIGINT
- author_id — BIGINT — Foreign key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME
- Key — Foreign key → users.id — NOT NULL
review
- id — BIGINT
- user_id — BIGINT — Foreign key — NOT NULL
- gym_id — BIGINT — Foreign key → gym.id — NOT NULL
- rating — INT — NOT NULL
- content — TEXT
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME
- Key — Foreign key → users.id — NOT NULL
review_report
- id — BIGINT
- review_id — BIGINT — Foreign key → review.id — NOT NULL
- reporter_id — BIGINT — Foreign key — NOT NULL
- reason — VARCHAR(255)
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME
- Key — Foreign key → users.id — NOT NULL
users
- id — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(100)
- role — VARCHAR(30) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME
- deleted_at — DATETIME
workout
- id — BIGINT
- user_id — BIGINT — Foreign key — NOT NULL
- workout_date — DATE — NOT NULL
- content — TEXT
- status — VARCHAR(30) — NOT NULL
- Key — Foreign key → users.id — NOT NULL