Register management

Tables (3)

COUNT_INFO

  • Field (ATTENDENCE_COUNT) — INTEGER
  • Field (QUIZ_COUNT) — INTEGER
  • Field (QUESTION_COUNT) — INTEGER

Major

  • Field (MAJOR_Name) — STRING — Primary key
  • Field2 (STUDENT_ID) — STRING

Member

  • Key (STUDENT_ID) — STRING — Primary key — NOT NULL
  • Field (MAJOR_Name) — STRING — Foreign key → Major.Field
  • Field (NAME) — STRING
  • Field2 (POSITION) — STRING
  • Field3 (GRADE) — INTEGER
  • Field (PHONE_NUMBER) — STRING
  • Field (STATUS) — STRING
  • Field (COUNT) — COUNT_INFO
  • Field (GENDER) — STRING