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