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