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