ssafy

Tables (4)

Untitled (teacher)

  • id — bigint(20) — Primary key — NOT NULL
  • nickname — varchar(20) — NOT NULL
  • name — varchar(20) — NOT NULL
  • phone — varchar(20)
  • region — varchar(20) — NOT NULL

attendance

  • id — bigint(20) — Primary key — NOT NULL
  • attendance_1/1 — tinyint(1)
  • Field2
  • Field3
  • Field4

grade

  • id — bigint(20) — Primary key — NOT NULL
  • first_exam — varchar(3)
  • second_exam — varchar(3)
  • third_exam — varchar(3)
  • algorithm_grade — varchar(20)
  • algorithm_acquisition_date — datetime

student

  • id — bigint(20) — Primary key — NOT NULL
  • account — varchar(20) — NOT NULL
  • name — varchar(100) — NOT NULL
  • phone — varchar(20)
  • age — varchar(5)
  • gender — varchar(20)
  • curriculum — varchar(20)
  • region — varchar(20)
  • group — varchar(20) — NOT NULL