ㅁ

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