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