ㅁㄴㅇ
Tables (13)
agent_chat_rooms
- agent_room_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- room_name — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
agents
- agent_id — BIGINT — Primary key — NOT NULL
- agent_room_id — BIGINT — Foreign key → agent_chat_rooms.agent_room_id — NOT NULL
- name — VARCHAR(30) — NOT NULL
- role — VARCHAR(50) — NOT NULL
- persona — VARCHAR(1000) — NOT NULL
- tone — VARCHAR(100)
- goal — VARCHAR(200)
- created_at — DATETIME — NOT NULL
chat_messages
- message_id — BIGINT — Primary key — NOT NULL
- agent_room_id — BIGINT — Foreign key → agent_chat_rooms.agent_room_id — NOT NULL
- agent_id — BIGINT — Foreign key → agents.agent_id
- content — TEXT — NOT NULL
- sender — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
comments
- comment_id — VARCHAR(100) — Primary key — NOT NULL
- post_id — VARCHAR(100) — Foreign key → posts.post_id — NOT NULL
- author_id — BIGINT — Foreign key → users.user_id — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
posts
- post_id — VARCHAR(100) — Primary key — NOT NULL
- author_id — BIGINT — Foreign key → users.user_id — NOT NULL
- category — VARCHAR(50)
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- view_count — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
quizzes
- quiz_id — VARCHAR(100) — Primary key — NOT NULL
- room_id — VARCHAR(100)
- creator_id — BIGINT — Foreign key → users.user_id — NOT NULL
- question — TEXT — NOT NULL
- answer — TEXT — NOT NULL
- explanation — TEXT
- created_at — TIMESTAMP
reports
- report_id — SERIAL — Primary key — NOT NULL
- reporter_id — BIGINT — Foreign key → users.user_id — NOT NULL
- target_type — VARCHAR(20) — NOT NULL
- target_id — VARCHAR(100) — NOT NULL
- reason — TEXT — NOT NULL
- status — VARCHAR(20)
- created_at — TIMESTAMP
room_participants
- room_id — VARCHAR(100) — Foreign key → study_rooms.room_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- joined_at — TIMESTAMP
sanctions
- sanction_id — SERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- admin_id — BIGINT
- type — VARCHAR(20) — NOT NULL
- reason — TEXT
- end_date — TIMESTAMP
- created_at — TIMESTAMP
study_rooms
- room_id — VARCHAR(100) — Primary key — NOT NULL
- author_id — BIGINT — Foreign key → users.user_id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- description — TEXT
- major — VARCHAR(50)
- max_participants — INT
- current_participants — INT
- status — VARCHAR(20)
- created_at — TIMESTAMP
timers
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- start_time — DATETIME — NOT NULL
- end_time — DATETIME
- duration_minutes — BIGINT
- status — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
todos
- todo_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- room_id — VARCHAR(100)
- roadmap_id — VARCHAR(100)
- text — VARCHAR(255) — NOT NULL
- completed — BOOLEAN — NOT NULL
- start_date — DATETIME
- end_date — DATETIME
- due_date — TIMESTAMP
- created_at — DATETIME — NOT NULL
users
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- display_name — VARCHAR(50) — NOT NULL
- photo_url — VARCHAR(255)
- major — VARCHAR(50)
- bio — VARCHAR(255)
- role — VARCHAR(20)
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL