nomoney ERD ver0

Tables (4)

availability_vote

  • id (Key) — UUID — Primary key — NOT NULL
  • participant_id — CHAR(36) — NOT NULL
  • date_option_id — CHAR(36) — NOT NULL
  • is_available — BOOLEAN — NOT NULL
  • voted_at — DATETIME — NOT NULL

date_option

  • id (Key) — UUID — Primary key — NOT NULL
  • id — CHAR(36)
  • meeting_id — CHAR(36) — NOT NULL
  • date — DATE — NOT NULL
  • start_time — TIME
  • end_time — TIME
  • created_by — CHAR(36) — NOT NULL
  • created_at — DATETIME — NOT NULL

meeting

  • id (Key) — UUID — Primary key — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • access_token — VARCHAR(100) — NOT NULL
  • host_name — VARCHAR(50) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • closed_at — DATETIME

participant

  • id (Key) — UUID — Primary key — NOT NULL
  • meeting_id — CHAR(36) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • is_host — BOOLEAN — NOT NULL
  • joined_at — DATETIME — NOT NULL