관계형데이터베이스
sample_erm
테이블 (6)
AttendanceTable (attendance)
- Pk (attendance_id) — INT(11) — 기본 키 — NOT NULL
- Field (attendance) — VARCHAR(255)
GradeTable (grade)
- Pk (grade_id) — INT(11) — 기본 키 — NOT NULL
- Field (grade_first) — CHAR(2)
- Field (grade_second) — CHAR(2)
- Field (grade_third) — CHAR(2)
Project Grade (project grade)
ProjectTable (project)
- Pk (project_id) — INT(11) — 기본 키 — NOT NULL
- Field (project_name) — VARCHAR(255)
- Field (due_date) — CHAR(8)
- Field (information) — VARCHAR(255)
User Attendance (user attendance)
- Pk (user_id) — INT(11) — 외래 키 → UserTable.Pk — NOT NULL
- Field (attendance_id) — INT(11) — 외래 키 → AttendanceTable.Pk — NOT NULL
UserTable (usertable)
- Pk (user_id) — INT(11) — 기본 키 — NOT NULL
- Field (last_name) — VARCHAR(255)
- Field (first_name) — VARCHAR(255)
- Field (phone) — VARCHAR(20)
- Field (email) — VARCHAR(255)
- Field (gender) — CHAR(1)
- Field (birthday) — CHAR(8)
- Project_id (project_id) — INT(11) — 외래 키 → ProjectTable.Pk — NOT NULL
- Grade_id (grade_id) — INT(11) — 외래 키 → GradeTable.Pk — NOT NULL