test

Tables (3)

application (Untitled)

  • id (Key) — integar — Primary key — NOT NULL
  • member (Field) — Member
  • lecture (Field2) — Lecture
  • applicationStatus (Field3) — ApplicationStatus
  • memberid (Key2) — Long — Foreign key → member.id — NOT NULL
  • lectureId (Key3) — Long — Foreign key → lecture.id — NOT NULL

lecture (Untitled3)

  • id (Key) — integar — Primary key — NOT NULL
  • lectureName (Field) — string
  • professor (Field2) — string
  • day (Field3) — string
  • starttime (Field4) — LocalTime
  • endtime (Field5) — LocalTime
  • totalStudent (Field6) — int
  • takeStudent (Field7) — int
  • credit (Field8) — int
  • department (Field9) — string

member (Untitled2)

  • id (Key) — Long — Primary key — NOT NULL
  • email (Field) — string
  • password (Field2) — string
  • role (Field3) — Role
  • memberNumber (Field4) — int
  • studentName (Field5) — String
  • age (Field6) — int
  • department (Field7) — String
  • subDepartment (Field8) — String
  • totalCredit (Field9) — int
  • takeCredit (Field10) — int