Table slot9.WORLD.TSTA.BUSINESS_COLLAPSE_LOG
This table stores a log entry for multiple MASTER BUSINESS records being collapsed into a single record
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
COLLAPSE_ID number 38
ADDRESS_COLLAPSE_LOG.COLLAPSE_ID Implied Constraint R
Business Number of Collapsed Business
KEEP_ID number 38 Business Number of Keep Business
COLLAPSE_INFO varchar2 255 Collapsed Business Summary Info
KEEP_INFO varchar2 255 Kept Business Summary Info
CREATOR_ID varchar2 100  √  null Collapsing Person USER ID
CREATOR_DATE date 7  √  null Collapse Date/Time
UPDATOR_ID varchar2 100  √  null Updating Person USER ID
UPDATOR_DATE date 7  √  null Date of Last Update
REC_ID number 0  √  null
BUSINESS_NAME varchar2 80  √  null
BUSINESS_NUMBER varchar2 30  √  null
BTC_TYPE_CODE varchar2 30  √  null
BTC_TYPE_CODE_TYPE varchar2 30  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"COLLAPSE_ID" IS NOT NULL BCL_COLLAPSE_ID_NN
"COLLAPSE_INFO" IS NOT NULL BCL_COLLAPSE_INFO_NN
"KEEP_ID" IS NOT NULL BCL_KEEP_ID_NN
"KEEP_INFO" IS NOT NULL BCL_KEEP_INFO_NN

Indexes:
Column(s) Type Sort Constraint Name
COLLAPSE_ID Primary key Asc BCL_PK

Close relationships: