daily1_ERD추출하기

테이블 (8)

Subject (과목)

  • subject_id (PK) — int — 기본 키 — NOT NULL
  • subject_name (Field) — varchar

class (반)

  • class_id (Key) — int — 기본 키 — NOT NULL
  • class_number (Field) — int
  • local_id (Key2) — int — 외래 키 → local.local_id — NOT NULL
  • teacher_id (Key3) — int — 외래 키 → teacher.teacher_id — NOT NULL
  • consult_id (Key4) — int — 외래 키 → consultant.consult_id — NOT NULL

consultant (컨설턴트)

  • consult_id (PK) — int — 기본 키 — NOT NULL
  • consultant_name (Field) — varchar
  • work_id (PK2) — int — 외래 키 → work.work_id — NOT NULL

lecture (수강)

  • student_id (Key) — int — 외래 키 → student.student_id — NOT NULL
  • subject_id (Key2) — int — 외래 키 → Subject.subject_id — NOT NULL

local (지역)

  • local_id (PK) — int — 기본 키 — NOT NULL
  • local_name (Field) — varchar

student (교육생)

  • student_id (PK) — int — 기본 키 — NOT NULL
  • semester (Field1) — int
  • major (Field2) — boolean
  • Expulsion (Field3) — boolean
  • class_id (FK) — int — 외래 키 → class.class_id — NOT NULL

teacher (코치)

  • teacher_id (PK) — int — 기본 키 — NOT NULL
  • teacher_name (Field2) — varchar
  • work_id (PK2) — int — 외래 키 → work.work_id — NOT NULL

work (업무)

  • work_id (PK) — int — 기본 키 — NOT NULL
  • work_name (Field) — varchar