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)