Study
Tables (6)
chat_message
- id — BIGINT
- room_id — BIGINT — NOT NULL
- sender_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- sent_at — DATETIME
chat_room
- id — BIGINT
- group_id — BIGINT — NOT NULL
- name — VARCHAR(255)
- created_at — DATETIME
group_member
- id — BIGINT
- user_id — BIGINT — NOT NULL
- group_id — BIGINT — NOT NULL
- joined_at — DATETIME
- is_deleted — BOOLEAN
- deleted_at — DATETIME
study_group
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- owner_id — BIGINT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- is_deleted — BOOLEAN
- deleted_at — DATETIME
study_log
- id — BIGINT
- user_id — BIGINT — NOT NULL
- group_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- is_deleted — BOOLEAN
- deleted_at — DATETIME
user
- id — BIGINT — Primary key
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- is_deleted — BOOLEAN
- deleted_at — DATETIME