modi
Tables (9)
CandidateDate
- id — BIGINT — Primary key — NOT NULL
- date — DATE — NOT NULL
- created_at — DATETIME
- gatheringId — BIGINT — Foreign key → Gathering.id — NOT NULL
CandidatePlace
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- created_at — DATETIME
- gatheringId — BIGINT — Foreign key → Gathering.id — NOT NULL
Gathering
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- status — VARCHAR(50) — NOT NULL
- confirmedDateId — BIGINT
- confirmedPlaceId — BIGINT
- hostToken — VARCHAR(255)
- participateToken — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
- hostId — BIGINT — Foreign key → User.id — NOT NULL
Settlement
- id — BIGINT — Primary key — NOT NULL
- totalExpense — INT — NOT NULL
- perPersonAmount — INT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- gatheringId — BIGINT — Foreign key → Gathering.id — NOT NULL
Transfer
- id — BIGINT — Primary key — NOT NULL
- fromName — VARCHAR(100) — NOT NULL
- toName — VARCHAR(100) — NOT NULL
- amount — INT — NOT NULL
- isPaid — BOOLEAN
- created_at — DATETIME
- settlementId — BIGINT — Foreign key → Settlement.id — NOT NULL
User
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100)
- avatar — VARCHAR(255)
- role — VARCHAR(50)
- isActive — BOOLEAN
- lastLoginAt — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
Vote
- id — BIGINT — Primary key — NOT NULL
- participantName — VARCHAR(100) — NOT NULL
- isConfirmed — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
- gatheringId — BIGINT — Foreign key → Gathering.id — NOT NULL
VoteDate
- id — BIGINT — Primary key — NOT NULL
- voteId — BIGINT — Foreign key → Vote.id — NOT NULL
- candidateDateId — BIGINT — Foreign key → CandidateDate.id — NOT NULL
VotePlace
- id — BIGINT — Primary key — NOT NULL
- voteId — BIGINT — Foreign key → Vote.id — NOT NULL
- candidatePlaceId — BIGINT — Foreign key → CandidatePlace.id — NOT NULL