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