test
Tables (12)
Algorithm (algorithm)
- algorithm_pk — int — Primary key — NOT NULL
- student_pk — int — Foreign key → Student.student_pk — NOT NULL
- algorithm_grade — char(2) — NOT NULL
- algorithm_acquisition_date — datetime — NOT NULL
Attendance (attendace)
- attendance_pk — int — Primary key — NOT NULL — PK
- student_pk — int — Foreign key → Student.student_pk — NOT NULL — PK
- date_pk — int — Foreign key → AttendanceDate.date_pk — NOT NULL
- attendance — tinyint
- attendance_sign_in_time (datetime) — datetime
- attendance_sign_out_time — datetime
AttendanceDate (attendance_date)
- date_pk — int — Primary key — NOT NULL
- attendace_date (attendance_date) — char(10) — NOT NULL
Exam (exam)
- exam_pk — int — Primary key — NOT NULL
- exam_name
GradeExam (grade_exam)
- grade_exam_pk — int — Primary key — NOT NULL
- student_pk — int — Foreign key → Student.student_pk — NOT NULL
- exam_pk (exam_pk2) — int — Foreign key → Exam.exam_pk — NOT NULL
- grade_exam_score — int — NOT NULL
GroupTeacher (group_teacher)
- group_teacher_pk — int — Primary key — NOT NULL — PK
- group_teacher_id — varchar — NOT NULL
- group_teacher_name — varchar — NOT NULL
- group_teacher_hp — varchar — NOT NULL
Student (student)
- student_pk — int — Primary key — NOT NULL
- group_teacher_pk — int — Foreign key → GroupTeacher.group_teacher_pk — NOT NULL
- student_account — varchar(20) — NOT NULL
- student_name — varchar(20) — NOT NULL
- student_hp — varchar(20) — NOT NULL
- student_age — int(3) — NOT NULL
- student_gender — char(1) — NOT NULL
- Field (reg_user) — varchar(20) — NOT NULL
- Field2 (reg_dt) — datetime — NOT NULL
- Field (last_user) — varchar(20) — NOT NULL
- Field (last_dt) — datetime — NOT NULL
Untitled (project_team)
- Key (project_team_pk) — int — Primary key — NOT NULL
- Key (project_domain_pk) — int — Foreign key → Untitled.Key — NOT NULL
- Field (project_team_name) — varchar(20) — NOT NULL
Untitled (project_team_student)
- Key (idx) — int — Primary key — NOT NULL
- Key (project_team_pk) — int — Foreign key → Untitled.Key — NOT NULL
- student_pk — int — Foreign key → Student.student_pk — NOT NULL
- group_teacher_pk — int — Foreign key → Student.group_teacher_pk — NOT NULL
- Key (project_pk) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (project_domain)
- Key (project_domain_pk) — int — Primary key — NOT NULL
- Field (project_domain_name) — varchar(20) — NOT NULL
Untitled (grade_project)
- Key — Primary key — NOT NULL
- Key (project_team_pk) — int — Foreign key → Untitled.Key — NOT NULL
- Key (project_domain_pk) — int — Foreign key → Untitled.Key — NOT NULL
- Field (grade_project_exam)
Untitled (project)
- Key (project_pk) — int — Primary key — NOT NULL
- Field (project_name) — varchar(10)