Data Dictionary

Version History

Version Policy

Version	Date	Description	Responsable
0.1	17/03/2017	Document creation and adaptation	Adailson Santos
0.2	20/03/2017	Added necessary tables	Adailson Santos
0.4	22/03/2017	Added necessary tables	Adailson Santos
0.5	24/03/2017	Added necessary modifications	Adailson Santos
0.6	25/03/2017	Done relationships	Adailson Santos
0.7	26/03/2017	Simplified tables	Adailson Santos
0.8	26/03/2017	Correted some colums and added colums in owner's table	Adailson Santos
0.9	09/05/2017	Updating tables	Antonio Carvalho

To compose the necessary understanding of the people involved in the development with the members involved in the business context, the team sought to make a detailed glossary, playing the role of a data dictionary, a document that records data about the data - that is, metadata.

For this document we have the field, description, type, format, size and constraints of each column of a specific table.

As it is contained in the tables below:

Owner

Table description

This table store the owner data:

Field	Description	Tipe	Format	Size	Restrictions
id	Owner identify number	Integer	-	-	Primary Key
cpf	Individual Registry in Brazil	Varchar	111.111.111-23	11	Required
ownerName	First name of owner	Varchar	-	50	Required
ownerLastName	Last name of owner	Varchar	-	50	Required
phoneNumber	Phone number of the owner	Varchar	(61)99999-9999	14	Required
zipCode	Zip code of the owner's place	Varchar	-	8	Unrequired
district	District of the owner's place	Varchar	-	20	Required
publicPlace	Public place of the owner	Varchar	-	50	Required
addressNumber	Number of the owner's address	Bigint	-	10	Required

Patient

Table description

This table store the patient data:

Field	Description	Tipe	Format	Size	Restrictions
idPatient	Patient identify number	Integer	-	-	Primary Key
cpf	Owner identify number	Integer	-	-	Foreign Key
namePatient	name of patient	Varchar	-	50	Required
specie	Species of the animal (if the animal is canine or feline)	Varchar	(Canine, Feline)	1	Required
breed	Animal’s breed	Varchar	-	20	Required
size	Animal's size	Varchar	(Big, Medium, Small)	1	Required
gender	Animal's gender	Varchar	(Female, Male)	1	Required
birthday	birthday’s animal	Date	DD/MM/AAAA	12	Unreqired
coat	Animal skin shape	Varchar	-	10	Required

BathGrooming

Table description

This table store the bath and grooming data:

Field	Description	Tipe	Format	Size	Restrictions
idBathGromming	Bath and grooming identity	Integer	-	-	Primary Key
idPatient	Patient identify number	Integer	-	-	Foreign Key
serviceBathGromming	Description of the service provided	Varchar	-	200	Required

ClinicalRecordAppointment

Table description

This table store the clinical record appointment data:

Field	Description	Type	Format	Size	Restrictions
id	Clinical record identify number	Integer	-	-	Primary Key
idPatient	Patient identify number	Integer	-	-	Foreing Key
veterinarian	Nome of veterinarian	Varchar	-	100	Required
anamnesis	Animal diasease history	Varchar	-	200	Required
clinicalHistory	Animal clinical signs	Varchar	-	200	Required
diagnosis	Animal diagnosis	Varchar	-	200	Required
patientTemperature	Animal body temperature	Float	11.11	-	Unrequired
capillaryFill	Capillary fill time	Integer	11	-	Unrequired
patientPulse	Pulse of the animal	Varchar	Strong and synchronous or weak and asynchronous	20	Unrequired
mucosasApparent	Animal mucous apparent	Varchar	Norma stained, Hypo stained or hyper stained	20	Unrequired
hydrationState	Status	Varchar	Hydrated , Slightly dehydrated or Dehydrated	20	Required
lymphnodes	Lymph nodes of the animal	Varchar	-	200	Unrequired
patientRespiratoryRate	Heart rate of animal in movements per minute	Integer	111	-	Unrequired
patientHeartRate	Heart rate of animal in beats per minute	Integer	111	-	Unrequired
patientWeight	Animal weight	Float	111.11	-	Unrequired
bloodPressure	Animal blood pressure	Integer	111/111	-	Unrequired
clinicalProcedure	Clinical suspicion	Varchar	Hospitalization, surgery and common consultation	50	Required
surgeryType	Name of the surgery type	Varchar	-	100	Unrequired
boxNumber	Box number	Integer	-	-	Unrequired
dateEntrance	Date of entrance	Date	dd/mm/yyyy	-	Unrequired
datePrevisionExit	Date of prevision exit	Date	dd/mm/yyyy	-	Unrequired
dateExit	Date of exit	Date	dd/mm/yyyy	-	Unrequired
observation	Observation description	Varchar		200	Unrequired
exam	Types of Exam	Varchar	Blood, stool, urine, scraped, x-ray, ultrasound, cerumen, biopsy	50	Unrequired
informations	Exam information	Varchar	-	200	Unrequired
preliminaryMedication	Medicine for patient	Varchar	-	100	Unrequired
medicationDosage	Dosage of the drug	Varchar	-	10	Unrequired
medicationFrequence	Frequency of the dosage	Varchar	-	20	Unrequired
diagnostic	diagnostic details	Varchar	-	200	Unrequired
prognostic	prognostic type	Varchar	Favorable, reserved or unfavorable	50	Unrequired
prognosticDetails	prognostic details	Varchar	-	200	Unrequired
homeMedicationName	Medicine for patient	Varchar	-	100	Unrequired
homeMedicationDosage	Dosage of the drug	Varchar	-	10	Unrequired
homeMedicationFrequency	Frequency of the dosage	Varchar	-	20	Unrequired
clinicMedicationName	Medicine for patient	Varchar	-	100	Unrequired
clinicMedicationDosage	Dosage of the drug	Varchar	-	10	Unrequired
clinicMedicationFrequency	Frequency of the dosage	Varchar	-	20	Unrequired

