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