AnimalHospital

Tables (8)

Account (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • vet_id (Key2) — Foreign key → Vet.id
  • name (Field) — varchar(100)
  • age (Field2) — bigint(10)
  • address (Field3) — varchar(100)
  • phone (Field4) — varchar(100)
  • role (Field5)

Pet (Untitled3)

  • id (PK) — Primary key — NOT NULL
  • client_id (FK) — Foreign key → Account.id — NOT NULL
  • name (Field) — varcjhar(100)
  • type (Field2) — varchar(100)

Record (Untitled8)

  • id (Key3) — Primary key — NOT NULL
  • vet_id (Key) — bigint — Foreign key → Vet.id — NOT NULL
  • pet_id (Key2) — Foreign key → Pet.client_id — NOT NULL
  • description (Field2) — varchar(500)
  • time (DateTime)

Register (Untitled4)

  • id (PK) — Primary key — NOT NULL
  • pet_id (FK) — Foreign key → Pet.client_id — NOT NULL
  • description (Field) — varchar(100)
  • treatment_at (Field2) — datetime
  • is_end (Field3) — byte

Reservation (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • vet_id (Key2) — bigint — Foreign key → Vet.id — NOT NULL
  • reservation_id (Key3) — bigint — Foreign key → Register.pet_id — NOT NULL
  • admin_id (Key4) — Foreign key → Account.id — NOT NULL
  • description (Field)
  • datetime

Speciality (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • type (Field) — varchar(100)
  • description (Field2) — varchar(200)

Vet

  • id (Key) — Primary key — NOT NULL
  • name (Field) — varchar(100)
  • age (Field2) — bigint(10)
  • salary (Field3) — bigint(20)
  • start_at (Field4) — datetime
  • description (Field5) — varchar(500)

VetSpeciality (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • vet_id (Key2) — bigint — Foreign key → Vet.id — NOT NULL
  • speciality_id (Key3) — bigint — Foreign key → Speciality.id — NOT NULL