Table slot9.WORLD.TSTA.BUSINESS_ALARMS
This table stores alarms associated with the MASTER BUSINESS
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
ALARM_ID number 0 Alarm ID #, Primary Key
DATE_OF_INFO date 7 Date of Alarm Information
ACTIVE_YN varchar2 1 Alarm is active? Yes or No.
ALARM_NO varchar2 40  √  null Alarm Identification Number
BUSINESS_NUMBER number 38  √  null
BUSINESSES.BUSINESS_NUMBER BUSALRM_BUSNS_FK C
Unique id for business
BUSINESS_NUMBER_ALARM_CO number 38  √  null
BUSINESSES.BUSINESS_NUMBER BUSALRM_BUSNS_ALARM_CO_FK C
Unique id for business
PERSON_ID number 38  √  null
PEOPLE.PERSON_ID BUSALRM_PER_FK C
Person ID number
BUS_HRS_FROM date 7  √  null Business Hours from hh24mi
BUS_HRS_TO date 7  √  null Business Hours To hh24mi
TYPE_OF_ALARM varchar2 255  √  null Type of Alarm
LIGHTING_DESC varchar2 255  √  null Description of Lighting
SAFE_LOC_CDES varchar2 255  √  null Safe Location Description
WINDOW_DESC varchar2 255  √  null Window Location Description
DOOR_DESC varchar2 255  √  null Door location description
COMMENTS varchar2 255  √  null General Comments
SOURCE_OF_INFO varchar2 80  √  null Source of Information
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 Date of last update
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ACTIVE_YN" IS NOT NULL BUSALRM_ACTIVE_YN_NN
"ALARM_ID" IS NOT NULL BUSALRM_ALARM_ID_NN
"DATE_OF_INFO" IS NOT NULL BUSALRM_DATE_OF_INFO_NN
ACTIVE_YN IN ('Y', 'N') CK_BUSALRM_ACTIVE_YN

Indexes:
Column(s) Type Sort Constraint Name
ALARM_ID Primary key Asc BUSALRM_PK
BUSINESS_NUMBER_ALARM_CO Performance Asc BUSALRM_BUSNS_ALARM_CO_FK_I
BUSINESS_NUMBER Performance Asc BUSALRM_BUSNS_FK_I
PERSON_ID Performance Asc BUSALRM_PER_FK_I

Close relationships  within of separation: