ktta

Tables (7)

chat

  • chat_id — BIGINT — Primary key — NOT NULL
  • content — VARCHAR(255)
  • Participant (participant) — BIGINT — Foreign key → participant.Participant — NOT NULL
  • room_id — BIGINT — Foreign key → chat_room.room_id — NOT NULL

chat_room (CopyOfparticipant)

  • room_id — BIGINT — Primary key — NOT NULL
  • state (chat_room_state) — ENUM — NOT NULL
  • post_id — BIGINT — Foreign key → post.post_id — NOT NULL

feedback

  • feedback_id — BIGINT — Primary key — NOT NULL
  • score — TINYINT
  • comments — TEXT
  • Participant (participant) — BIGINT — Foreign key → participant.Participant — NOT NULL

like (Like)

  • like_id — Primary key — NOT NULL
  • event_id — BIGINT — Foreign key — NOT NULL
  • user_id — BIGINT — Foreign key — NOT NULL

participant

  • Participant (participant) — BIGINT — Primary key — NOT NULL
  • event_id — BIGINT — Foreign key — NOT NULL
  • user_id — BIGINT — Foreign key — NOT NULL
  • room_id — BIGINT — Foreign key → chat_room.room_id — NOT NULL

post

  • post_id — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — VARCHAR(255)
  • category — VARCHAR(255) — NOT NULL
  • max_capacity — INTEGER — NOT NULL
  • start_date (startDate) — DATETIME — NOT NULL
  • end_date — DATETIME
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • role — VARCHAR(255) — NOT NULL
  • bio — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL