albo

ALBO ERD

Tables (8)

Class (class)

  • Class_Id (id) — varchar(255) — Primary key — NOT NULL
  • Affiliated_Institution_Type (affiliatedInstitutionType) — varchar(255) — NOT NULL
  • Affiliated_Institution_Name (affiliatedInstitutionName) — varchar(255) — NOT NULL
  • Class_Name (name) — varchar(255) — NOT NULL
  • Descriptions (descriptions) — varchar(255) — NOT NULL
  • Class_Type (type) — varchar(255) — NOT NULL
  • Class_students (students) — number — NOT NULL
  • Class_managers (managers) — number — NOT NULL

Group (group)

  • id (id2) — Primary key — NOT NULL
  • Group_Name (name) — varchar(255)
  • Class_Id (id) — varchar(255) — Foreign key → Class.Class_Id — NOT NULL

Note (note)

  • Note_Id (id) — varchar(255) — Primary key — NOT NULL
  • Note_Name (name) — varchar(255) — NOT NULL

Student (student)

  • Student_Id (id) — varchar(255) — Primary key — NOT NULL
  • Email (email) — varchar(255) — NOT NULL
  • Platfrom (platform) — varchar(255) — NOT NULL
  • Name (name) — varchar(255) — NOT NULL
  • Password (password) — varchar(255) — NOT NULL
  • Jobcode (jobcode) — varchar(255) — NOT NULL
  • School (school) — varchar(255) — NOT NULL

Teacher (teacher)

  • Teacher_Id (id) — varchar(255) — Primary key — NOT NULL
  • Email (email) — varchar(255) — NOT NULL
  • Platfrom (platform) — varchar(255) — NOT NULL
  • Name (name) — varchar(255) — NOT NULL
  • Password (password) — varchar(255) — NOT NULL
  • Jobcode (jobcode) — varchar(255) — NOT NULL
  • School (school) — varchar(255) — NOT NULL

Untitled

  • User_Id (id) — varchar(255) — Foreign key → User.User_Id — NOT NULL
  • id (id2) — Foreign key → Group.id — NOT NULL

User (user)

  • User_Id (id) — varchar(255) — Primary key — NOT NULL
  • Email (email) — varchar(255) — NOT NULL
  • Platfrom (platform) — varchar(255) — NOT NULL
  • Name (name) — varchar(255) — NOT NULL
  • Password (password) — varchar(255) — NOT NULL
  • Jobcode (jobcode) — varchar(255) — NOT NULL
  • School (school) — varchar(255) — NOT NULL

User Class (user_class)

  • User_Id (id) — varchar(255) — Foreign key → User.User_Id — NOT NULL
  • Class_Id (id2) — varchar(255) — Foreign key → Class.Class_Id — NOT NULL
  • Auth_Type (authType) — varchar(255) — NOT NULL