homework01
Tables (4)
ProUser
- proUserno (Key) — Long — Primary key — NOT NULL
- ProUsername (Field) — String
- ProUsertelephone (Field2) — String
- Area (Field3) — FLOAT
- Class (Field4) — Int
- Team (Field5) — Int
Project
- ProjectNo (Key) — Long — Primary key — NOT NULL
- StudentNo (Field4) — Foreign key → Student.StudentNo
- proUserno (Key2) — Long — Foreign key → Student.proUserno — NOT NULL
- ProjectName (Field) — String
Student
- StudentNo (Field) — Long — Primary key
- proUserno (Key) — Long — Foreign key → ProUser.proUserno — NOT NULL
Training
- TrainingNo (Key) — Long — Primary key — NOT NULL
- Class (Field2) — Int