myErdDiagram

Tables (6)

Algorithm (Untitled4)

  • Account (account) — VARCHAR(20) — Foreign key → Student.Account — NOT NULL
  • Grade (Field) — VARCHAR(20)
  • Acquisition_date (Field2) — DATE

Attendance (Untitled5)

  • Account (account) — VARCHAR(20) — Foreign key → Student.Account — NOT NULL
  • Date (Field) — DATE
  • Sign_in (Field2) — TIME
  • Sign_out (Field3) — TIME

Grade (Untitled3)

  • Account (account) — VARCHAR(20) — Foreign key → Student.Account — NOT NULL
  • 1_first_exam (first_exam) — VARCHAR(3)
  • 1_second_exam (second_exam) — VARCHAR(3)
  • 1_third_exam (third_exam) — VARCHAR(3)
  • 2_First_pjt (Field) — VARCHAR(3)
  • 2_secont_pjt (Field2) — VARCHAR(3)
  • 2_third_pjt (Field3) — VARCHAR(3)

Group_teacher (Untitled2)

  • ID (id) — VARCHAR(20) — Primary key — NOT NULL
  • Name (name) — VARCHAR(20)
  • Phone (phone) — VARCHAR(20)

Student (Untitled)

  • Account (account) — VARCHAR(20) — Primary key — NOT NULL
  • Name (name) — VARCHAR(100)
  • Phone (phone) — VARCHAR(20)
  • Age (age) — VARCHAR(5)
  • Gender (gender) — VARCHAR(20)
  • Curriculum (curriculum) — VARCHAR(20)
  • Region (region) — VARCHAR(20)
  • Group (group) — VARCHAR(20)
  • ID (id) — VARCHAR(20) — Foreign key → Group_teacher.ID — NOT NULL
  • Domain (Key) — VARCHAR(20) — Foreign key → Team_info.Domain — NOT NULL
  • Team_no (Key2) — INT — Foreign key → Team_info.Team_no — NOT NULL
  • Pjt (Key3) — VARCHAR(100) — Foreign key → Team_info.Pjt — NOT NULL

Team_info (Untitled6)

  • Domain (Key) — VARCHAR(20) — Primary key — NOT NULL
  • Team_no (Key2) — INT — Primary key — NOT NULL
  • Pjt (Key3) — VARCHAR(100) — Primary key — NOT NULL