pawwow

Tables (3)

Pet (PET)

  • id — BIGINT UNSIGNED — Primary key — NOT NULL
  • name — VARCHAR — NOT NULL
  • profileImage (profile_image) — VARCHAR — NOT NULL
  • briefDescription (brief_description) — VARCHAR — NOT NULL
  • description — VARCHAR — NOT NULL
  • type — VARCHAR — NOT NULL
  • createdAt (created_at) — TIMESTAMP — NOT NULL
  • lastModifiedAt (last_modified_at) — TIMESTAMP — NOT NULL

PetOutbox (PET_OUTBOX)

  • id — BIGINT UNSIGNED — Primary key — NOT NULL
  • petId (pet_id) — BIGINT UNSIGNED — NOT NULL
  • eventType (event_type) — VARCHAR — NOT NULL
  • payload — TEXT — NOT NULL
  • occurredAt (occurred_at) — TIMESTAMP — NOT NULL

PetPoll (PET_POLL)

  • id — BIGINT UNSIGNED — Primary key — NOT NULL
  • petId (pet_id) — BIGINT UNSIGNED — Foreign key → Pet.id — NOT NULL
  • voter — VARCHAR — NOT NULL
  • createdAt (created_at) — TIMESTAMP — NOT NULL