asd

Tables (11)

chat_message

  • id — BIGINT
  • room_id — BIGINT — Foreign key → chat_room.id — NOT NULL
  • sender_id — BIGINT — Foreign key → users.id — NOT NULL
  • message — TEXT — NOT NULL
  • created_at — DATETIME

chat_room

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • gym_id — BIGINT — Foreign key → gym.id — NOT NULL

comment

  • id — BIGINT
  • post_id — BIGINT — Foreign key → post.id — NOT NULL
  • author_id — BIGINT — Foreign key → users.id — NOT NULL
  • parent_id — BIGINT — Foreign key → comment.id
  • content — TEXT
  • status — VARCHAR(30) — NOT NULL
  • created_at — DATETIME

gym

  • id — BIGINT
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • address — VARCHAR(255)
  • owner_id — BIGINT — Foreign key → users.id — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • created_at — DATETIME

gym_favorite

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • gym_id — BIGINT — Foreign key → gym.id — NOT NULL

notification

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • type — VARCHAR(50)
  • ref_id — BIGINT
  • is_read — BOOLEAN
  • created_at — DATETIME

post

  • id — BIGINT
  • author_id — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT
  • status — VARCHAR(30) — NOT NULL
  • created_at — DATETIME

review

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id — 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

review_report

  • id — BIGINT
  • review_id — BIGINT — Foreign key → review.id — NOT NULL
  • reporter_id — BIGINT — Foreign key → users.id — NOT NULL
  • reason — VARCHAR(255)
  • status — VARCHAR(30) — NOT NULL
  • created_at — DATETIME

users

  • id — BIGINT
  • 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 → users.id — NOT NULL
  • workout_date — DATE — NOT NULL
  • content — TEXT
  • status — VARCHAR(30) — NOT NULL