Table: image_setup

Columns
  Column Name Data Type Default
Value
References
Table
Foreign Key
Name
1. PK image_setup_key decimal(15)      
2.   name varchar(50)      
3.   type decimal(1)      
4.   description varchar(100)      
5.   attachment_key decimal(15)   attachment fk_image_setup1
6.   url varchar(128)      
7.   alt_text varchar(128)      
8.   last_modified_by decimal(15)   person fk_image_setup2
9.   last_modified_at datetime      
10.   active char(1) ('Y')    
Foreign Keys
Column References Foreign Key Name
Table Column
attachment_key attachment attachment_key fk_image_setup1
last_modified_by person person_key fk_image_setup2
Referenced from
Table Column Foreign Key Name
invoice company_logo fk_invoice6
project_invoice company_logo fk_project_invoice5
Check Constraints
Name Definition
cc_image_setup_active ([active]='N' OR [active]='Y')
cc_is_type ([type]=(4) OR [type]=(3) OR [type]=(2) OR [type]=(1))
Indices
Index Name Unique Column Name Asc Or Desc
pk_image_setup true image_setup_key Asc