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