Table: image_setup

Previous: holiday

Unanet Data Model

Next: imported_air_detail

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