Scribd
Upload
10 views2 pages

Patient and Doctor Data Dictionary

The document describes the tables and fields of a hospital database. It includes a patients table with fields such as first name, last name, date of birth, and address. It also describes a doctors table with fields such as first name, last name, and area. Finally, it details an admissions table with fields such as admission date, floor number, diagnosis, and treatment cost.

Translated by

ScribdTranslations
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
10 views2 pages

Patient and Doctor Data Dictionary

The document describes the tables and fields of a hospital database. It includes a patients table with fields such as first name, last name, date of birth, and address. It also describes a doctors table with fields such as first name, last name, and area. Finally, it details an admissions table with fields such as admission date, floor number, diagnosis, and treatment cost.

Translated by

ScribdTranslations
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Field name Type of field description Size

Code of Numeric Code of 6


identification identification of
patient
Name Texto Patient name 15
admitted to the hospital
Last name Text Surnames of the patient 25
admitted to the hospital
Fecha de Nacimiento Date Date of birth N/A
of the patient
admitted to the hospital
Address Text Permanent address: 40
street and neighborhood

Postal code Numeric Postal code 5


Phone number Numeric History number 12
of the patient
History number Numeric History number 6
Clinical patient's clinical
Data dictionary
Patient Table

Doctor's table

Field name Field type description Size


Code of Numeric Code of 6
identification identification of
responsible doctor
Name Text Name of the doctor 15
Last Name Text Last names of the doctor 25
Area Text Area in which 30
find
Professional registration number Numeric Membership number 10
from the doctor
Cargo Text Position that occupies in the 15
hospital
Income Table

Field name Field type description Size


Code of Numeric Code of 6
identification identification of
responsible doctor
History Code Numeric Code of 6
Clinical identification of
Clinical History
Date of Admission Date Date of Admission N/A
Patient
Floor Number Numeric Plant code 6
that is found the
patient
Bed Number Numeric Bed Number that 10
is located the
patient
Diagnostic Text Patient data 60
delivered by the
doctor
Cost of Numerical Treatment Monetary price of 10
service

You might also like