ㅁㄴㅇ

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