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