Data dictionary
public.acta Table
Table that stores information from the minutes of a meeting; An act is a minute where the votes that the candidates obtained in that meeting are written.
Name Data type PK FK UQ Not null Default value Description
id numeric ✓ ✓

Unique identifier
id_dignidad numeric ✓

id_junta numeric ✓

seguridad integer

Minute security code to avoid falsification of a minute
estado integer

Status of a record in the process, in what phase of the process it is
usuarioescaneo integer

User code that scanned the vote record
fechaescaneo date

Date on which a record was scanned
usuariodigitacion integer

User code that entered the votes
fechadigitacion date

Date on which the votes of the candidates in the minutes were entered
usuariocontrol integer

User code that performed quality control of the votes of a minute
fechacotrol date

Date on which quality control was carried out on votes that do not match between intelligent recognition and entry
peticion integer

know if the minutes were taken by a user to enter votes or quality control, this is used to prevent a minute from being taken by several users at the same time
sufragantesicr integer

Number of voters of the act, this number was obtained in the intelligent recognition /IA
sufragantesdigitacion integer

Number of voters of the act, this number was obtained by typing
sufragantes smallint

Number of voters of the minutes, corresponds to the number of people who voted
Constraints
Name Type Column(s) References Expression Description
acta_pk PRIMARY KEY id

dignidad_fk FOREIGN KEY id_dignidad public.dignidad

junta_fk FOREIGN KEY id_junta public.junta

public.candidato Table
table that stores information about the privincies (highest level of the political division)
Name Data type PK FK UQ Not null Default value Description
id numeric ✓ ✓

Unique identifier
cedula smallint

DNI of candidate
nombre character varying(50) ✓

Name of a candidate
id_partido numeric ✓

Constraints
Name Type Column(s) References Expression Description
candidato_pk PRIMARY KEY id

partido_fk FOREIGN KEY id_partido public.partido

public.canton Table
table that stores information about the privincies (highest level, second level of the political division) Unique identifier
Name Data type PK FK UQ Not null Default value Description
id numeric ✓ ✓

Unique identifier
nombre character varying(50) ✓

name of canton
id_provincia integer ✓

id of provincia
Constraints
Name Type Column(s) References Expression Description
canton_pk PRIMARY KEY id

canton_provincia_fk FOREIGN KEY id_provincia public.provincia

public.dignidad Table
table that stores information about the privincies (highest level of the political division)
Name Data type PK FK UQ Not null Default value Description
id numeric ✓ ✓

Unique identifier
nombre character varying(50) ✓

Name of a dignity
ambio character varying(1)

Level of jurisdiction of dignity (national, province…etc)
estado smallint

Status of dignity
orden integer

Orden of dignity in the processing
Constraints
Name Type Column(s) References Expression Description
dignidad_pk PRIMARY KEY id

public.imagenacta Table
Table that stores the image of the sheets of a ballot report “acta de escrutinio”, also stores the meta data of the images.
Name Data type PK FK UQ Not null Default value Description
id_acta integer ✓

id of “junta! to which the image belongs
image oid

image of the “acta de escrutino” sheet
nombre character varying

Name of image
pagina smallint

Page number
hash character varying

image data hash
pathipfs character varying

Address of image in IPFS
fecha date

record creation date
Constraints
Name Type Column(s) References Expression Description
imageacta_junta_fk FOREIGN KEY id_acta public.junta

public.imagensegmento Table
Name Data type PK FK UQ Not null Default value Description
id_junta integer

Id junta
id_dignidad character varying

id_candidato character varying

imagen oid

image
nombre character varying

Image name
hash character varying

Image hash code
pathipfs character varying

Image path on the IPFS network
fecha date

Cecord creation date
public.junta Table
table that stores the information of the parishes (fourth level of the political division) Unique identifier
Name Data type PK FK UQ Not null Default value Description
id numeric ✓ ✓

Unique identifier
id_zona numeric ✓

junta integer

Number assigned to a meeting
sexo character varying(1)

Sex to which a junta belongs
electores integer

Number of voters assigned to a “junta”
estado integer

Status of a “junta” in the process
Constraints
Name Type Column(s) References Expression Description
junta_pk PRIMARY KEY id

zona_fk FOREIGN KEY id_zona public.zona

public.menu Table
Name Data type PK FK UQ Not null Default value Description
id integer

id_modulo integer ✓

nombre character varying

