관계형데이터베이스

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