학사관리

테이블 (12)

ENROLLMENT

  • student_id — VARCHAR(10) — 외래 키 → STUDENT.student_id — NOT NULL
  • lecture_id — VARCHAR(10) — 외래 키 → LECTURE.lecture_id — NOT NULL
  • grade — VARCHAR(5)

INSTRUCTOR

  • instructor_id — VARCHAR(10) — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • age — INT
  • gender — CHAR(1)

LECTURE

  • lecture_id — VARCHAR(10) — 기본 키 — NOT NULL
  • lecture_time — VARCHAR(50)
  • location — VARCHAR(100)
  • subject_id — VARCHAR(10) — 외래 키 → SUBJECT.subject_id — NOT NULL
  • instructor_id — VARCHAR(10) — 외래 키 → INSTRUCTOR.instructor_id — NOT NULL

NOTICE

  • notice_id — VARCHAR(10) — 기본 키 — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT
  • created_date — DATE
  • instructor_id — VARCHAR(10) — 외래 키 → INSTRUCTOR.instructor_id — NOT NULL
  • lecture_id — VARCHAR(10) — 외래 키 → LECTURE.lecture_id — NOT NULL

STUDENT

  • student_id — VARCHAR(10) — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • address — VARCHAR(200)

SUBJECT

  • subject_id — VARCHAR(10) — 기본 키 — NOT NULL
  • subject_name — VARCHAR(100) — NOT NULL

enrollment

  • student_id — VARCHAR(10) — 외래 키 → student.student_id — NOT NULL
  • lecture_id — VARCHAR(10) — 외래 키 → lecture.lecture_id — NOT NULL
  • grade — VARCHAR(5)

instructor

  • instructor_id — VARCHAR(10) — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • age — INT
  • gender — CHAR(1)

lecture

  • lecture_id — VARCHAR(10) — 기본 키 — NOT NULL
  • lecture_time — VARCHAR(50)
  • location — VARCHAR(100)
  • subject_id — VARCHAR(10) — 외래 키 → subject.subject_id — NOT NULL
  • instructor_id — VARCHAR(10) — 외래 키 → instructor.instructor_id — NOT NULL

notice

  • notice_id — VARCHAR(10) — 기본 키 — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT
  • created_date — DATE
  • instructor_id — VARCHAR(10) — 외래 키 → instructor.instructor_id — NOT NULL
  • lecture_id — VARCHAR(10) — 외래 키 → lecture.lecture_id — NOT NULL

student

  • student_id — VARCHAR(10) — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • address — VARCHAR(200)

subject

  • subject_id — VARCHAR(10) — 기본 키 — NOT NULL
  • subject_name — VARCHAR(100) — NOT NULL