dae

Tables (4)

Pm (Untitled2)

  • num (Key) — long — Primary key — NOT NULL
  • createdAt (Field) — time
  • isPublic (Field2) — bool
  • isFinished (Field3) — bool
  • FinishedAt (Field4) — time
  • modifiedAt (Field5)

TeamMapping (Untitled3)

  • id (Key) — long — Primary key — NOT NULL
  • user_num (Key2) — long — Foreign key → User.num — NOT NULL
  • project_num (Key3) — long — Foreign key → Pm.num — NOT NULL

Todo (Untitled4)

  • num (Key) — long — Primary key — NOT NULL
  • project_num (Key2) — long — Foreign key → Pm.num — NOT NULL
  • isFinished (Field) — bool
  • Field2

User (Untitled)

  • num (Key) — long — Primary key — NOT NULL
  • id (Field) — varchar(255)
  • password (Field2) — varchar(255)
  • name (Field3) — varchar(255)
  • age (Field4) — int
  • email (Field5) — varchar(255)
  • major (Field6) — varchar(255)
  • info (Field7) — blob
  • Field8