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