Animal-Shelter
Tables (4)
Animals (animals)
- Primary_id (primary_id) — INT — Primary key — NOT NULL
- Animal_id (animal_id) — VARCHAR(255)
- Animal_category (animal_category) — ENUM
- Sex (sex) — ENUM
- Ad_start (ad_start) — DATE
- Ad_finish (ad_finish) — DATE
- IsAdopt (isAdopt) — TINYINT
- IsReservation (isReservation) — TINYINT
- Img (img) — VARCHAR(255)
- IsNeuter (isNeuter) — TINYINT
- Description (description) — VARCHAR(255)
- Location (location) — VARCHAR(255)
- UpdatedAt (updatedAt) — DATETIME(6)
- DeletedAt (deletedAt) — DATETIME(6)
- Primary_id (shelterPrimaryId) — VARCHAR(36) — Foreign key → Shelters.Primary_id — NOT NULL
Reservations (reservations)
- Primary_id (primary_id) — VARCHAR(36) — Primary key — NOT NULL
- Animal_id (animal_id) — VARCHAR(255)
- Name (name) — VARCHAR(255)
- Phone (phone) — VARCHAR(255)
- Password (password) — VARCHAR(255)
- Primary_id (shelterPrimaryId) — VARCHAR(36) — Foreign key → Shelters.Primary_id — NOT NULL
Shelters (shelters)
- Primary_id (primary_id) — VARCHAR(36) — Primary key — NOT NULL
- Primary_id2 (primary_id2) — VARCHAR(36) — Foreign key → Users.Primary_id — NOT NULL
- ID (id) — VARCHAR(255)
- Shelter_name (shelter_name) — VARCHAR(255)
- Shelter_number (shelter_number) — VARCHAR(255)
- Department_name (department_name) — VARCHAR(255)
- Department_number (department_number) — VARCHAR(255)
Users (users)
- Primary_id (primary_id) — VARCHAR(36) — Primary key — NOT NULL
- ID (id) — VARCHAR(255)
- Password (password) — VARCHAR(255)
- Shelter_name (shelter_name) — VARCHAR(255)
- Shelter_number (shelter_number) — VARCHAR(255)
- Department_name (department_name) — VARCHAR(255)
- Department_number (department_number) — VARCHAR(255)