2020-03-09
Tables (6)
attendance (Untitled6)
- id — int — Primary key — NOT NULL
- ATTENDANCE_DAY — varchar(20) — NOT NULL
exam (Untitled4)
- id — int — Primary key — NOT NULL
- EXAM_NAME — varchar(100) — NOT NULL
- EXAM_ORDER — int — NOT NULL
- EXAM_CONTENTS — varchar(500)
- EXAM_DATE — datetime — NOT NULL
student_attendance (Untitled7)
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → user.id — NOT NULL
- attendance_id — int — Foreign key → attendance.id — NOT NULL
- ATTENDANCE_SIGN_IN — datetime
- ATTENDANCE_SIGN_OUT — datetime
student_exam (Untitled5)
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → user.id — NOT NULL
- exam_id — int — Foreign key → exam.id — NOT NULL
- EXAM_GRADE — varchar(20) — NOT NULL
teacher (Untitled)
- id — int — Primary key — NOT NULL
- TEACHER_NAME — varchar(20) — NOT NULL
- TEACHER_HP — varchar(20) — NOT NULL
user
- id — int — Primary key — NOT NULL
- teacher_id — int — Foreign key → teacher.id — NOT NULL
- STUDENT_ACCOUNT — varchar(20) — NOT NULL
- STUDENT_NAME — varchar(100) — NOT NULL
- STUDENT_HP — varchar(20)
- STUDENT_AGE — varchar(5)
- STUDENT_GENDER — varchar(20)
- STUDENT_CURRICULUM — varchar(20)
- STUDENT_REGION — varchar(20)
- STUDENT_GROUP — varchar(20) — NOT NULL
- ALGORITHM_GRADE — varchar(20)
- ALGORITHM_ACQUISITION_DATE — datetime
- REG_USER — varchar(20)
- REG_DT — datetime
- LAST_USER — varchar(20)
- LAST_DT — datetime