Table slot9.WORLD.TSTA.INSTALL
Installation information about the application
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
APPLICATION varchar2 15  √  null Name of Application
MAIN_WINDOW varchar2 80 Main Window Title
VERSION varchar2 30 Application Version
RELEASE_DATE date 7 Date of Version Release
AGENCY varchar2 20  √  null Agency Using Application
DEFAULT_STATE varchar2 2  √  null Default State
IDENTIX_BATCH_FILE varchar2 30  √  null
IDENTIX_MANAGER_DIRECTORY varchar2 60  √  null
IDENTIX_REQUESTER_DIRECTORY varchar2 60  √  null
DEFAULT_TIMER number 0  √  null
DEFAULT_COUNTY_CODE varchar2 3  √  null
CONFLICT varchar2 1  √  null
APPLICATION_NAME varchar2 15
INSTALL_SUBSYSTEMS.INSTALL_APPLICATION IS_INSTALL_FK R
LIC_EMAIL varchar2 40  √  null
MAX_LIC number 0  √  null
THRESHOLD number 2  √  null
FORMS_RUNTIME_VERSION varchar2 30  √  null
ORACLE_DB_VERSION varchar2 30  √  null
JINITIATOR_VERSION varchar2 30  √  null
JAVA_VERSION varchar2 30  √  null
REC_ID number 0  √  null
COUNTY_NAME varchar2 200  √  null
DB_SCHEMA varchar2 100  √  null Database schema user owning objects

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"APPLICATION_NAME" IS NOT NULL INSTALL_APPLICATION_NAME_NN
"MAIN_WINDOW" IS NOT NULL INSTALL_MAIN_WINDOW_NN
"RELEASE_DATE" IS NOT NULL INSTALL_RELEASE_DATE_NN
"VERSION" IS NOT NULL INSTALL_VERSION_NN

Indexes:
Column(s) Type Sort Constraint Name
APPLICATION_NAME Primary key Asc INSTALL_PK

Close relationships  within of separation: