Table: udf_setup

Previous: udf_option

Unanet Data Model

Next: unanet_access

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	entity_type	decimal(15)		udf_entity	fk_udf_setup1
2.	PK	udf_number	decimal(15)
3.		data_type	decimal(15)	((3))
4.		show	decimal(15)	((0))
5.		required	char(1)	('N')
6.		active	char(1)	('N')
7.		label	varchar(128)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
entity_type	udf_entity	entity_type	fk_udf_setup1

Referenced from

Table	Column	Foreign Key Name
udf_option	entity_type	fk_udf_option1
	udf_number

Check Constraints

Name	Definition
cc_udf_active	([active]='N' OR [active]='Y')
cc_udf_data_type	([data_type]=(5) OR [data_type]=(4) OR [data_type]=(3) OR [data_type]=(2) OR [data_type]=(1))
cc_udf_required	([required]='N' OR [required]='Y')
cc_udf_show	([show]=(2) OR [show]=(1) OR [show]=(0))

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_udf_setup	true	entity_type	Asc
		udf_number