ceos16th-vote

Tables (5)

Candidate (Untitled5)

  • candidatePk (Key) — BigInt — Primary key — NOT NULL
  • name (Field) — varchar(150)
  • part (Field2) — varchar(30)
  • count (Field6) — int
  • createdAt (Field3) — timestamp
  • updatedAt (Field4) — timestamp
  • deletedAt (Field5) — timestamp

CandidateVote (Untitled4)

  • Key — BigInt — Primary key — NOT NULL
  • createdAt (Field2) — timestamp
  • userPk (Key2) — BigInt — Foreign key → User.userPk — NOT NULL
  • candidatePk (Key3) — BigInt — Foreign key → Candidate.candidatePk — NOT NULL

Team (Untitled3)

  • teamPk (Key) — BigInt — Primary key — NOT NULL
  • name (Field) — varchar(150)
  • count (Field2) — int
  • createdAt (Field3) — timestamp
  • deltedAt (Field4) — timestamp
  • updatedAt (Field5) — timestamp

TeamVote (Untitled2)

  • Key — BigInt — Primary key — NOT NULL
  • createdAt (Field2) — timestamp
  • userPk (Key2) — BigInt — Foreign key → User.userPk — NOT NULL
  • teamPk (Key3) — BigInt — Foreign key → Team.teamPk — NOT NULL

User (Untitled)

  • userPk (Key) — BigInt — Primary key — NOT NULL
  • username (Field) — varchar(150)
  • email (Field2) — email
  • password (Field3) — varchar(128)
  • part (Field5) — varchar(30)
  • team (Field4) — varchar(10)
  • createdAt (Field6) — timestamp
  • updatedAt (Field7) — timestamp
  • deletedAt (Field8) — timestamp