User_erd
Tables (5)
Attendance (Untitled3)
- ID (Key) — int — Primary key — NOT NULL
- CHECK (Field) — tinyint
- SIGN_IN (Field2) — datetime
- SIGN_OUT (Field3) — datetime
- PK (Key2) — int — Foreign key → User.PK — NOT NULL
- STUDENT_GROUP (Key22) — int — Foreign key → User.STUDENT_GROUP — NOT NULL
Grade (Untitled4)
- exam_id (Key) — int — Primary key — NOT NULL
- PK (Key2) — int — Foreign key → User.PK — NOT NULL
- STUDENT_GROUP (Key22) — int — Foreign key → User.STUDENT_GROUP — NOT NULL
- SCORE (Field) — int
Group (Untitled2)
- STUDENT_GROUP (Key) — int — Primary key — NOT NULL
- GROUP_TEACHER_ID (Field) — varchar
- GROUP_TEACHER_NAME (Field2) — varchar
- GROUP_TEACHER_HP (Field3) — varchar
Project (Untitled5)
- ID (Key) — Primary key — NOT NULL
- TEAM_ID (Field2) — Primary key
- PK (Key2) — int — Foreign key → User.PK — NOT NULL
- STUDENT_GROUP (Key22) — int — Foreign key → User.STUDENT_GROUP — NOT NULL
- SCORE (Field) — int
User (Untitled)
- PK (Key) — int — Primary key — NOT NULL
- STUDENT_GROUP (Key2) — int — Foreign key → Group.STUDENT_GROUP — NOT NULL
- STUDENT_ACCOUNT (Field) — varchar
- STUDENT_NAME (Field2) — varchar
- STUDENT_HP (Field3) — varchar
- STUDENT_AGE (Field4) — varchar
- STUDENT_GENDER (Field5) — varchar
- STUDENT_CURRICULUM (Field6) — varchar
- STUDENT_REGION (Field7) — varchar
- ALGORITHM_GRADE (Field8) — varchar
- ALGORITHM_ACQUISITION_DATE (Field9) — datetime