day1
Tables (7)
GRADE
- STUDENT_ID (PK, FK) — int — Foreign key → STUDENT.STUDENT_ID — NOT NULL
- Field — varchar(3)
- Field2 — varchar(3)
- Field3 — varchar(3)
GROUP_TEACHER
- GROUP_TEACHER_ID (PK) — varchar(20) — Primary key — NOT NULL
- GROUP_TEACHER_NAME (Field) — varchar(20)
- GROUP_TEACHER_HP (Field2) — varchar(20)
STUDENT
- STUDENT_ID (PK) — int — Primary key — NOT NULL
- GROUP_TEACHER_ID (FK) — varchar(20) — Foreign key → GROUP_TEACHER.GROUP_TEACHER_ID — NOT NULL
- STUDENT_ACCOUNT (Field1) — varchar(20)
- STUDENT_NAME (Field2) — varchar(100)
- STUDENT_HP (Field3) — varchar(20)
- STUDENT_AGE (Field4) — varchar(5)
- STUDENT_GENDER (Field5) — varchar(20)
- STUDENT_CURRICULUM (Field6) — varchar(20)
- STUDENT_REGION (Field7) — varchar(20)
- STUDENT_GROUP (Field8) — varchar(20)
Untitled (PROJECT)
- Key (PK) — int — Primary key — NOT NULL
- Field — varchar(100)
- Field2 — varchar(3)
Untitled (PROJECT_TEAM)
- STUDENT_ID (PK, FK) — int — Foreign key → STUDENT.STUDENT_ID — NOT NULL
- Key (PK2, FK) — int — Foreign key → Untitled.Key — NOT NULL
Untitled2 (ALGORITHM)
- STUDENT_ID (PK, FK) — int — Foreign key → STUDENT.STUDENT_ID — NOT NULL
- Field — varchar(20)
- Field2 — datetime
Untitled2 (ATTENDANCE)
- Key (PK) — int — Primary key — NOT NULL
- STUDENT_ID (FK) — int — Foreign key → STUDENT.STUDENT_ID — NOT NULL
- Field — varchar(4)
- Field2 — tinyint(1)
- Field3 — datetime
- Field4 — datetime