GBDS 5 Relational Databases

Introduction

This manual describes all tables, schemas and information of the GBDS relational databases. GBDS uses a relational database to store metadata about people, transactions, notification groups, configuration overrides and exceptions.

The document is divided into four sections that describe:

• The general tables ;

• The Unresolved Latents (UL) tables ;

• The Notification tables ;

• The GBDS configuration tables .

General tables

The general tables are tables that store vital information for GBDS operation, such as exceptions, information about people, information about transactions and others. These tables are described below.

gbds.people

Error in the Federal Revenue peopletable is intended to store the indexes of all people stored in the GBDS database and is described as follows:

Column	Type	Size	Value	Additional information
id	bigint	20	not null	Primary key; Private key of the relational database
pguid	varchar	255	not null	Personal UGUID stored in HBase
deleted	tinyint	1	null	Indicates if the candidate was deleted, so that they are not included when listing operations are performed

gbds.people_version

Error in the Federal Revenue people_versiontable is intended to store information about the latest changes in a person's record and is described as follows:

Column	Type	Size	Value	Additional information
version	int	11	not null	Primary key; Version index (incremental from the first change)
person_id	bigint	20	not null	Reference to the persongbds.people.id
_timestamp	datetime	6	null	date and time timestamp for the current version of a person
deleted	tinyint	1	null	Indicates if the candidate was deleted to be executed when performing candidate listing operations
active	tinyint	1	null	Defines whether a version of a people is eligible for master record transactions

gbds.organization

The table organization is responsible for storing information about organizations registered in GBDS

Column	Type	Size	Value	Additional Information
id	bigint	20	not null	Primary key; Uniquely identifies the organization
parent_id	bigint	20	null	Identifies the responsible organization, key;
name	varchar	255	not null	Name of the organization
description	varchar	1000	not null	Description

gbds.transactions

Error in the Federal Revenue transactionstable is intended to store information about the biometric data quality analysis of a transaction.

Column	Type	Size	Value	Additional Information
id	bigint	20	not null	Primary key; Private key of the relational database
tguid	varchar	255	not null	Reference to the transactiontransactions.tguid
pguid	varchar	255	null	UGUID of the person stored in HBase
active	tinyint	1	not null	Defines whether a version of a person is eligible for Master Registry transactions
priority	enum	n/a	null	enum('GOD_PRIORITY','HIGHEST_PRIORITY','HIGHER_PRIORITY','HIGH_PRIORITY','DEFAULT_PRIORITY','LOW_PRIORITY','LOWER_PRIORITY','LOWEST_PRIORITY')
created	datetime	6	null	creation date and time timestamp of the transaction
updated	datetime	6	null	date and time timestamp of the last modification of the transaction
quality_status	enum	n/a	null	Quality analysis status (such as OK, PENDING, APPROVED, and others)
enroll_status	enum	n/a	null	Enrollment status (such as ENQUEUED, PROCESSING, FAILED, and others)
search_status	enum	n/a	null	enum('ENQUEUED','PREPARED','PROCESSING','MATCH','NOT_MATCH','UNCERTAIN','MISMATCH','FAILED','PENDING','PERSON_NOT_FOUND','NONE','UL_NOT_FOUND','REFUSED','RESENT_ENROLL')
extraction_time	int	11	null	Elapsed time for model extractions
extraction_quality_time	int	11	null	Elapsed time for quality extractions
match_time	int	11	null	Matching time elapsed for this transaction
post_match_time	int	11	null	Elapsed time after matching for this transaction
total_time	int	11	null	Total operation minus queue waiting time
transaction_type	enum	n/a	null	Type of transaction. enum('ENROLL','UPDATE','VERIFY','IDENTIFY')
latent	tinyint	1	null	Flags whether the transaction is a latent search
ul	tinyint	1	null	Flags whether the transaction is a UL search
num_fingers	int	11	null	The number of fingerprints in the transaction
num_faces	int	11	null	The number of face images in the transaction (0 or 1)
finger_quality_extracted	tinyint	1	null	False if fingerprints can be extracted
face_quality_extracted	tinyint	1	null	False if the face can be extracted in the background. True if it has already been extracted.
ginger_extractor_type	enum	n/a	null	Type of ginger extractor used in the transaction. Enum: GRIAULE_FAST, GRIAULE_BASIC, GRIAULE_2020, GRIAULE_2024, GRIAULE_2018.
finger_global_quality	int	11	null	Fingerprint global quality score
global_quality	int	11	null	Profile global quality score
quality_extraction_api_id	varchar	255	null	API ID that will perform or performed the quality extraction
quality_extraction_msg	varchar	512	null	Message related to quality extraction
api_id	varchar	255	null	The ID of the API instance that received the transaction
gbds_version	varchar	255	null	Version of GBDS that processed the transaction