icono character varying

orden integer

estado boolean

Constraints
Name Type Column(s) References Expression Description
menu_modulo_fk FOREIGN KEY id_modulo public.modulo

public.modulo Table
Table that stores information about the modules of which the system is composed
Name Data type PK FK UQ Not null Default value Description
id integer ✓ ✓

Modulo id
nombre character varying

Name of module
codigo character varying

Module code
url character varying

Address to access the module
icono character varying

Image that identifies a module
estado character varying

Module status
fechacreacion date

Module creation date
fechamodificacion date

Module modification date
Constraints
Name Type Column(s) References Expression Description
modulo_unique UNIQUE id

public.parroquia Table
table that stores the information of the parishes (third level of the political division)
Name Data type PK FK UQ Not null Default value Description
id numeric ✓ ✓

Unique identifier
id_canton numeric ✓

nombre character varying(50) ✓

Name of parishes
Constraints
Name Type Column(s) References Expression Description
parroquia_pk PRIMARY KEY id

canton_fk FOREIGN KEY id_canton public.canton

public.partido Table
Table that stores information about political parties
Name Data type PK FK UQ Not null Default value Description
id numeric ✓ ✓

Unique identifier
nombre character varying(1000) ✓

Name of a political parties
siglas character varying(150)

Acronym or short name of a political party
lista character varying(50)

List number assigned to a political party, does not refer to the order but to the identity of a party
orden integer

Order assigned to a political party
imagen smallint

Image of political party image/logo
Constraints
Name Type Column(s) References Expression Description
partido_pk PRIMARY KEY id

public.provincia Table
Table that stores information about the privincies (highest level of the political division)
Name Data type PK FK UQ Not null Default value Description
id integer ✓ ✓

Unique identifier
nombre character varying(50) ✓

Name of provincia
Constraints
Name Type Column(s) References Expression Description
provincia_pk PRIMARY KEY id

public.rol Table
table with the role (group of users according to their responsibility profile)
Name Data type PK FK UQ Not null Default value Description
id integer ✓ ✓

Id
nombre character varying

Name of rol
estado integer

Status of rol
tipo character(1)

Type of role, depending on the place from which you want to access (desktop, web)
fechacreacion date

Creation date
fechamodificacion date

Modification date
id_modulo integer ✓

Module to which the role belongs
Constraints
Name Type Column(s) References Expression Description
rol_pk PRIMARY KEY id

rol_modulo_fk FOREIGN KEY id_modulo public.modulo

public.usuario Table
Table containing the information of the system users
Name Data type PK FK UQ Not null Default value Description
id integer ✓

Unique identifier of the user in the system
cedula character varying

dni of user
nombre character varying

Name of user
emial character varying

Email of user
estado character varying

Status of user
clave character varying

password (encrypt)
id_provincia integer ✓

Province to which the user belongs
id_rol integer ✓

User role, to know what system options they can access
ultimoacceso date

Date of last access to the system
Constraints
Name Type Column(s) References Expression Description
usuario_provincia_fk FOREIGN KEY id_provincia public.provincia

usuario_rol_fk FOREIGN KEY id_rol public.rol

usuario_unique UNIQUE id

public.votos Table
This table stores the votes that the candidates received in a “junta”
Name Data type PK FK UQ Not null Default value Description
id_acta integer

id_candidato integer ✓

votosicr integer

Number of votes that the candidate obtained through automatic recognition
votosdigitacion integer

Number of votes that the candidate obtained by manual typing
votoscontrol integer

Number of votes the candidate obtained in the quality control
votos integer

Number of votes the candidate obtained
Constraints
Name Type Column(s) References Expression Description
votos_candidato_fk FOREIGN KEY id_candidato public.candidato

public.zona Table
table that stores the information of the parishes (fourth level of the political division) Unique identifier
Name Data type PK FK UQ Not null Default value Description
id numeric ✓ ✓

Unique identifier
nombre character varying(50)

Unique identifier
id_parroquia numeric ✓

Constraints
Name Type Column(s) References Expression Description
zona_pk PRIMARY KEY id

parroquia_fk FOREIGN KEY id_parroquia public.parroquia

Observaciones y Contacto

Este documento puede ser mejorado con tus sugerencias. ¿Tienes comentarios o recomendaciones? Contáctanos aquí.

Generated at 2024-04-25
PostgreSQL Database
2024 – David Tacuri