importTEST
Tables (9)
DEPARTMENT
- DEPT_ID — NUMBER(5) — Primary key — NOT NULL
- DEPT_NAME — VARCHAR2(30)
- DEPT_TEL — VARCHAR2(30)
ENROLLMENT
- OC_ID — VARCHAR2(5) — Foreign key → OPEN_COURSE.OC_ID — NOT NULL
- STUD_ID — VARCHAR2(13) — Foreign key → STUDENTS.STUD_ID — NOT NULL
- FINAL_SCORE — NUMBER(3)
EVALUATION
- OC_ID — VARCHAR2(5) — Foreign key → ENROLLMENT.OC_ID — NOT NULL
- STUD_ID — VARCHAR2(13) — Foreign key → ENROLLMENT.STUD_ID — NOT NULL
- T_TYPE — NUMBER(2) — Foreign key → TEST_TYPE.T_TYPE — NOT NULL
- E_SCORE — NUMBER(3)
LECTURE
- LEC_ID — VARCHAR2(5) — Primary key — NOT NULL
- LEC_NAME — VARCHAR2(50)
- CREDIT — NUMBER(1)
OPEN_COURSE
- OC_ID — VARCHAR2(5) — Primary key — NOT NULL
- OC_TOTAL_TIME — NUMBNER(1)
- LEC_ID — VARCHAR2(5) — NOT NULL
- P_ID — NUMBER(3) — NOT NULL
OPEN_COURSE_INFO
- OC_SEQ — NUMBER(1) — Primary key — NOT NULL
- OC_ID — VARCHAR2(5) — Foreign key → OPEN_COURSE.OC_ID — NOT NULL
- OC_WEEK — VARCHAR2(10)
- OC_TIME — NUMBER(1)
- OC_ROOM — VARCHAR2(5)
- OC_PERIOD — NUMBER(2)
PROFESSOR
- P_ID — NUMBER(3) — Primary key — NOT NULL
- P_NAME — VARCHAR2(30)
- P_MAJOR — VARCHAR2(50)
- P_TEL — VARCHAR2(30)
- DEPT_ID — NUMBER(5) — NOT NULL
STUDENTS
- STUD_ID — VARCHAR2(13) — Primary key — NOT NULL
- STUD_NAME — VARCHAR2(30)
- STUD_TEL — VARCHAR2(30)
- STUD_EMAIL — VARCHAR2(50)
- STUD_ZIPCODE — VARCHAR2(10)
- STUD_ADD1 — VARCHAR2(255)
- STUD_ADD2 — VARCHAR2(100)
- DEPT_ID — NUMBER(5) — NOT NULL
TEST_TYPE
- T_TYPE — NUMBER(2) — Primary key — NOT NULL
- TYPE_NAME — VARCHAR2(30)