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