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