ClinicalRecordVaccination

Table description

This table store the clinical record vaccination data:

Field	Description	Type	Format	Size	Restrictions
id	Clinical record identify number	Integer	-	-	Primary Key
idPatient	Patient identify number	Integer	-	-	Foreing Key
veterinarian	Nome of veterinarian	Varchar	-	100	Required
anamnesis	Animal diasease history	Varchar	-	200	Required
clinicalHistory	Animal clinical signs	Varchar	-	200	Required
diagnosis	Animal diagnosis	Varchar	-	200	Required
patientTemperature	Animal body temperature	Float	11.11	-	Unrequired
capillaryFill	Capillary fill time	Integer	11	-	Unrequired
patientPulse	Pulse of the animal	Varchar	Strong and synchronous or weak and asynchronous	20	Unrequired
mucosasApparent	Animal mucous apparent	Varchar	Norma stained, Hypo stained or hyper stained	20	Unrequired
hydrationState	Status	Varchar	Hydrated , Slightly dehydrated or Dehydrated	20	Required
lymphnodes	Lymph nodes of the animal	Varchar	-	200	Unrequired
patientRespiratoryRate	Heart rate of animal in movements per minute	Integer	111	-	Unrequired
patientHeartRate	Heart rate of animal in beats per minute	Integer	111	-	Unrequired
patientWeight	Animal weight	Float	111.11	-	Unrequired
bloodPressure	Animal blood pressure	Integer	111/111	-	Unrequired
vaccinationApplicationDate	Date of vaccine application	Date	dd/mm/yyyy		Unrequired
vaccinationName	Vaccine name	Varchar	-	100	Unrequired
vaccinationReturnDate	Date of vaccine return	Date	dd/mm/yyyy	-	Unrequired
vaccinationLaboratory	Vaccine Laboratory	Varchar	-	50	Unrequired
vermifugationApplicationDate	Date of vermifuge application	Date	dd/mm/yyyy	-	Unrequired
vermifugeName	Vermifuge name	Varchar	-	100	Unrequired
vermifugeDosage	Vermifuge dosage	Varchar	-	20	Unrequired
vermifugationReturnData	Date of vermifuge return	Date	dd/mm/yyyy	-	Unrequired

CloseService

Table description

This table store the close service data:

Field	Description	Tipe	Format	Size	Restrictions
id	Close service identify number	Integer	-	-	Primary Key
idClinicalRecord	Patient identify number	Integer	-	-	Foreing Key
Closure_reason	Reason to close attendance	Integer	-	-	Required
item	-	Varchar	-	100	-
quantity	-	Integer	-	-	-
value	-	Float	-	-	-
subtotal	-	Float	-	-	-
total	-	Float	-	-	-
payment_status	Payment status for service	int	Payment, partial payment, late payment or unpaid	50	Required

User

Table description

This table store the user data:

Field	Description	Tipe	Format	Size	Restrictions
id	User identify number	Integer	-	-	Primary Key
userFullName	User full name	Integer	-	200	Required
userName	User name	Integer	-	20	Required
userPassword	User password	Varchar	-	8	Required