COMPANY 
Default Table Name  COMPANY 
Definition 
 Name: Company .     Description: This table keeps overall company information including licensing.
 

COMPANY Columns 
ColumnName  Domain  Datatype  NULL  Definition 
COMPANY_ID(PK)    VARCHAR2(10)  NO 
Name: Company ID. Description: The Company ID (i.e., client ID).
 
DFLT_COUNTRY_CD(FK)    VARCHAR2(2)  NO 
Name: Default Country. Description: The default country for this company.
 
DFLT_LANGUAGE_CD(FK)    VARCHAR2(2)  NO 
Name: Default Language. Description: The default language code for this company.
 
MODIFIED_BY    VARCHAR2(20)  NO 
Name: Modified By. Description: The User ID of the person who last modified this record.
 
ROWVERSION    NUMBER(10, 0)  NO 
Name: Row Version. Description: The number of times this record has been updated.
 
TIME_STAMP    DATE  NO 
Name: Time Stamp. Description: Date and time the record was last modified.
 
COMPANY_NAME_S    VARCHAR2(4000)  NO 
Name: Company Name. Description: The name of the site. This is an encrypted field.
 

COMPANY Primary and Unique Keys 
Key Name  Key Type  Keys 
PI_0019  PrimaryKey  COMPANY_ID 

COMPANY Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
LANGUAGE  Non-Identifying  One To Zero or More  F00009      DFLT_COUNTRY_CD, DFLT_LANGUAGE_CD  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable 
COMPANY_ACCESS  Identifying  One To Zero or More  F00115        NO  NO 
GENERAL_CONFIG  Identifying  One To Zero or More  F00116        NO  NO 
GENERAL_CONFIG_LABELS  Identifying  One To Zero or More  F00120        NO  NO 
TIME_CONFIG  Identifying  One To Zero or More  F00125        NO  NO 
TIME_CONFIG_LABELS  Identifying  One To Zero or More  F00129        NO  NO 
TIME_CONFIG_UDT  Identifying  One To Zero or More  F00131        NO  NO 
EXP_CONFIG  Identifying  One To Zero or More  F00169        NO  NO 
ESS_CONFIG  Identifying  One To Zero or More  F00336        NO  NO 
GENERAL_CONFIG_ATTACHMENT  Identifying  One To Zero or More  F00451        NO  NO 
GENERAL_CONFIG_ATTACHMENT_LBLS  Identifying  One To Zero or More  F00452        NO  NO