upark
Data Dictionay

2025-10-13

Alphabetic Index

historial
Column name DataType PK NN UQ BIN UN ZF AI Default Comment
id INT ✔ ✔         ✔ Auto-incrementing numeric ID for the 'historial' table, used to store historical records of vehicle entries and exits.
numeroidentificacion VARCHAR(15)   ✔           Column to store the identification number of a user as part of a historical record of access to the UPB parking service. If the user is from UPB, this corresponds to their UPB-ID. If the user is registered as a visitor, it corresponds to their personal identification document.
nombreusuario VARCHAR(100)   ✔           Column for storing the full name of the user as part of a historical record of access to the UPB parking service. This field should contain a string representing the user's first and last name (e.g., 'Juan Camilo García Herrera'). In cases where multiple names are provided (e.g., middle name or surname), all components should be included in this field.
documentousuario VARCHAR(15)   ✔           Personal identification document of the user as part of a historical record of access to the UPB parking service as an individual.
placa VARCHAR(6)   ✔           Column for storing the license plate of a vehicle as part of a historical record of access to the UPB parking service. This serves as the unique vehicle identifier and should follow the 3-letter, 3-number format (e.g., AAA000).
entrada DATETIME   ✔           Column for recording the date and time of a vehicle's entry into the UPB parking service.
salida DATETIME               NULL Column for recording the date and time of a vehicle's exit from the UPB parking service.
usuarios
Column name DataType PK NN UQ BIN UN ZF AI Default Comment
numeroidentificacion VARCHAR(15) ✔ ✔           Column to store the identification number of a user. If the user is from UPB, this corresponds to their UPB-ID. If the user is registered as a visitor, it corresponds to their personal identification document.
nombre VARCHAR(100)   ✔           Column for storing the full name of the user. This field should contain a string representing the user's first and last name (e.g., 'Juan Camilo García Herrera'). In cases where multiple names are provided (e.g., middle name or surname), all components should be included in this field. Special characters such as accents or hyphens should be properly handled.
genero VARCHAR(6)   ✔           Column to store the gender of a user (Hombre(Male)/Mujer(Female)).
rol VARCHAR(30)   ✔           Column to store the role that a user has with respect to the UPB - ('Vigilante'(Guard), 'Empleado'(Employee), 'Estudiante'(Student), 'Visitante'(Visitor)).
documento VARCHAR(15)   ✔           Personal identification document of the user as a person.
usuariosactuales
Column name DataType PK NN UQ BIN UN ZF AI Default Comment
numeroidentificacion VARCHAR(15) ✔ ✔           Foreign Key referencing the 'numeroidentificacion' column of the 'usuarios' table: Column to store the identification number of a user currently using the parking services of UPB. If the user is from UPB, this corresponds to their UPB-ID. If the user is registered as a visitor, it corresponds to their personal identification document. This column, together with the 'placa' column, forms the composite Primary Key for the 'usuariosactuales' table.
nombreusuario VARCHAR(100)   ✔           Column for storing the full name of the user currently using the parking services of UPB. This field should contain a string representing the user's first and last name (e.g., 'Juan Camilo García Herrera'). In cases where multiple names are provided (e.g., middle name or surname), all components should be included in this field.
documentousuario VARCHAR(15)   ✔           Personal identification document of the user currently using the parking services of UPB as a person.
placa VARCHAR(6) ✔ ✔           Foreign Key referencing the 'placa' column of the 'vehiculos' table: Column for storing a vehicle's license plate (Unique Vehicle Identification) - 3-letter, 3-number format (AAA000). This column, together with the 'numeroidentificacion' column, forms the composite Primary Key for the 'usuariosactuales' table.
vehiculos
Column name DataType PK NN UQ BIN UN ZF AI Default Comment
marca VARCHAR(70)   ✔           Column for storing the brand or manufacturer of the vehicle. This field should contain a string representing the brand name (e.g., 'Toyota', 'Ford', 'BMW'). It is expected that the brand names are standardized and entered consistently. The use of full brand names is required, and abbreviations or acronyms should be avoided unless commonly recognized (e.g., 'BMW').
placa VARCHAR(6) ✔ ✔           Column for storing a vehicle's license plate (Unique Vehicle Identification) - 3-letter, 3-number format (AAA000).
color VARCHAR(70)   ✔           Column for storing the color of the vehicle. This field should contain a string representing the color (e.g., 'Rojo'(Red), 'Azul'(Blue), 'Negro'(Black)). It may also include color specifications such as 'Metálico'(Metallic).
modelo VARCHAR(70)   ✔           Column for storing the model of the vehicle. This field should contain a string representing the commercial model name or code designated by the manufacturer (e.g., 'Civic', 'Model S', 'Corolla'). It is recommended to use the official model name as provided by the brand, and maintain consistent formatting (e.g., avoiding abbreviations or internal codes unless standardized).
numeroidentificacion VARCHAR(15)   ✔           Foreign Key referencing the 'numeroidentificacion' column of the 'usuarios' table: Column to store the identification number of a user. If the user is from UPB, this corresponds to their UPB-ID. If the user is registered as a visitor, it corresponds to their personal identification document.