dong1443
Tables (10)
attendance
- attendance_id — VARCHAR(20) — Primary key — NOT NULL
- attendance_date — DATE — NOT NULL
- status — varchar(30)
- professor_id — varchar(20)
- attendance_remarks — VARCHAR(200)
- student_id — VARCHAR(20) — NOT NULL
- course_id — VARCHAR(20) — NOT NULL
course
- course_id — VARCHAR(20) — Primary key — NOT NULL
- dept_id — VARCHAR(20) — NOT NULL
- professor_id — VARCHAR(20) — NOT NULL
- course_name — VARCHAR(100) — NOT NULL
- course_status — varchar(20) — NOT NULL
- course_max_cnt — INT
- course_score — INT — NOT NULL
- credit_category — varchar(30) — NOT NULL
- course_plan — TEXT
course_time
- course_time_id — VARCHAR(20) — Primary key — NOT NULL
- professor_id — varchar(20) — NOT NULL
- course_id — VARCHAR(20) — NOT NULL
- course_time_yoil — ENUM('월', '화', '수', '목', '금', '토', '일')
- course_time_start — TIME
- course_time_end — TIME
dept
- dept_id — VARCHAR(20) — Primary key — NOT NULL
- dept_name — VARCHAR(50) — NOT NULL
notice
- notice_id — VARCHAR(10) — NOT NULL
- writer_id — VARCHAR(10) — NOT NULL
- notice_title — VARCHAR(100) — NOT NULL
- notice_content — TEXT — NOT NULL
- notice_created_at — DATETIME — NOT NULL
- notice_updated_at — DATETIME
- notice_file — VARCHAR(255)
- notice_read_count — INT
post
- post_id — VARCHAR(10) — NOT NULL
- author_id — VARCHAR(10) — NOT NULL
- post_title — VARCHAR(100) — NOT NULL
- post_content — TEXT — NOT NULL
- post_created_at — DATETIME — NOT NULL
- post_updated_at — DATETIME
- post_group — INT
- post_group_level — INT
- post_group_step — INT
- post_file — VARCHAR(255)
- post_read_count — INT
professor
- professor_id — VARCHAR(20) — Primary key — NOT NULL
- professor_name — VARCHAR(50) — NOT NULL
- professor_email — VARCHAR(100)
- professor_birthday — DATE
- professor_phone — VARCHAR(20)
- professor_major — VARCHAR(50)
- professor_img — VARCHAR(255)
- professor_password — VARCHAR(255)
registration
- registration_id — VARCHAR(20) — Primary key — NOT NULL
- student_id — VARCHAR(20) — NOT NULL
- course_id — VARCHAR(20) — NOT NULL
- professor_id — VARCHAR(20) — NOT NULL
- registration_status — varchar(30)
- registration_create — DATETIME
- registration_update — DATETIME
score
- student_id — varchar(20)
- score_id — varchar(20)
- course_id — varchar(20) — NOT NULL
- professor_id — varchar(20) — NOT NULL
- score_end — varchar(20)
- score_level — varchar(20)
- score_etc — varchar(50)
- dept_id — varchar(30) — NOT NULL
student
- student_id — VARCHAR(20) — Primary key — NOT NULL
- student_name — VARCHAR(50) — NOT NULL
- student_num — VARCHAR(20) — NOT NULL
- dept_id — VARCHAR(20) — NOT NULL
- student_email — VARCHAR(100)
- student_password — VARCHAR(255)
- student_status — varchar(20)
- student_birthday — DATE
- student_phone — VARCHAR(20)
- student_img — VARCHAR(255)