gbds.transaction_fields

Error in the Federal Revenue transaction_fieldstable aims to store information about quality information and link it to the non-biometric information of the fieldstable.

Column	Type	Size	Value	Additional information
id	bigint	20	not null	Primary key; Private key of the relational database
fkey	varchar	255	null	Field key that describes the information contained (for example, whether it is a blood type, mother's name, date of birth, document, etc.) Reference tofields.fkey
type	varchar	255	null	Type of information (search or label) Reference tofields.type
fvalue	varchar	255	null	Actual value of the field (for example, the document number) Reference tofields.fvalue
transaction_id	bigint	20	not null	Transaction Id. Reference totransaction.id

gbds.transaction_fingerprint_quality

Column	Type	Size	Value
transaction_id	bigint	20	not null
idx	int	11	not null
image_quality	int	11	null
template_quality	int	11	null
minutiae_count	int	11	null
blank	varchar	100	null
contrast	varchar	100	null
fingerArea	varchar	100	null
fingerCenterX	varchar	100	null
fingerCenterY	varchar	100	null
fingerExtentX	varchar	100	null
fingerExtentY	varchar	100	null
hasjoint	varchar	100	null
__index	varchar	100	null
marginBiteEast	varchar	100	null
marginBiteNorth	varchar	100	null
marginBiteSouth	varchar	100	null
marginBiteWest	varchar	100	null
nfiq	varchar	100	null
orientation	varchar	100	null
sizeX	varchar	100	null
sizeY	varchar	100	null

gbds.transaction_face_quality

Column	Type	Size	Value
transaction_id	bigint	20	not null
idx	int	11	not null
image_quality	int	11	null
template_quality	int	11	null
autoBrightness	varchar	100	null
bgBelowPictureQuality	varchar	100	null
bgBlueStandardDeviation	varchar	100	null
bgDarknessQuality	varchar	100	null
bgGreenStandardDeviation	varchar	100	null
bgRedStandardDeviation	varchar	100	null
bgUniformityQuality	varchar	100	null
blurCompliance	varchar	100	null
busyBackground	varchar	100	null
busyBackgroundInCropped	varchar	100	null
cropContainmentError	varchar	100	null
eyesLookDown	varchar	100	null
eyesLookLeft	varchar	100	null
eyesLookRight	varchar	100	null
eyesLookUp	varchar	100	null
eyesObstruction	varchar	100	null
eyesTooClosed	varchar	100	null
eyesTooOpen	varchar	100	null
faceDown	varchar	100	null
faceLeft	varchar	100	null
faceObstruction	varchar	100	null
faceOrientationPitchCompliance	varchar	100	null
faceOrientationRollAngle	varchar	100	null
faceOrientationYawCompliance	varchar	100	null
faceRight	varchar	100	null
faceUp	varchar	100	null
glasses	varchar	100	null
grayscaleSpan	varchar	100	null
hat	varchar	100	null
heavyGlasses	varchar	100	null
icaoCompliance	varchar	100	null
leftEyeX	varchar	100	null
leftEyeY	varchar	100	null
mouthObstruction	varchar	100	null
mouthOpen	varchar	100	null
obstruction	varchar	100	null
openMouth	varchar	100	null
pictureHeight	varchar	100	null
pictureWidth	varchar	100	null
pixelated	varchar	100	null
redEye	varchar	100	null
result	varchar	100	null
rightEyeX	varchar	100	null
rightEyeY	varchar	100	null
saturated	varchar	100	null
saturationGrayscaleDistribGrade	varchar	100	null
saturationNumGrayTones	varchar	100	null
saturationOverExposure	varchar	100	null
shadows	varchar	100	null
skinColorCompliance	varchar	100	null
smile	varchar	100	null
smilingMouth	varchar	100	null
spoof	varchar	100	null
spoofGrade	varchar	100	null
tiltAngle	varchar	100	null
tooDark	varchar	100	null
unnaturalSkinColor	varchar	100	null
visibleTeeth	varchar	100	null
wrongFacePose	varchar	100	null
wrongShoulderPoseLeft	varchar	100	null
wrongShoulderPoseRight	varchar	100	null

gbds.fields

The table fields intended to store a person's non-biometric information, being linked to the transactiontables people_version. It is described as follows:

Column	Type	Size	Value	Additional Information
id	bigint	20	not null	Primary key; Private key of the relational database
fkey	varchar	255	null	Field key that describes the information contained (for example, whether it is a blood type, mother's name, date of birth, document, etc.)
field_type	varchar	255	null	Type of information (search or label)
fvalue	varchar	255	null	Actual value of the field (for example, the document number)
person_id	bigint	20	not null	Reference to the personperson.id
person_version	int	11	not null	Reference to the personpeople_version.version

gbds.exceptions

The table exceptionsintended to store information about any biometric exception and its handling. It is described as follows:

Column	Type	Size	Value	Additional Information
id	bigint	20	not null	Primary key; Private key of the relational database
aguid	varchar	255	not null	Stored exception HBase UGUID
comments	varchar	255	null	Any comments provided when handling the exception
_timestamp	datetime	6	null	date and time timestamp for the creation of the exception
exception_status	enum	n/a	not null	enum ('ANALYSIS', 'DIFFERENT_FINGERS', 'SAME_FINGERS', 'INCORRECT_ENROLL', 'RECOLLECT', 'MERGE_TRANSACTIONS', 'APPROVE', 'REJECT', 'ERROR', 'REFUSED')
target	enum	n/a	not null	enum('BIOMETRIC','BIOMETRIC_INCONCLUSIVE','BIOMETRIC_MISMATCH','BIOGRAPHIC'); Default: BIOMETRIC
priority	tinyint	1	not null	References exception priority, with default value 0
user	varchar	255	null	Identification of the user responsible for handling the exception
transaction_id_50	bigint	20	not null	Foreign key: Reference to the transactiontransactions.id
reference_person_id	bigint	20	not null	Foreign key: Reference to the reference personpeople.id
trusted_master_record	tinyint	1	null	Flag for use of transaction data in future analyses
reference_indexes	varchar	1000	null
exception_group_id	int	11	not null	ID of the exception group it belongs to
fusion_score	int	11	not null	Stores the score evaluated in the fusion
fusion_decision	enum	n/a	null	Stores the decision made by the fusion rules; enum('HIT','NO_HIT','UNCERTAIN','UNCERTAIN_EXPERT','MISMATCH','ERROR')

gbds.exception_decision

The table exception_decisionintended to store information about decisions regarding an exception. It is described as follows:

Column	Type	Size	Value	Additional Information
candidate_id	bigint	20	not null	Identifies the exception candidate; Forms primary key with user
user	varchar	100	not null	User responsible for handling the exception
locked_timestamp	datetime	6	not null	Date the exception was allocated
decision_timestamp	datetime	6	not null	Date the decision was generated
decision	enum	n/a	not null	Decision made for the exception enum('HIT','NO_HIT','UNCERTAIN','UNCERTAIN_EXPERT','ERROR')

gbds.exception_candidates

The table exception_candidatesintended to store information about candidates for a biometric exception. It is described as follows:

Column	Type	Size	Value	Additional Information
id	bigint	20	not null	Primary key; Private key of the relational database
exception_id	bigint	20	not null	Exception ID
reference_transaction_id	bigint	20	null	Reference transaction ID
query_index	int	11	not null	Index of the incoming biometric
reference_index	int	11	not null	Index of the reference biometric
query_quality	int	11	null	Quality of the incoming biometric
reference_quality	int	255	null	Quality of the reference biometric
score	int	20	null	Corresponding matching score
locked_user	varchar	20	null	User allocated to handle the exception
locked_timestamp	datetime	20	null	Date the exception was allocated
locked_timeout	datetime	11	null	Date the exception will be deallocated due to inactivity
decision	enum	n/a	null	enum(HIT, NO_HIT, UNCERTAIN, UNCERTAIN_EXPERT, ERROR)
minutiae	mediumblob	1	n/a

gbds.exception_group

The table exception_groupintended to store information about candidates for a biometric exception. It is described as follows:

Column	Type	Size	Value	Additional Information
id	bigint	20	not null	Primary key; Uniquely identifies the exception group
gguid	varchar	100	not null	UGUID of the exception group stored in HBase
tguid	varchar	100	not null	UGUID of the transaction stored in HBase
target	enum	n/a	not null	Type of exception to which the group refers. enum('BIOMETRIC','BIOMETRIC_INCONCLUSIVE','BIOMETRIC_MISMATCH','BIOGRAPHIC')
decision	enum	n/a	null	Decision made for handling the exception enum('APPROVE','REJECT','KEEP')
status	enum	n/a	not null	Status in which the exception handling process is enum('ANALYSIS','PENDING','READY','PROCESSING','DONE','REFUSED','ERROR')
priority	tinyint	1	not null	References exception priority, with default value 0
created	datetime	6	not null	Group creation timestamp
updated	timestamp	n/a	not null	Creation timestamp
user	varchar	100	null	User who handled the group
message	varchar	4000	null	Message left after handling
comments	varchar	4000	null	Comments to be left in case of lights out
locked_user	varchar	100	null	User allocated to handle the group
locked_timestamp	datetime	6	null	Date the exception group was allocated
locked_timeout	datetime	6	null	Date the allocation will expire if not handled
decision_parameters	varchar	5000	null	Decision parameters used (id, values and labels)
new_tguid	varchar	100	null
refused_status	enum	n/a	null	enum('CREATED','REMOVED','READY_TO_RESEND','SENDING','SENT','ERROR')
refused_new_tguid	varchar	100	null	New TGUID generated in case of REFUSED
lights_out_criteria	varchar	5000	null	Indicates what was considered in Lights Out EX: {"matchedBiographics":["name","date of birth","parentage"]}
lights_out_status	enum	n/a	null	enum ('READY','ANALYSING','KEEP','AUTO_TREAT','ERROR')

gbds.exception_group_organizations

The exception_group_organizations table is intended to store information about organizations related to an exception group.

Column	Type	Size	Value	Additional Information
exception_group_id	bigint	20	not null	ID of the exception group; Forms primary key with exception_id
exception_id	bigint	20	not null	ID of the exception to which the organization refers; Forms primary key with exception_group_id;
organization	varchar	100	not null	Name of the organization
origin	enum	n/a	not null	References the type of origin of the organization within the exception DEFAULT 'BOTH' enum('ENTRANT','REFERENCE','BOTH')

gbds.exception_group_refused

The table exception_group_refused intended to store information about refused exception groups and the groups responsible for the refusal.

Column	Type	Size	Value	Additional Information
exception_group_id	bigint	20	not nuIl	ID of the reference exception group
refused_exception_group_id	bigint	20	not null	ID of the refused exception group

gbds.key_format

The gbds.key_format table is intended to store keys and formats for key validation.

Column	Type	Size	Value	Additional Information
key_id	varchar	255	not null	Primary key; Defines the key ID
format_type	enum	6	not null	Default ALPHANUMERIC enum('TITULO','CPF','ALPHANUMERIC','NUMERIC','ALPHABETIC','REGEX')
regex	varchar	20	null
min_length	int	20	null	Defines the minimum key length
max_length	int	Up to 4Gb	null	Defines the maximum key length

gbds.operation_log

The gbds.operation_log table is used to store operation logs.

Column	Type	Size	Value	Additional Information
id	bigint	20	not null	Internal identification ID
guid	varchar	100	null	Universal unique identifier
user	varchar	100	null	User responsible for the action
log_timestamp	datetime	-	not null	Log creation date
log_type	enum	n/a	not null	enum('EXCEPTION','EXCEPTION_BIOMETRIC','EXCEPTION_GROUP','TRANSACTION)
operation	enum	n/a	not null	enum('UNKNOWN','CONNECT','DISCONNECT','AUTHENTICATE','ENROLL','EXTERNAL_AUTHENTICATE','BATCH_ENROLL','REGISTER_SEARCH','SEARCH','DELETE','GET_RESULT','CLOSE_SESSION','FILTER','COUNT_ANOMALIES','FIND_ANOMALIES','GET_ANOMALY','ASSIGN_ANOMALY','UNASSIGN_ANOMALY','TRUST_ENROLL','GET_TRANSACTION','CHANGE_PRIORITY','ADD_TO_REFERENCE','REMOVE_FROM_REFERENCE','REMOVE_KEYS','GET_PEOPLE_TRANSACTIONS','ANOMALY_ENROLL','GET_EXCEPTION_RESULT','QUALITY_ANALYSIS','REGISTER_ENROLL','STOP_SERVICE','REGISTER_UL_BIOMETRIC','REMOVE_UL_BIOMETRIC','UPDATE_PERSON_BIOMETRIC','DISABLE_PERSON_TRANSACTION','CREATE_EXCEPTION','CREATE_EXCEPTION_GROUP','PRIORITY_EXCEPTION','PRIORITY_EXCEPTION_GROUP','TREAT_EXCEPTION','TREAT_EXCEPTION_BIOMETRIC','TREAT_EXCEPTION_GROUP','CHANGE_REFUSED_STATUS','RESEND_REFUSED','LIGHTS_OUT')
status	enum	n/a	null	enum('ANALYSIS','READY','PROCESSING','DONE','REFUSED','PENDING','ERROR','ENQUEUED','OK','NOT_FINAL','BIOMETRIC','BIOMETRIC_INCONCLUSIVE','BIOMETRIC_MISMATCH','BIOGRAPHIC','APPROVE','REJECT','LIGHTS_OUT')
bio_index	int	11	null	Biometric index
decision	enum	n/a	null	enum('UNCERTAIN','UNCERTAIN_EXPERT','NO_HIT','HIT','MISMATCH','ERROR','APPROVE','REJECT','KEEP','CREATED','REMOVED','READY_TO_RESEND')
message	varchar	1000	null	Description of the operation to which the operation refers
tguid	varchar	100	null	Unique identifier of the transaction
pguid	varchar	100	null	Unique identifier of the profile to which the operation refers
kept_tguids	varchar	1000	null	TGUIDs to be kept by the Lights Out KEEP operation

gbds.apis

The apisis used by GBDS to manage multiple active APIs at the same time.

Column	Type	Size	Value	Additional Information
api_id	varchar	255	not null	Unique API instance ID
hostname	varchar	255	not null	Host name of the node where the API is running
port	int	11	not null	Port where the API is running
type	varchar	255	null	Type of API instance (LEADER, RUNNER or null)

On API startup, each API will look for itself in this table. If not found by host name/IP and port, it inserts itself into the table with a GUID as api-id and null type , which means it is not ready for quality extraction. Changes applied directly to this table will be scanned every 15 minutes.

Unresolved Latent (UL) tables

The Unresolved Latents tables are used to store information about UL data and candidates. The tables are described below.

gbds.ul

The table ulwas designed to store all GBDS ULs and is described as follows:

Column	Type	Size	Value	Additional Information
uguid	varchar	255	not null	Primary key; UGUID stored in HBase
ul_status	varchar	255	not null	UNSOLVEDor SOLVED; HBase replicates this status
creation_time	timestamp	4	not null	current_timestampby default
person_pguid	varchar	255	null	PGUID of the corresponding person whenSOLVED
person_tguid	varchar	255	null	TGUID of the corresponding person whenSOLVED
fragment_id	varchar	255	null	Original fragment ID for the fragment that generated the UL
fragment_case_id	varchar	255	null	Original case ID for the fragment that generated the UL
fragment_index	int	11	null	Fragment index for the UL. By default, the index is set to -1(unknown index, any index)
analysis_user	varchar	255	null	User responsible for the UL analysis
analysis_timestamp	timestamp	4	null	Datetime timestamp of the analysis
group_guid	varchar	255	not null	Grouping GUID (to list linked ULs)

gbds.ul_candidates

The table ul_candidates was designed to store the candidates of each UL that GBDS keeps after any REVERSE LATENT MATCH performed on enrollments that generated a match with a UL, and is described as follows:

Column	Type	Size	Value	Additional Information
ul_uguid	varchar	255	not null	Primary key; UL UGUID
person_pguid	varchar	255	not null	Primary key; candidate PGUID
person_tguid	varchar	255	not null	Primary key; candidate TGUID
person_index	int	11	not null	Primary key; candidate index finger
score	int	11	not null	Corresponding matching score for the candidate
deleted	tinyint	1	not null	0by default, indicates whether the candidate was excluded to be omitted when performing candidate listing operations
minutiae	longblob	Up to 4Gb	null	JSON serialization containing the corresponding minutiae. It is a list with the following structure: - queryIndex, int - referenceIndex,int

Notification tables

Notification tables are used to store data for auditing purposes, such as emails, people to be notified and groups.

gbds.notifications

The table gbds.notifications was designed to store information related to GBDS operation notifications

Column	Type	Size	Value	Additional Information
id	bigint	20	not null	Internal auto-increment index; Primary key;
nguid	varchar	40	not null	Unique identifier of the notification
tguid	varchar	40	not null	Unique identifier of the transaction responsible for the notification
created	datetime	6	not null	Timestamp of the notification creation date
operation	enum	n/a	null	enum('UNKNOWN','CONNECT','DISCONNECT','AUTHENTICATE','ENROLL','EXTERNAL_AUTHENTICATE','BATCH_ENROLL','REGISTER_SEARCH','SEARCH','DELETE','GET_RESULT','CLOSE_SESSION','FILTER','COUNT_ANOMALIES','FIND_ANOMALIES','GET_ANOMALY','ASSIGN_ANOMALY','UNASSIGN_ANOMALY','TRUST_ENROLL','GET_TRANSACTION','CHANGE_PRIORITY','ADD_TO_REFERENCE','REMOVE_FROM_REFERENCE','REMOVE_KEYS','GET_PEOPLE_TRANSACTIONS','ANOMALY_ENROLL','GET_EXCEPTION_RESULT','QUALITY_ANALYSIS','REGISTER_ENROLL','STOP_SERVICE','REGISTER_UL_BIOMETRIC','REMOVE_UL_BIOMETRIC','UPDATE_PERSON_BIOMETRIC','DISABLE_PERSON_TRANSACTION','CREATE_EXCEPTION','CREATE_EXCEPTION_GROUP','PRIORITY_EXCEPTION','PRIORITY_EXCEPTION_GROUP','TREAT_EXCEPTION','TREAT_EXCEPTION_BIOMETRIC','TREAT_EXCEPTION_GROUP','CHANGE_REFUSED_STATUS','RESEND_REFUSED','LIGHTS_OUT')
status	varchar	255	null	Status of the operation described in operation
sender	varchar	255	null	Module responsible for the notification
uguid	varchar	40	null	User identifier
pguid	varchar	40	null	PGUID to which the operation refers
new_tguid	varchar	40	null	New TGUID generated, for example, when generating an enroll
enroll_pguid	varchar	40	null	-
treatment	varchar	100	null	Treatment in the case of Lights Out analysis
_update	tinyint	1	null	Update flag
trusted	tinyint	1	null	Trusted enroll/update flag
origin	enum	n/a	null	enum('API','GBDS')
additional_data	mediumblob	-	null	Additional relevant data (GGUID, comments etc)
external_ids	mediumblob	-	null	External IDs and their values; {"name":"protocol", "key":"000000000"}
related_external_ids	mediumblob	-	null	Related external IDs
kept_tguids	mediumblob	-	null	TGUIDs to be kept in case of Lights Out

gbds.notify_user

The table notify_user was designed to store the authenticated user data for gbds.

Column	Type	Size	Value	Additional Information
id	bigint	20	not null	Primary key; unique user ID.
username	varchar	255	not null	authenticated gbds username

gbds.notify_group

The table notify_groupwas designed to store information about notification groups.

Column	Type	Size	Value	Additional Information
id	bigint	20	not null	Primary key;
name	varchar	255	not null	Group name
enabled	tinyint	1	not null	Defines whether the group will be active or not

gbds.notify_group_email

The table notify_group_email was designed to store the emails of a given group.

Column	Type	Size	Value	Additional Information
notify_group_id	bigint	20	not null	Primary key; Group ID.
email	varchar	255	not null	Primary key; Email that belongs to the group

gbds.notify_user_group

The table notify_user_group was designed to store information about which group a given user belongs to.

Column	Type	Size	Value	Additional Information
notify_user_id	bigint	20	not null	Primary key; Reference to the usernotify_user.id
notify_group_id	bigint	20	not null	Primary key; Reference to the groupnotify_group_email.notify_group.id

gbds.people_transparency

The table people_transparency was designed to store information about a given person and which actions are taken when that person is searched.

Column	Type	Size	Value	Additional Information
id	bigint	20	not null	Primary key;
pguid	varchar	255	not null	Reference to the personpeople.pguid
enabled	tinyint	1	not null	Reference to the personpeople.pguid
action	varchar	255	null	Action to be taken

gbds.people_transparency_group

The table people_transparency_group was designed to store information about the groups to which a person belongs.

Column	Type	Size	Value	Additional Information
people_transparency_id	bigint	20	not null	Primary key; Reference to people_transparency'speople_transparency.id
notify_group_id	bigint	20	not null	Primary key; Reference to the groupnotify_group_email.notify_group.id

GBDS settings tables (gbds.settings)

GBDS uses a relational database to store some API and GBDS settings. The settings table is a special table designed to control certain GBDS and GBDS API settings. These settings are stored in the gbds.settingstable. The table may contain settings present in the GBDS API, in GBDS or in both, following the schema below:

Type	Type	Size	Value	Additional Information
skey	varchar	255	not null	Primary key. Parameter key name.
stype	varchar	50	not null	Location from which the parameter comes. API or GBDS
svalue	varchar	4096	null	Parameter value
description	varchar	4096	null	Parameter description
stimestamp	datetime	6	not null	Timestamp
host	varchar	1024	null	Hostname of a node

All settings found in the table will be written to the respective file, gbdsapi.propertiesboth for the GBDS API and application.conffor GBDS, every 15 minutes. In addition, all settings updated in memory, both in the API and in GBDS, will be propagated.

The parameter value set in the gbds.settingstable will be propagated to ALL nodes.

This feature is controlled by a configuration parameter in the table, gbds.rdbSystemConfiguration.enabled. This parameter will allow overriding GBDS and API configuration values. Setting the parameter value to BOTHwill cause GBDS and API configurations to be overridden.

gbds.settings / File configuration key	Type
gbscluster.min.quality	API
gbds.enroll.fingerprints.min-nr-template	API
gbds.enroll.face.min-nr-template	API
gbds.enroll.iris.min-nr-template	API
gbds.enroll.palmprint.min-nr-template	API
gbds.enroll.newborn-palmprint.min-nr-template	API
gbscluster.enroll.fingerprints.verify.matchthreshold	API
gbscluster.update.min.quality	API
gbds.transparency.search.identify.request.notify.enabled	API
gbds.transparency.search.identify.result.actions.enabled	API
gbds.api.logLevel	API
gbds.extraction.service	API
gbds.extraction.service.face.count	API
gbds.extraction.service.ginger.count	API
gbds.extraction.service.girl.count	API
gbds.extraction.service.hostname	API
gbds.extraction.service.initialPort	API
gbds.extraction.service.logLevel	API
gbds.extraction.service.maxTries	API
gbds.extraction.service.linkLibSegfault	API
gbds.extraction.quality.service	API
gbds.extraction.quality.fillTransactionQualityPropertiesTable	API
gbds.faces.extraction.quality.api	API
gbds.faces.extraction.quality.background	API
gbds.fingerprints.extraction.quality.api	API
gbds.fingerprints.extraction.quality.background	API
gbds.extraction.quality.service.finger.count	API
gbds.extraction.quality.service.face.count	API
gbds.extraction.quality.service.initialPort	API
gbds.extraction.quality.service.logLevel	API
gbds.extraction.quality.service.timeout	API
gbds.extraction.quality.service.hostname	API
gbds.extraction.quality.service.maxTries	API
gbds.extraction.quality.service.linkLibSegfault	API
gbds.extraction.quality.service.rows-on-select	API
gbds.extraction.quality.service.submitted-queue-factor	API
gbds.enroll.face.min.quality	API
gbds.update.face.min.quality	API
gbds.monitor.url	API
gbds.template.face.multiplicity	API
gbds.biographicBase.enabled	API
gbds.biographicBase.endpoints	API
gbds.biographicBase.get.timeout.ms	API
gbds.biographicBase.list.timeout.ms	API
gbds.biographicBase.logLevel	API
gbds.biographicBase.clientID	API
gbds.biographicBase.clientSecret	API
gbds.biographicBase.lookAllServers	API
gbscluster.fingerprints.extraction.enroll.type	API
gbscluster.fingerprints.extraction.verify.type	API
gbds.update.exception.reextract	API
gbds.update.exception.reextract.save	API
gbds.biographicBase.autoUpdate	API
gbds.biographicBase.sendPguidAsKey	API
gbds.biographicBase.sendTguidAsKey	API
gbds.log.diagnose	GBDS
gbds.ul.boot.scan.enabled	GBDS
gbds.boot.scan.ignoreErrorsOnRegion	GBDS
gbds.boot.matcher.creation.sleepTime.ms	GBDS
gbds.biometric.fingerprint.identify.threshold	GBDS
gbds.biometric.fingerprint.exception.threshold	GBDS
gbds.biometric.fingerprint.exception.enabled	GBDS
gbds.biometric.fingerprint.exception.enroll.min-matches-for-exception	GBDS
gbds.biometric.face.identify.threshold	GBDS
gbds.biometric.face.exception.threshold	GBDS
gbds.peopleList.countFromRDB	GBDS
gbds.biometric.face.enabled.threshold	GBDS
gbds.driver.logLevel	GBDS
gbds.log.loadUnload	GBDS
gbds.template.memory.format	GBDS
gbds.match.service.enabled	GBDS
gbds.match.service.initialPort	GBDS
gbds.match.service.logLevel	GBDS
gbds.match.service.timeout	GBDS
gbds.match.service.templateSend.parallelByModality	GBDS
gbds.match.service.linkLibSegfault	GBDS
gbds.match.service.maxTries	GBDS
gbds.match.service.maxConnectionErrors	GBDS
gbds.memory-monitor	GBDS
gbds.watchdog.interval	GBDS
gbds.watchdog.log.mode	GBDS
gbds.watchdog.log.level	GBDS
gbds.verifyPostMatch.enabled	GBDS
gbds.transparency.search.identify.result.notify.enabled	BOTH
gbds.transparency.email-notifier.url	BOTH
gbds.transparency.email-notifier.log-level	BOTH
gbds.transparency.email-notifier.timeout	BOTH
gbscluster.update.consider.fingerprints	BOTH
gbscluster.update.consider.faces	BOTH
gbscluster.update.consider.faces.beforeFingerprints	BOTH
gbscluster.update.faces.verify.matchthreshold	BOTH
gbscluster.update.minimum.fingers	BOTH
gbds.search.verify.adjust-resolution	BOTH

Other settings can be placed in the table gbds.settingsin rdb and all will be written to the API or GBDS file, according to the configuration type. However, runtime memory reloads will not be performed for these new settings, only after restarting the API and/or GBDS.