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