Table: posting_group

Previous: post_history

Unanet Data Model

Next: posting_group_source

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	posting_group_key	decimal(15)
2.		posting_group_type	char(1)
3.		posting_group_name	varchar(50)
4.		active	char(1)	('Y')
5.		description	varchar(2000)

Referenced from

Table	Column	Foreign Key Name
posting_group_source	posting_group_key	fk_posting_group_source1
project	posting_group_key	fk_project11

Check Constraints

Name	Definition
cc_posting_group_active	([active]='N' OR [active]='Y')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_posting_group	true	posting_group_key	Asc