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