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