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)