skala-subject

Tables (6)

Untitled

    course

    • course_id — INT — Primary key — NOT NULL — 강의 PK
    • course_name — VARCHAR(50) — NOT NULL — 강의명
    • prof_id — INT — Foreign key → professor.prof_id — 담당 교수 FK(미배정 NULL)
    • credit — SMALLINT — NOT NULL — 학점(1~3)
    • semester — VARCHAR(10) — NOT NULL — 개설 학기

    department

    • dept_id — INT — Primary key — NOT NULL — 학과 PK
    • dept_name — VARCHAR(50) — NOT NULL — 학과명
    • location — VARCHAR(50) — 위치

    enrollment

    • enroll_id — INT — Primary key — NOT NULL — 수강신청 PK
    • student_id — INT — Foreign key → student.student_id — NOT NULL — 학생 FK
    • course_id — INT — Foreign key → course.course_id — NOT NULL — 강의 FK
    • request_at — TIMESTAMP — NOT NULL — 신청 시각
    • grade — DECIMAL(3, 1) — 성적(0~4.5, 미입력 NULL)

    professor

    • prof_id — INT — Primary key — NOT NULL — 교수 PK
    • prof_name — VARCHAR(30) — NOT NULL — 교수명
    • dept_id — INT — Foreign key → department.dept_id — NOT NULL — 소속 학과 FK
    • hire_date — DATE — NOT NULL — 임용일

    student

    • student_id — INT — Primary key — NOT NULL — 학생 PK
    • student_name — VARCHAR(30) — NOT NULL — 학생명
    • dept_id — INT — Foreign key → department.dept_id — NOT NULL — 소속 학과 FK
    • grade_year — SMALLINT — NOT NULL — 학년(1~4)
    • enroll_date — DATE — NOT NULL — 입학일
    • email — VARCHAR(50) — 이메일