finalTeam
Tables (12)
AI_Schedule_Session
- id — SERIAL
- team_id — INTEGER — Foreign key → Team.id — NOT NULL
- goal — VARCHAR(255) — NOT NULL
- deadline — DATE — NOT NULL
- status — VARCHAR(20)
- created_at — TIMESTAMP
AI_Schedule_Task
- id — SERIAL
- session_id — INTEGER — Foreign key → AI_Schedule_Session.id — NOT NULL
- task_name — VARCHAR(100) — NOT NULL
- start_date — DATE
- due_date — DATE
- created_at — TIMESTAMP
Chat_Message
- id — SERIAL
- room_id — INTEGER — Foreign key → Chat_Room.id — NOT NULL
- sender_id — INTEGER — Foreign key → User.id — NOT NULL
- message_content — TEXT — NOT NULL
- created_at — TIMESTAMP
Chat_Room
- id — SERIAL
- team_id — INTEGER — Foreign key → Team.id — NOT NULL
- room_name — VARCHAR(100)
- created_at — TIMESTAMP
Chat_Room_Member
- room_id — INTEGER — Foreign key → Chat_Room.id — NOT NULL
- user_id — INTEGER — Foreign key → User.id — NOT NULL
- joined_at — TIMESTAMP
Evaluation
- id — SERIAL
- team_id — INTEGER — Foreign key → Team.id — NOT NULL
- evaluator_id — INTEGER — Foreign key → User.id — NOT NULL
- evaluatee_id — INTEGER — Foreign key → User.id — NOT NULL
- score_participation — SMALLINT
- score_responsibility — SMALLINT
- score_communication — SMALLINT
- score_collaboration — SMALLINT
- score_creativity — SMALLINT
- comment — TEXT
- created_at — TIMESTAMP
Notice
- id — SERIAL
- team_id — INTEGER — Foreign key → Team.id — NOT NULL
- author_id — INTEGER — Foreign key → User.id — NOT NULL
- title — VARCHAR(150) — NOT NULL
- content — TEXT
- is_leader_notice — BOOLEAN
- created_at — TIMESTAMP
Reference_Room
- id — SERIAL
- team_id — INTEGER — Foreign key → Team.id — NOT NULL
- uploader_id — INTEGER — Foreign key → User.id — NOT NULL
- file_name — VARCHAR(255) — NOT NULL
- file_url — TEXT — NOT NULL
- created_at — TIMESTAMP
Task
- id — SERIAL
- team_id — INTEGER — Foreign key → Team.id — NOT NULL
- assignee_id — INTEGER — Foreign key → User.id
- task_name — VARCHAR(100) — NOT NULL
- due_date — DATE
- status — VARCHAR(20)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Team
- id — SERIAL
- team_name — VARCHAR(100) — NOT NULL
- subject_name — VARCHAR(100)
- invite_code — VARCHAR(20) — NOT NULL
- status — VARCHAR(20)
- deadline — DATE
- leader_id — INTEGER — NOT NULL
- created_at — TIMESTAMP
Team_Member
- id — SERIAL
- team_id — INTEGER — Foreign key → Team.id — NOT NULL
- user_id — INTEGER — Foreign key → User.id — NOT NULL
- joined_at — TIMESTAMP
User
- id — SERIAL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- department — VARCHAR(100)
- student_id — VARCHAR(20)
- profile_image_url — TEXT
- residence — VARCHAR(100)
- intro — TEXT
- created_at — TIMESTAMP