emp

Tables (5)

ASSIGNMENTS (과제)

  • assignment_id (과제ID) — INT — Primary key — NOT NULL
  • title (과제명) — VARCHAR(100)
  • description (과제설명) — TEXT
  • due_date (마감일) — DATETIME

COMMENTS (댓글)

  • comment_id (댓글 ID) — INT — Primary key — NOT NULL
  • content (댓글 내용) — TEXT
  • created_at (작성 시간) — DATETIME
  • submission_id (제출ID) — INT — Foreign key → SUBMISSIONS.submission_id — NOT NULL
  • user_id (작성자 ID) — INT — Foreign key → USERS.user_id — NOT NULL

SUBMISSIONS (제출)

  • submission_id (제출ID) — INT — Primary key — NOT NULL
  • file_url (제출링크) — VARCHAR(255)
  • feedback (피드백) — TEXT
  • score (점수) — INT
  • submitted_at (제출시간) — DATETIME
  • team_id (팀ID) — INT — Foreign key → TEAMS.team_id — NOT NULL
  • assignment_id (과제ID) — INT — Foreign key → ASSIGNMENTS.assignment_id — NOT NULL
  • submitted_by (제출자ID) — INT — Foreign key → USERS.user_id — NOT NULL

TEAMS (팀)

  • team_id (팀ID) — INT — Primary key — NOT NULL
  • team_name (팀명) — VARCHAR(50)
  • leader_id (팀장ID) — INT — Foreign key → USERS.user_id — NOT NULL

USERS (사용자)

  • user_id (사용자ID) — INT — Primary key — NOT NULL
  • name (이름) — VARCHAR(50)
  • email (이메일) — VARCHAR(100)
  • password (비밀번호) — VARCHAR(100)
  • role (역할) — VARCHAR(20)
  • team_id (팀ID) — INT