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