ㅇㅇ
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