self-online_day1

Tables (4)

ATTENDANCE (CopyOfUntitled)

  • ACCOUNT — VARCHAR(20) — Foreign key → STUDENT.ACCOUNT — NOT NULL
  • GROUP — VARCHAR(20) — Foreign key → STUDENT.GROUP — NOT NULL
  • 1/1 — TINYINT(1)
  • 1/1_SIGN_IN — DATETIME
  • 1/1_SIGN_OUT — DATETIME — NOT NULL
  • 1/2 — TINYINT(1)
  • 1/2_SIGN_IN — DATETIME
  • 1/2_SIGN_OUT — DATETIME

GRADE (CopyOfUntitled2)

  • ACCOUNT — VARCHAR(20) — Foreign key → STUDENT.ACCOUNT — NOT NULL
  • GROUP — VARCHAR(20) — Foreign key → STUDENT.GROUP — NOT NULL
  • SECOND_EXAM — VARCHAR(3)
  • THIRD_EXAM — VARCHAR(3)
  • FIRST_EXAM — VARCHAR(3) — NOT NULL
  • ALGORITHM_GRADE — VARCHAR(20)
  • ALGORITHM_ACQUISITION_DATE — DATETIME

GROUP (Untitled2)

  • GROUP — VARCHAR(20) — Primary key — NOT NULL
  • TEACHER_NAME — VARCHAR(20)
  • TEACHER_HP — VARCHAR(20)
  • TEACHER_ID — VARCHAR(20) — NOT NULL

STUDENT (Untitled)

  • ACCOUNT — VARCHAR(20) — Primary key — NOT NULL
  • GROUP — VARCHAR(20) — Foreign key → GROUP.GROUP — NOT NULL
  • NAME — VARCHAR(100)
  • HP — VARCHAR(20)
  • AGE — VARCAHR(5) — NOT NULL
  • GENDER — VARCHAR(20)
  • CURRICULUM — VARCHAR(20)
  • REGION — VARCHAR(20)