Table slot9.WORLD.TSTA.BUSINESSES
This table stores MASTER BUSINESSES (referred to as Organizations in the application) entered in 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
BUSINESS_NUMBER number 0
ARREST_BUSINESSES.BUSINESS_NUMBER ARRB_BUSNS_FK R
ARREST_ORG_SEARCH_VW.BUSINESS_NUMBER Implied Constraint R
BUS_ADDR_ALARM_VW.BUSINESS_NUMBER Implied Constraint R
BUS_ADDR_BUS_REL_VW.BUSINESS_NUMBER Implied Constraint R
BUS_ADDR_EMP_VW.BUSINESS_NUMBER Implied Constraint R
BUS_ADDR_PEOP_VW.BUSINESS_NUMBER Implied Constraint R
BUS_ADDR_PERMIT_VW.BUSINESS_NUMBER Implied Constraint R
BUSINESS_ADDRESS_VW.BUSINESS_NUMBER Implied Constraint R
BUSINESS_ADDRESSES.BUSINESS_NUMBER BUS_ADDR_BUSNS_FK C
BUSINESS_ALARMS.BUSINESS_NUMBER BUSALRM_BUSNS_FK C
BUSINESS_ALARMS.BUSINESS_NUMBER_ALARM_CO BUSALRM_BUSNS_ALARM_CO_FK C
BUSINESS_ATTACHMENTS.BUSINESS_NUMBER BUSNSATT_BUSNS_FK C
BUSINESS_IMAGES.BUSINESS_ID BIMG_BUSNS_FK R
BUSINESS_PROPERTIES.BUSNS_BUSINESS_NUMBER BPPROP_BUSNS_FK R
BUSINESS_RELATIONS.BUSINESS_NUMBER BUSREL_BUSNS_FK C
BUSINESS_RELATIONS.BUSINESS_NUMBER_RELATED BUSREL_BUSNS_FROM_FK C
BUSINESS_RMS_SEARCH_VW.BUSINESS_NUMBER Implied Constraint R
BUSINESS_VEHICLES.BUSINESS_NUMBER BV_BUSNS_FK R
BUSINESS_VEHICLES_VW.BUSINESS_NUMBER Implied Constraint R
BUSINESSES_NOT_DUPLICATES.BUSINESS_NUMBER BUSNODUP_BUSNS_FK R
BUSINESSES_NOT_DUPLICATES.NOT_DUP_BUSINESS_NUMBER BUSNODUP_NOT_BUSNS_FK R
BUSINESSES_SEARCH_VW.BUSINESS_NUMBER Implied Constraint R
CASE_ACTIVITY_NAMES.BUSINESS_NUMBER CACTNAMES_BUSNS_FK R
CITATION_BUSINESSES.BUSINESS_NUMBER CB1_BUSNS_FK C
COURT_PAPER_LOGS.BUSINESS_SERVED_ID CPAP_LOG_BUSNS_FK R
COURT_PAPER_PARTIES.BUSINESS_NUMBER CPP_BUSNS_FK R
CP_DEL_LOG_PARTIES.BUSINESS_NUMBER CPLOGPARTY_BUSNS_FK C
CP_DELETE_PARTY.BUSINESS_ID CPDELPAR_LOG_BUSNS_FK R
CP_DELETE_PAYMENT.BUSINESS_ID CPDELPAY_BUSNS_FK R
CP_DELETE_SERVICE_ADDR.BUSINESS_ID CPDELSADDR_BUSNS_FK R
EDUCATION.BUSINESS_NUMBER EDU_BUSNS_FK C
EMAILS.BUSINESS_NUMBER EMAIL_BUSNS_FK R
EMPLOYMENTS.BUSNS_BUSINESS_NUMBER EMP_BUSNS_FK R
FLDINT_BUSINESSES.BUSINESS_NUMBER FI_BUSINESS_BUSNS_FK C
IMPOUND_BUSINESSES.BUSINESS_NUMBER IMPBUS_BUSNS_FK C
INCIDENT_BUSINESS_VW.BUSINESS_NUMBER Implied Constraint R
INCIDENT_BUSINESSES.BUSNS_BUSINESS_NUMBER IB_BUSNS_FK R
INCIDENT_NAME_VW.BUSINESS_NUMBER Implied Constraint R
INCIDENT_VICTIM_NAME_VW.BUSINESS_NUMBER Implied Constraint R
JS_PERMIT_BUSINESS_VW.BUSINESS_NUMBER Implied Constraint R
PAWN_TICKETS.BUSNS_BUSINESS_NUMBER PT_BUSNS_FK R
PEOPLE_BUSINESSES.BUSINESS_NUMBER PEOBUS_BUSNS_FK C
PERMIT_BUSINESSES.BUSINESS_NUMBER PRMB_BUSNS_FK C
TRAININGS.BUSINESS_NUMBER TRA_BUSNS_FK R
USER_FIELD_BUS_VALUES.BUSINESS_NUMBER USRSCRN_UFBV_BUSNS_FK R
Unique id for business
BUSINESS_NAME varchar2 80 Name of business
BTC_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE BUSNS_BTC_TYPE_COD_EJS_CODE_FK R
Type Code (business"s)
BUSINESS_ID varchar2 30  √  null Tax ID
CREATOR_ID varchar2 100  √  null Person creating the record
CREATOR_DATE date 7  √  null Date of record creation
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Person who last updated the record
INDX_SEC_LEVEL_CODE number 0  √  1
MASTER_INDEX_SECURITY_CODES.INDX_SEC_LEVEL_CODE BUSINESSES_MIS_CD_CD_FK R
INDX_SEC_LEVEL_ID varchar2 100  √  null
INDX_SEC_LEVEL_AGENCY varchar2 30  √  null
ACTIVE_SUBSCRIPTION varchar2 1  √  null
BTC_TYPE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE BUSNS_BTC_TYPE_COD_EJS_CODE_FK R
INDX_TYPE_CODE varchar2 30  √  'KNOWN'
REC_ID number 0  √  null
LOADED_BY varchar2 100  √  null Interface that loaded this index record.
LAST_LOAD_DATE date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"BUSINESS_NAME" IS NOT NULL BUSNS_BUSINESS_NAME_NN
"BUSINESS_NUMBER" IS NOT NULL BUSNS_BUSINESS_NUMBER_NN

Indexes:
Column(s) Type Sort Constraint Name
BUSINESS_NUMBER Primary key Asc BUSNS_PK
BUSINESS_NAME Performance Asc BUSINESS_NAME
INDX_SEC_LEVEL_CODE Performance Asc BUSINESSES_INDX_SEC_LEVEL_CD_I
BTC_TYPE_CODE Performance Asc BUSNS_BTC_FK_I
BTC_TYPE_CODE_TYPE + BTC_TYPE_CODE Performance Asc/Asc BUSNS_BTC_TYPE_COD_EJS_CODE_I

Close relationships  within of separation: