University
Tables (5)
Category (Untitled2)
- id (Key) — bigInt — Primary key — NOT NULL
- name (Field) — varchar
ClassM (Untitled)
- id (Key) — bigInt — Primary key — NOT NULL
- name (Field) — varchar
- price (Field2) — int
- registerDate (Field3) — int
- info (Field4) — varchar
- open_close (Field5) — boolean
- id (Key2) — bigint — Foreign key → Lecturer.id — NOT NULL
- id (Key3) — bigInt — Foreign key → Category.id — NOT NULL
Enrollment (Untitled5)
- id (Key3) — bigInt — Primary key — NOT NULL
- Key — bigInt — Foreign key → Student.id — NOT NULL
- id (Key2) — bigInt — Foreign key → ClassM.id — NOT NULL
Lecturer (Untitled3)
- id (Key) — Primary key — NOT NULL
- Field
Student (Untitled4)
- id (Key) — bigInt — Primary key — NOT NULL
- email (Field) — varchar
- nickname (Field2) — varchar
- password (Field3) — varchar