green
Tables (10)
college
- college_name — VARCHAR2(20 BYTE) — Primary key — NOT NULL
- college_name_en — VARCHAR2(50 BYTE)
- intro_title — VARCHAR2(100 BYTE) — NOT NULL
- intro_body — VARCHAR2(200 BYTE) — NOT NULL
- image_path — VARCHAR2(255 BYTE)
course
- crs_cd — NUMBER — Primary key — NOT NULL
- dept_id — NUMBER — Foreign key → department.dept_id — NOT NULL
- grade — NUMBER(1) — NOT NULL
- div — VARCHAR2(50 BYTE)
- crs_name — VARCHAR2(100 BYTE) — NOT NULL
- p_code — VARCHAR2(50 BYTE) — Foreign key → professor.p_code — NOT NULL
- credit — NUMBER(1) — NOT NULL
- crs_time — VARCHAR2(100 BYTE)
- crs_room — VARCHAR2(50 BYTE)
- capacity — NUMBER(3)
department
- dept_id — NUMBER — Primary key — NOT NULL
- college_college_name — VARCHAR2(20 BYTE) — Foreign key → college.college_name — NOT NULL
- depte_name — VARCHAR2(30) — NOT NULL
- dept_name_en — VARCHAR2(50)
- established — DATE — NOT NULL
- chair_name — VARCHAR2(5) — NOT NULL
- dept_phone — CHAR(12) — NOT NULL
- dept_office — VARCHAR2(50) — NOT NULL
enrollment
- e_id — VARCHAR2(10 BYTE) — Primary key — NOT NULL
- year — NUMBER
- semester — NUMBER
- std_id — NUMBER — Foreign key → student.std_id — NOT NULL
- department — VARCHAR2(50 BYTE)
- crs_cd — NUMBER — Foreign key → course.crs_cd — NOT NULL
- r_date — DATE
notice
- n_no — NUMBER — Primary key — NOT NULL
- n_type — VARCHAR2(20 BYTE) — Primary key — NOT NULL
- title — VARCHAR2(100 BYTE)
- writer — VARCHAR2(20 BYTE)
- wdate — VARCHAR2(10 BYTE)
- hits — NUMBER
professor
- p_code — VARCHAR2(50 BYTE) — Primary key — NOT NULL
- nation — VARCHAR2(20 BYTE)
- name_ko — VARCHAR2(20 BYTE)
- name_en — VARCHAR2(20 BYTE)
- gender — VARCHAR2(10 BYTE)
- jumin — VARCHAR2(30 BYTE)
- hp — VARCHAR2(30)
- email — VARCHAR2(50 BYTE)
- addr_code — NUMBER(10)
- addr — VARCHAR2(100 BYTE)
- addr_detail — VARCHAR2(30 BYTE)
- dept_id — NUMBER — Foreign key → department.dept_id — NOT NULL
- position_code — VARCHAR2(20 BYTE)
- position_detail — VARCHAR2(30 BYTE)
- hire_date — DATE
- status — VARCHAR2(20 BYTE)
- univ — VARCHAR2(30 BYTE)
- graduate_date — DATE
- course — VARCHAR2(30 BYTE)
- ing — VARCHAR2(30 BYTE)
score
- score_no — VARCHAR2(10 BYTE) — Primary key — NOT NULL
- student_std_id — NUMBER — Foreign key → student.std_id — NOT NULL
- course_crs_cd — NUMBER — Foreign key → course.crs_cd — NOT NULL
- mid_score — NUMBER
- final_score — NUMBER
- total_score — NUMBER
- grade — CHAR(2 BYTE)
student
- std_id — NUMBER — Primary key — NOT NULL
- regident_number — VARCHAR2(14 BYTE) — NOT NULL
- name — VARCHAR2(20 BYTE) — NOT NULL
- e_name — VARCHAR2(30 BYTE)
- gender — VARCHAR2(5 BYTE)
- email — VARCHAR2(30 BYTE)
- address — VARCHAR2(100 BYTE) — NOT NULL
- entryyear — VARCHAR2(5 BYTE) — NOT NULL
- graduationyear — VARCHAR2(5 BYTE) — NOT NULL
- division — VARCHAR2(5 BYTE) — NOT NULL
- dept_id — NUMBER — Foreign key → department.dept_id — NOT NULL
- entryterm — VARCHAR2(3 BYTE)
- entrygrade — VARCHAR2(10 BYTE)
- advisor — VARCHAR2(10 BYTE) — NOT NULL
- status — VARCHAR2(50 BYTE) — NOT NULL
student_records
- sr_no — VARCHAR2(10 BYTE) — Primary key — NOT NULL
- year — NUMBER
- grade — NUMBER
- term — NUMBER
- credits_registered — NUMBER
- credits_major — NUMBER
- credits_elective — NUMBER
- credits_other — NUMBER
- credits_general — NUMBER
- credits_earnedd_total — NUMBER
- credits_vol — NUMBER
- gpa — NUMBER
- remark — VARCHAR2(200 BYTE)
- std_id — NUMBER — Foreign key → student.std_id — NOT NULL
- score_no — VARCHAR2(10 BYTE) — Foreign key → score.score_no — NOT NULL
user
- usid — VARCHAR2(20 BYTE) — Primary key — NOT NULL
- pass — VARCHAR2(100 BYTE) — NOT NULL
- us_name — VARCHAR2(20 BYTE) — NOT NULL
- hp — CHAR(13 BYTE)
- email — VARCHAR2(50 BYTE)
- addr1 — VARCHAR2(100 BYTE)
- addr2 — VARCHAR2(100 BYTE)