univ ERD
Tables (19)
ex_relation
- id — int — Primary key — NOT NULL
- account_name — varchar
- password — varchar
- center — varchar
- created_at — date
le_answer_submission
- id — INT — Primary key — NOT NULL
- question_id — INT — NOT NULL
- student_id — INT — NOT NULL
- answer — VARCHAR(3000)
- created_at — DATETIME
le_assignment
- id — INT — Primary key — NOT NULL
- lecture_sectrion_id — INT — NOT NULL
- title — VARCHAR(100)
- description — VARCHAR(6000)
- start_time — DATETIME
- end_time — DATETIME
- score — INT
- answer — VARCHAR(6000)
- created_at — DATETIME
le_assignment_submission
- id — INT — Primary key — NOT NULL
- assignment_id — INT — NOT NULL
- student_Id — INT — NOT NULL
- answer — VARCHAR(3000)
- received_score — INT
- created_at — DATETIME
le_attendence
- id — INT — Primary key — NOT NULL
- enrollment_id — INT — NOT NULL
- session_no — INT
- status — VARCHAR(20)
- created_at — DATETIME
le_enrollment
- id — INT — Primary key — NOT NULL
- student_id — INT — NOT NULL
- lecture_section_id — INT — NOT NULL
- is_passed — BOOLEAN
- active — BOOLEAN
- created_at — DATETIME
le_exam
- id — INT — Primary key — NOT NULL
- lecture_section_id — INT — NOT NULL
- title — VARCHAR(30)
- start_time — DATETIME
- end_time — DATETIME
- created_at — DATETIME
le_lecture
- id — INT — Primary key — NOT NULL
- lecturer_id — INT — NOT NULL
- title — VARCHAR(50)
- tuition_fee — INT
- exam_ratio — INT
- assignment_ratio — INT
- attendence_ratio — INT
- syllabus_address — VARCHAR(1000)
- created_at — DATETIME
le_lecture_article
- id — INT — Primary key — NOT NULL
- lecture_section_id — INT — NOT NULL
- type — VARCAHR(20)
- title — VARCHAR(50)
- content — VARCHAR(3000)
- created_at — DATETIME
le_lecture_evaluation_answer
- id — INT — Primary key — NOT NULL
- lecture_evaluation_question_id — INT — NOT NULL
- enrollment_id — INT — NOT NULL
- score — INT
- content — VARCHAR(2000)
- created_at — DATETIME
le_lecture_evaluation_question
- id — INT — Primary key — NOT NULL
- lecture_id — INT — NOT NULL
- number — INT
- content — VARCHAR(200)
- created_at — DATETIME
le_lecture_section
- id — INT — Primary key — NOT NULL
- lecture_id — INT — NOT NULL
- classification — VARCHAR(10)
- max_enrollment — INT
- total_session — INT
- start_date — DATE
- end_date — DATE
- created_at — DATETIME
le_lecture_time
- id — INT — Primary key — NOT NULL
- lecture_section_id — INT — NOT NULL
- day_of_week — VARCHAR(3)
- start_time — TIME
- end_time — TIME
- classroom_id — VARCHAR(50)
- created_at — DATETIME
le_lecturer
- id — INT — Primary key — NOT NULL
- relation_id — INT — NOT NULL
- name — VARCHAR(20)
- gender — VARCHAR(1)
- birth — DATE
- email — VARCHAR(50)
- phone — VARCHAR(30)
- created_at — DATETIME
le_payment
- id — INT — Primary key — NOT NULL
- enrollment_id — INT — NOT NULL
- bank_name — VARCHAR(20)
- bank_account — VARCHAR(50)
- status — VARCHAR(10)
- paid_at — DATETIME
- created_at — DATETIME
le_question
- id — INT — Primary key — NOT NULL
- exam_id — INT — NOT NULL
- question_number — INT
- question_content — VARCHAR(2000)
- answer — VARCHAR(30)
- score — INT
- created_at — DATETIME
le_refund
- id — INT — Primary key — NOT NULL
- payment_id — INT — NOT NULL
- bank_name — VARCHAR(20)
- bank_account — VARCHAR(50)
- reason — VARCHAR(200)
- status — VARCHAR(10)
- processed_at — DATETIME
- created_at — DATETIME
le_student
- id — INT — Primary key — NOT NULL
- relation_id — INT — NOT NULL
- name — VARCHAR(20)
- gender — VARCHAR(1)
- phone — VARCHAR(30)
- address — VARCHAR(500)
- birth — DATETIME
- email — VARCHAR(30)
- created_at — DATETIME
student_enroll_semester
- id — int — Primary key — NOT NULL
- credit — int
- gpa — double
- created_at — date