Table slot9.WORLD.TSTA.AGENCY_API_KEYS
Associates API keys with agencies for external systems (such as google maps).
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ID number 38
DS_ICR_CAT_QUERIES.ID Implied Constraint R
AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE AGAPIK_AGNCY_CD_FK C
API_KEY varchar2 500
TYPE_CODE varchar2 30
EJS_CODES.CODE AGAPIK_EJSCD_TYP_FK R
TYPE_CODE_TYPE varchar2 30 'API_KEY_TYPE_CODES'
EJS_CODES.CODE_TYPE AGAPIK_EJSCD_TYP_FK R
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"AGENCY_CODE" IS NOT NULL AGAPIK_AGENCY_CD_NN
"ID" IS NOT NULL AGAPIK_ID_NN
"API_KEY" IS NOT NULL AGAPIK_KEY_NN
"TYPE_CODE" IS NOT NULL AGAPIK_TYP_CD_NN
"TYPE_CODE_TYPE" IS NOT NULL AGAPIK_TYP_CD_TYP_NN

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc AGAPIK_PK
AGENCY_CODE Performance Asc AGAPIK_AGNCY_CD_FK_I
TYPE_CODE_TYPE + TYPE_CODE Performance Asc/Asc AGAPIK_EJSCD_TYP_FK_I

Close relationships  within of separation: