1

Tables (7)

class

  • class_id — TINYINT
  • school_year_id — TINYINT — NOT NULL
  • teacher_id — INT — NOT NULL
  • teacher_assigned_at — DATE — NOT NULL
  • class_name — VARCHAR(50)
  • use_flag — BOOLEAN — NOT NULL

grade

  • lecture_id — INT
  • student_id — INT
  • grade — TINYINT — NOT NULL

lecture

  • lecture_id — INT
  • subject_id — TINYINT — NOT NULL
  • lecture_begin_at — DATE — NOT NULL
  • teacher_id — INT — NOT NULL
  • school_year_id — TINYINT — NOT NULL

school_year

  • school_year_id — TINYINT
  • school_year_name — VARCHAR(50)

student

  • student_id — INT
  • class_id — TINYINT
  • student_number — TINYINT
  • gender — ENUM('M', 'F')
  • entrance_date — DATE — NOT NULL
  • graduate_date — DATE

subject

  • subject_id — TINYINT
  • subject_name — VARCHAR(50)

teacher

  • teacher_id — INT
  • teacher_name — VARCHAR(50)