UNIVERSITY

Tables (20)

ADMIN

  • admin_id — VARCHAR2(20)
  • password — VARCHAR2(100) — NOT NULL
  • name — VARCHAR2(50) — NOT NULL
  • email — VARCHAR2(100)
  • phone — VARCHAR2(20)

CLASSROOM

  • classroom_id — VARCHAR2(20)
  • building — VARCHAR2(50)
  • room_number — VARCHAR2(20)
  • capacity — NUMBER(3)

COMMENT_LIKE

  • like_id — NUMBER
  • comment_id — NUMBER — NOT NULL
  • user_id — VARCHAR2(20) — NOT NULL
  • liked_at — DATE

COMMUNITY_CATEGORY

  • category_id — NUMBER
  • category_name — VARCHAR2(50) — NOT NULL

COMMUNITY_COMMENT

  • comment_id — NUMBER
  • post_id — NUMBER — NOT NULL
  • user_id — VARCHAR2(20) — NOT NULL
  • comment_text — VARCHAR2(1000) — NOT NULL
  • commented_at — DATE

COMMUNITY_LIKE

  • like_id — NUMBER
  • post_id — NUMBER — NOT NULL
  • user_id — VARCHAR2(20) — NOT NULL
  • liked_at — DATE

COMMUNITY_POST

  • post_id — NUMBER
  • user_id — VARCHAR2(20) — NOT NULL
  • category_id — NUMBER — NOT NULL
  • title — VARCHAR2(200) — NOT NULL
  • content — CLOB — NOT NULL
  • created_at — DATE
  • view_count — NUMBER

ENROLLMENT

  • enrollment_id — NUMBER
  • student_id — VARCHAR2(20) — NOT NULL
  • lecture_id — VARCHAR2(20) — NOT NULL
  • enrollment_date — DATE — NOT NULL

GRADE

  • grade_id — NUMBER
  • student_id — VARCHAR2(20) — NOT NULL
  • lecture_id — VARCHAR2(20) — NOT NULL
  • term_id — VARCHAR2(10) — NOT NULL
  • grade — VARCHAR2(2)

LECTURE

  • lecture_id — VARCHAR2(20)
  • subject_id — VARCHAR2(20) — NOT NULL
  • professor_id — VARCHAR2(20) — NOT NULL
  • year — NUMBER(4) — NOT NULL
  • semester — VARCHAR2(10)
  • max_capacity — NUMBER(3) — NOT NULL

NOTICE

  • notice_no — NUMBER
  • notice_title — VARCHAR2(200) — NOT NULL
  • notice_content — CLOB — NOT NULL
  • notice_count — NUMBER
  • notice_created_at — DATE
  • admin_id — VARCHAR2(20) — NOT NULL

NOTICE_FILE

  • file_no — NUMBER
  • notice_no — NUMBER — NOT NULL
  • file_name — VARCHAR2(200) — NOT NULL
  • file_path — VARCHAR2(500) — NOT NULL

PROFESSOR

  • professor_id — VARCHAR2(20)
  • user_id — VARCHAR2(20) — NOT NULL
  • department — VARCHAR2(50)
  • position — VARCHAR2(50)

SCHEDULE

  • schedule_id — NUMBER
  • lecture_id — VARCHAR2(20) — NOT NULL
  • classroom_id — VARCHAR2(20) — NOT NULL
  • day_of_week — VARCHAR2(10)
  • start_time — DATE — NOT NULL
  • end_time — DATE — NOT NULL

SITE_CONFIG

  • config_id — NUMBER
  • site_title — VARCHAR2(100)
  • main_banner — VARCHAR2(200)
  • footer_message — VARCHAR2(200)
  • last_updated — DATE
  • admin_id — VARCHAR2(20) — NOT NULL

STUDENT

  • student_id — VARCHAR2(20)
  • user_id — VARCHAR2(20) — NOT NULL
  • department — VARCHAR2(50)
  • year — NUMBER(1)

SUBJECT

  • subject_id — VARCHAR2(20)
  • subject_name — VARCHAR2(100) — NOT NULL
  • credit — NUMBER(1) — NOT NULL

TERM

  • term_id — VARCHAR2(10)
  • year — NUMBER(4) — NOT NULL
  • semester — VARCHAR2(10)

USERINFO

  • user_id — VARCHAR2(20)
  • password — VARCHAR2(100) — NOT NULL
  • name — VARCHAR2(50) — NOT NULL
  • email — VARCHAR2(100)
  • phone — VARCHAR2(20)
  • role — VARCHAR2(20)

USER_MANAGEMENT_LOG

  • log_id — NUMBER
  • admin_id — VARCHAR2(20) — NOT NULL
  • target_user_id — VARCHAR2(20) — NOT NULL
  • action — VARCHAR2(100)
  • action_time — DATE