TB_LIKE

Tables (3)

CLASS (Untitled3)

  • CLASS_CODE (과목코드) — VARCHAR2(20) — Primary key — NOT NULL
  • CLASS_NAME (과목이름) — VARCHAR2(40)
  • PROFESSOR_NO (담당교수 번호) — NUMBER

DEPARTMENT (Untitled2)

  • DEPARTMENT_NO (학과번호) — VARCHAR2(20) — Primary key — NOT NULL
  • DPARTMENT_NAME (학과이름) — VARCHAR2(40)
  • PROFESSOR_NO (담당교수 번호) — NUMBER

STUDENT (Untitled)

  • STUDENT_ID (학생아이디) — VARCHAR2(20) — Primary key — NOT NULL
  • STUDENT_NAME (학생이름) — VARCHAR2(20)
  • DEPARTMENT_TITLE (학과이름) — VARCHAR2(40)
  • STUDENT_NO (학생주민번호) — VARCHAR2(40)
  • HIRE_DATE (입학일) — VARCHAR2(40)
  • GENDER (성별) — VARCHAR2(40)
  • STUDENT_NUMBER (학번) — VARCHAR2(40)