ㅈㄷㅎ

Tables (7)

CLASSROOM

  • CLASSROOM_ID — NUMBER — Primary key — NOT NULL — 강의실ID
  • NAME — VARCHAR2(50) — NOT NULL — 강의실명
  • LOCATION — VARCHAR2(100) — 강의실위치

COURSE

  • COURSE_ID — VARCHAR2(20) — Primary key — NOT NULL — 강좌ID
  • PROF_ID — VARCHAR2(20) — Foreign key → PROFESSOR.PROF_ID — NOT NULL — 교수ID
  • CLASSROOM_ID — NUMBER — Foreign key → CLASSROOM.CLASSROOM_ID — NOT NULL — 강의실ID
  • NAME — VARCHAR2(50) — NOT NULL — 강좌명
  • CREDIT — NUMBER(2) — NOT NULL — 취득학점
  • DESCRIPTION — VARCHAR2(200) — 강좌설명
  • YEAR — NUMVER(4) — NOT NULL — 개설년도
  • SEMESTER — VARCHAR2(20) — NOT NULL

DEPARTMENT

  • DEPT_ID — NUMBER — Primary key — NOT NULL — 학과ID
  • NAME — VARCHAR2(50) — NOT NULL — 학과이름
  • OFFICE — VARCHAR(255) — NOT NULL — 학과사무실

ENROLLMENT

  • ENROLL_ID — NUMBER — Primary key — NOT NULL — 수강ID
  • STU_ID — VARCHAR2(20) — Foreign key → STUDENT.STU_ID — NOT NULL — 학생ID
  • COURSE_ID — VARCHAR2(20) — Foreign key → COURSE.COURSE_ID — NOT NULL — 강좌ID
  • STATUS — VARCHAR2(20) — NOT NULL — 수강신청처리상태
  • ENROLLMENT_DATE — DATE — NOT NULL — 수강인청일자

PROFESSOR

  • PROF_ID — VARCHAR2(20) — Primary key — NOT NULL — 교수ID
  • DEPT_ID — NUMBER — Foreign key → DEPARTMENT.DEPT_ID — NOT NULL — 학과ID
  • JUMIN — VARCHAR2(20) — NOT NULL — 주민번호
  • NAME — VARCHAR2(50) — NOT NULL — 교수명
  • HIREDATE — DATE — 입사일

STUDENT

  • STU_ID — VARCHAR2(20) — Primary key — NOT NULL — 학생ID
  • DEPT_ID — NUMBER — Foreign key → DEPARTMENT.DEPT_ID — NOT NULL — 학과ID
  • JUMIN — VARCHAR2(20) — NOT NULL — 주민번호
  • NAME — VARCHAR2(50) — NOT NULL — 학생명
  • GENDER — VARCHAR2(10) — 성별
  • YEAR — NUMBER(2) — NOT NULL — 학년
  • ADDRESS — VARCHAR2(100) — NOT NULL — 주소
  • EMAIL — VARCHAR2(50) — NOT NULL — 이메일
  • PHONE — VARCHAR2(20) — NOT NULL

TAKES

  • STU_ID — VARCHAR2(20) — Foreign key → STUDENT.STU_ID — NOT NULL — 학생ID
  • COURSE_ID — VARCHAR2(20) — Foreign key → COURSE.COURSE_ID — NOT NULL — 강좌ID
  • SCORE — VARCHAR2(20) — 점수