DMS

Tables (6)

extension_apply

  • time — int — Primary key — NOT NULL
  • id (student_id) — varchar(20) — Foreign key → student.id — NOT NULL
  • class_ — int
  • seat — int

point_history

  • id — int — Primary key
  • point_date — date
  • id (student_id) — varchar(20) — Foreign key → student.id — NOT NULL
  • id (point_id) — int — Foreign key → point_item.id

point_item

  • id — int — Primary key
  • reason — varchar(100)
  • point — int
  • type — tinyint(1)

point_status

  • id (student_id) — varchar(20) — Foreign key → student.id — NOT NULL
  • good_point — int
  • bad_point — int
  • penalty_level — int
  • penalty_status — tinyint(1)

stay

  • id (student_id) — varchar(20) — Foreign key → student.id — NOT NULL
  • value — int

student

  • id — varchar(20) — Primary key — NOT NULL
  • pw — varchar(100)
  • name — varchar(20)
  • number — int
  • email — varchar(50)