erp
Tables (5)
Untitled (student)
- Key (student_code) — INT — Primary key — NOT NULL
- Field (name)
- Field (phone)
- Field (age)
- Field (gender)
- Field (addr)
- Field (phone2)
- Field (consult)
- Field (consult_check)
- Field (status)
- Key (teach_id) — Foreign key → Untitled.Key — NOT NULL
Untitled (Attitudes)
- Key (attitude_id) — Primary key — NOT NULL
- Field (attitude_desc)
- Field (attitude_date)
- Key (student_code) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (teach_id) — Foreign key → Untitled.Key — NOT NULL
Untitled (Teachers)
- Key (teach_id) — Primary key — NOT NULL
- Field (name)
- Field (phone)
- Field (class)
Untitled (Reports)
- Key (report_id) — Primary key — NOT NULL
- Field (score)
- Field (subject)
- Key (student_code) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (teach_id) — Foreign key → Untitled.Key — NOT NULL
Untitled (Attendances)
- Key (attend_id) — Primary key — NOT NULL
- Field (check_in)
- Field (check_out)
- Field (status)
- Key (student_code) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (teach_id) — Foreign key → Untitled.Key — NOT NULL