ㅇㅇ

Tables (5)

courses

  • id — INT — Primary key — NOT NULL
  • code — VARCHAR(20) — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • credits — SMALLINT — NOT NULL
  • professor_id — INT — Foreign key → professors.id

enrollments

  • student_id — BIGINT — Foreign key → students.id — NOT NULL
  • course_id — INT — Foreign key → courses.id — NOT NULL
  • enrolled_at — DATE — NOT NULL
  • score — NUMERIC(5,2)

majors

  • id — INT — Primary key — NOT NULL
  • code — VARCHAR(20) — NOT NULL
  • name — VARCHAR(100) — NOT NULL

professors

  • id — INT — Primary key — NOT NULL
  • prof_no — VARCHAR(20) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • major_id — INT — Foreign key → majors.id

students

  • id — BIGINT — Primary key — NOT NULL
  • student_no — VARCHAR(20) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(200) — NOT NULL
  • phone — VARCHAR(20)
  • major_id — INT — Foreign key → majors.id
  • grade — SMALLINT — NOT NULL
  • enrolled — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL