TABLES
8
VIEWS
1
COLUMNS
26
Constraints
5
Anomalies
2
Routines
0
Database Properties
Database Type: PostgreSQL - 17.2 (Debian 17.2-1.pgdg120+1)
Catalog postgres
default administrative connection database
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| names | 0 | 0 | 1 | -1 | Table | Table to demonstrate anomalies, such as table with only one column, table without relations etc. |
| pets | 1 | 2 | 5 | -1 | Table | Stores pet information, linking each pet to its owner and pet type. |
| visits | 0 | 1 | 4 | -1 | Table | Records pet visits to the clinic, including the visit date and a description of the visit. |
| vets | 1 | 0 | 3 | -1 | Table | Stores information about veterinarians. |
| vet_specialties | 0 | 2 | 2 | -1 | Table | Link table representing the many-to-many relationship between veterinarians and their specialties. |
| owners | 1 | 0 | 6 | -1 | Table | Stores details of pet owners, including their names, address, and contact information. |
| pet_types | 1 | 0 | 2 | -1 | Table | Stores the different types of pets (e.g., dog, cat, etc.). |
| specialties | 1 | 0 | 2 | -1 | Table | Stores the various specialties that veterinarians can have. |
| namesuc | 0 | 0 | 1 | 0 | View | All the names in upper case |