Dumped on 2002-9-27.

Index of database - cerebrum

public

account_authentication
account_code
account_info
account_type
address_code
authentication_code
authoritative_system_code
contact_info_code
country_code
entity_address
entity_contact_info
entity_info
entity_name
entity_quarantine
entity_type_code
gender_code
group_info
group_member
group_membership_op_code
group_visibility_code
language_code
ou_info
ou_name_language
ou_perspective_code
ou_structure
person_aff_status_code
person_affiliation
person_affiliation_code
person_external_id
person_external_id_code
person_info
person_name
person_name_code
quarantine_code
value_domain_code

Table: public.account_authentication

public.account_authentication Structure
F-Key	Name	Type	Description
public -> account_info	account_id	numeric(12,0)	NOT NULL
public -> authentication_code	method	numeric(6,0)	NOT NULL
	auth_data	character varying(4000)	NOT NULL

public.account_authentication Constraints
Name	Constraint
account_auth_pk	PRIMARY KEY (account_id, method)

Index - Schema public

Table: public.account_code

public.account_code Structure
Name	Type	Description
code	numeric(6,0)	NOT NULL PRIMARY KEY
code_str	character varying(16)	NOT NULL UNIQUE
description	character varying(512)	NOT NULL

Tables referencing this one via Foreign Key Constraints:

public.account_info

Index - Schema public

Table: public.account_info

public.account_info Structure
F-Key	Name	Type	Description
	entity_type	numeric(6,0)	NOT NULL default 2003
	account_id	numeric(12,0)	NOT NULL PRIMARY KEY
	owner_type	numeric(6,0)	NOT NULL
	owner_id	numeric(12,0)	NOT NULL
public -> account_code	np_type	numeric(6,0)
	create_date	date	NOT NULL
public -> account_info	creator_id	numeric(12,0)	NOT NULL
	expire_date	date

public.account_info Constraints
Name	Constraint
"RI_ConstraintTrigger_30649"	FOREIGN KEY (entity_type, entity_id) REFERENCES entity_info(entity_type, account_id)
"RI_ConstraintTrigger_30655"	FOREIGN KEY (owner_type, entity_id) REFERENCES entity_info(entity_type, owner_id)
account_info_entity_type_chk	CHECK entity_type = '2003'::"numeric"
account_info_id_owner_unique	UNIQUE (account_id, owner_id)
account_info_np_type_chk	CHECK ((owner_type = '2002'::"numeric") AND (np_type IS NULL)) OR ((owner_type = '2004'::"numeric") AND (np_type IS NOT NULL))
account_info_owner_type_chk	CHECK (owner_type = '2002'::"numeric") OR (owner_type = '2004'::"numeric")

Tables referencing this one via Foreign Key Constraints:

public.account_authentication
public.account_info
public.entity_quarantine
public.group_info

Index - Schema public

Table: public.account_type

public.account_type Structure
Name	Type	Description
person_id	numeric(12,0)	NOT NULL
ou_id	numeric(12,0)	NOT NULL
affiliation	numeric(6,0)	NOT NULL
source_system	numeric(6,0)	NOT NULL
account_id	numeric(12,0)	NOT NULL

public.account_type Constraints
Name	Constraint
"RI_ConstraintTrigger_30868"	FOREIGN KEY (person_id, source_system, affiliation, ou_id) REFERENCES person_affiliation(person_id, source_system, affiliation, ou_id)
"RI_ConstraintTrigger_30874"	FOREIGN KEY (account_id, owner_id) REFERENCES account_info(account_id, person_id)
account_type_pk	PRIMARY KEY (person_id, ou_id, affiliation, account_id, source_system)

Index - Schema public

Table: public.address_code

public.address_code Structure
Name	Type	Description
code	numeric(6,0)	NOT NULL PRIMARY KEY
code_str	character varying(16)	NOT NULL UNIQUE
description	character varying(512)	NOT NULL

Tables referencing this one via Foreign Key Constraints:

public.entity_address

Index - Schema public

Table: public.authentication_code

public.authentication_code Structure
Name	Type	Description
code	numeric(6,0)	NOT NULL PRIMARY KEY
code_str	character varying(16)	NOT NULL UNIQUE
description	character varying(512)	NOT NULL

Tables referencing this one via Foreign Key Constraints:

public.account_authentication

Index - Schema public

Table: public.authoritative_system_code

public.authoritative_system_code Structure
Name	Type	Description
code	numeric(6,0)	NOT NULL PRIMARY KEY
code_str	character varying(16)	NOT NULL UNIQUE
description	character varying(512)	NOT NULL

Tables referencing this one via Foreign Key Constraints:

public.entity_address
public.entity_contact_info
public.person_affiliation
public.person_external_id
public.person_name

Index - Schema public

Table: public.contact_info_code

public.contact_info_code Structure
Name	Type	Description
code	numeric(6,0)	NOT NULL PRIMARY KEY
code_str	character varying(16)	NOT NULL UNIQUE
description	character varying(512)	NOT NULL

Tables referencing this one via Foreign Key Constraints:

public.entity_contact_info

Index - Schema public

Table: public.country_code

public.country_code Structure
Name	Type	Description
code	numeric(6,0)	NOT NULL PRIMARY KEY
code_str	character varying(16)	NOT NULL UNIQUE
country	character varying(64)	NOT NULL
phone_prefix	character varying(8)
description	character varying(512)	NOT NULL

Tables referencing this one via Foreign Key Constraints:

public.entity_address

Index - Schema public

Table: public.entity_address

public.entity_address Structure
F-Key	Name	Type	Description
public -> entity_info	entity_id	numeric(12,0)	NOT NULL
public -> authoritative_system_code	source_system	numeric(6,0)	NOT NULL
public -> address_code	address_type	numeric(6,0)	NOT NULL
	address_text	character varying(256)
	p_o_box	character varying(10)
	postal_number	character varying(8)
	city	character varying(128)
public -> country_code	country	numeric(6,0)

public.entity_address Constraints
Name	Constraint
entity_address_pk	PRIMARY KEY (entity_id, source_system, address_type)

Index - Schema public

Table: public.entity_contact_info

public.entity_contact_info Structure
F-Key	Name	Type	Description
public -> entity_info	entity_id	numeric(12,0)	NOT NULL
public -> authoritative_system_code	source_system	numeric(6,0)	NOT NULL
public -> contact_info_code	contact_type	numeric(6,0)	NOT NULL
	contact_pref	numeric(2,0)	NOT NULL default 50
	contact_value	character varying(255)	NOT NULL
	description	character varying(512)

public.entity_contact_info Constraints
Name	Constraint
entity_contact_info_pk	PRIMARY KEY (entity_id, source_system, contact_type, contact_pref)

Index - Schema public

Table: public.entity_info

public.entity_info Structure
F-Key	Name	Type	Description
	entity_id	numeric(12,0)	NOT NULL PRIMARY KEY
public -> entity_type_code	entity_type	numeric(6,0)	NOT NULL

public.entity_info Constraints
Name	Constraint
entity_info_type_unique	UNIQUE (entity_type, entity_id)

Tables referencing this one via Foreign Key Constraints:

public.entity_address
public.entity_contact_info
public.entity_name
public.entity_quarantine

Index - Schema public

Table: public.entity_name

public.entity_name Structure
F-Key	Name	Type	Description
public -> entity_info	entity_id	numeric(12,0)	NOT NULL
public -> value_domain_code	value_domain	numeric(6,0)	NOT NULL
	entity_name	character varying(256)	NOT NULL

public.entity_name Constraints
Name	Constraint
entity_name_pk	PRIMARY KEY (entity_id, value_domain)
entity_name_unique_per_domain	UNIQUE (value_domain, entity_name)

Index - Schema public

Table: public.entity_quarantine

public.entity_quarantine Structure
F-Key	Name	Type	Description
public -> entity_info	entity_id	numeric(12,0)	NOT NULL
public -> quarantine_code	quarantine_type	numeric(6,0)	NOT NULL
public -> account_info	creator_id	numeric(12,0)	NOT NULL
	description	character varying(512)
	create_date	date	NOT NULL
	start_date	date	NOT NULL
	disable_until	date
	end_date	date

public.entity_quarantine Constraints
Name	Constraint
entity_quarantine_pk	PRIMARY KEY (entity_id, quarantine_type)

Index - Schema public

Table: public.entity_type_code

public.entity_type_code Structure
Name	Type	Description
code	numeric(6,0)	NOT NULL PRIMARY KEY
code_str	character varying(16)	NOT NULL UNIQUE
description	character varying(512)	NOT NULL

Tables referencing this one via Foreign Key Constraints:

public.entity_info

Index - Schema public

Table: public.gender_code

public.gender_code Structure
Name	Type	Description
code	numeric(6,0)	NOT NULL PRIMARY KEY
code_str	character varying(16)	NOT NULL UNIQUE
description	character varying(512)	NOT NULL

Tables referencing this one via Foreign Key Constraints:

public.person_info

Index - Schema public

Table: public.group_info

public.group_info Structure
F-Key	Name	Type	Description
	entity_type	numeric(6,0)	NOT NULL default 2004
	group_id	numeric(12,0)	NOT NULL PRIMARY KEY
	description	character varying(512)
public -> group_visibility_code	visibility	numeric(6,0)	NOT NULL
public -> account_info	creator_id	numeric(12,0)	NOT NULL
	create_date	date	NOT NULL
	expire_date	date

public.group_info Constraints
Name	Constraint
"RI_ConstraintTrigger_30921"	FOREIGN KEY (entity_type, entity_id) REFERENCES entity_info(entity_type, group_id)
group_info_entity_type_chk	CHECK entity_type = '2004'::"numeric"

Tables referencing this one via Foreign Key Constraints:

public.group_member

Index - Schema public

Table: public.group_member

public.group_member Structure
F-Key	Name	Type	Description
public -> group_info	group_id	numeric(12,0)	NOT NULL
public -> group_membership_op_code	operation	numeric(6,0)	NOT NULL
	member_type	numeric(6,0)	NOT NULL
	member_id	numeric(12,0)	NOT NULL

public.group_member Constraints
Name	Constraint
"RI_ConstraintTrigger_30946"	FOREIGN KEY (member_type, entity_id) REFERENCES entity_info(entity_type, member_id)
group_member_not_self	CHECK group_id <> member_id
group_member_pk	PRIMARY KEY (group_id, operation, member_id)

Index - Schema public

Table: public.group_membership_op_code

public.group_membership_op_code Structure
Name	Type	Description
code	numeric(6,0)	NOT NULL PRIMARY KEY
code_str	character varying(16)	NOT NULL UNIQUE
description	character varying(512)	NOT NULL

Tables referencing this one via Foreign Key Constraints:

public.group_member

Index - Schema public

Table: public.group_visibility_code

public.group_visibility_code Structure
Name	Type	Description
code	numeric(6,0)	NOT NULL PRIMARY KEY
code_str	character varying(16)	NOT NULL UNIQUE
description	character varying(512)	NOT NULL

Tables referencing this one via Foreign Key Constraints:

public.group_info

Index - Schema public

Table: public.language_code

public.language_code Structure
Name	Type	Description
code	numeric(6,0)	NOT NULL PRIMARY KEY
code_str	character varying(16)	NOT NULL UNIQUE
description	character varying(512)	NOT NULL

Tables referencing this one via Foreign Key Constraints:

public.ou_name_language

Index - Schema public

Table: public.ou_info

public.ou_info Structure
Name	Type	Description
entity_type	numeric(6,0)	NOT NULL default 2001
ou_id	numeric(12,0)	NOT NULL PRIMARY KEY
name	character varying(512)	NOT NULL
acronym	character varying(15)
short_name	character varying(30)
display_name	character varying(80)
sort_name	character varying(80)

public.ou_info Constraints
Name	Constraint
"RI_ConstraintTrigger_30688"	FOREIGN KEY (entity_type, entity_id) REFERENCES entity_info(entity_type, ou_id)
ou_info_entity_type_chk	CHECK entity_type = '2001'::"numeric"

Tables referencing this one via Foreign Key Constraints:

public.ou_name_language
public.ou_structure
public.ou_structure
public.person_affiliation

Index - Schema public

Table: public.ou_name_language

public.ou_name_language Structure
F-Key	Name	Type	Description
public -> ou_info	ou_id	numeric(12,0)	NOT NULL
public -> language_code	language_code	numeric(6,0)	NOT NULL
	name	character varying(512)	NOT NULL
	acronym	character varying(15)
	short_name	character varying(30)
	display_name	character varying(80)
	sort_name	character varying(80)

public.ou_name_language Constraints
Name	Constraint
ou_name_language_pk	PRIMARY KEY (ou_id, language_code)

Index - Schema public

Table: public.ou_perspective_code

public.ou_perspective_code Structure
Name	Type	Description
code	numeric(6,0)	NOT NULL PRIMARY KEY
code_str	character varying(16)	NOT NULL UNIQUE
description	character varying(512)	NOT NULL

Tables referencing this one via Foreign Key Constraints:

public.ou_structure

Index - Schema public

Table: public.ou_structure

public.ou_structure Structure
F-Key	Name	Type	Description
public -> ou_info	ou_id	numeric(12,0)	NOT NULL
public -> ou_perspective_code	perspective	numeric(6,0)	NOT NULL
public -> ou_info	parent_id	numeric(12,0)

public.ou_structure Constraints
Name	Constraint
"RI_ConstraintTrigger_30719"	FOREIGN KEY (parent_id, perspective) REFERENCES ou_structure(ou_id, perspective)
ou_structure_pk	PRIMARY KEY (ou_id, perspective)

Index - Schema public

Table: public.person_aff_status_code

public.person_aff_status_code Structure
F-Key	Name	Type	Description
public -> person_affiliation_code	affiliation	numeric(6,0)	NOT NULL
	status	numeric(6,0)	NOT NULL
	status_str	character varying(16)	NOT NULL
	description	character varying(512)	NOT NULL

public.person_aff_status_code Constraints
Name	Constraint
person_aff_status_code_pk	PRIMARY KEY (affiliation, status)
person_aff_status_codestr_u	UNIQUE (affiliation, status_str)

Index - Schema public

Table: public.person_affiliation

public.person_affiliation Structure
F-Key	Name	Type	Description
public -> person_info	person_id	numeric(12,0)	NOT NULL
public -> ou_info	ou_id	numeric(12,0)	NOT NULL
public -> person_affiliation_code	affiliation	numeric(6,0)	NOT NULL
public -> authoritative_system_code	source_system	numeric(6,0)	NOT NULL
	status	numeric(6,0)
	create_date	date	NOT NULL
	last_date	date	NOT NULL
	deleted_date	date

public.person_affiliation Constraints
Name	Constraint
"RI_ConstraintTrigger_30859"	FOREIGN KEY (affiliation, status) REFERENCES person_aff_status_code(affiliation, status)
person_affiliation_pk	PRIMARY KEY (person_id, ou_id, affiliation, source_system)

Index - Schema public

Table: public.person_affiliation_code

public.person_affiliation_code Structure
Name	Type	Description
code	numeric(6,0)	NOT NULL PRIMARY KEY
code_str	character varying(16)	NOT NULL UNIQUE
description	character varying(512)	NOT NULL

Tables referencing this one via Foreign Key Constraints:

public.person_aff_status_code
public.person_affiliation

Index - Schema public

Table: public.person_external_id

public.person_external_id Structure
F-Key	Name	Type	Description
public -> person_info	person_id	numeric(12,0)	NOT NULL
public -> person_external_id_code	id_type	numeric(6,0)	NOT NULL
public -> authoritative_system_code	source_system	numeric(6,0)	NOT NULL
	external_id	character varying(256)

public.person_external_id Constraints
Name	Constraint
person_external_id_pk	PRIMARY KEY (person_id, id_type, source_system)
person_external_id_unique	UNIQUE (id_type, external_id)

Index - Schema public

Table: public.person_external_id_code

public.person_external_id_code Structure
Name	Type	Description
code	numeric(6,0)	NOT NULL PRIMARY KEY
code_str	character varying(16)	NOT NULL UNIQUE
description	character varying(512)	NOT NULL

Tables referencing this one via Foreign Key Constraints:

public.person_external_id

Index - Schema public

Table: public.person_info

public.person_info Structure
F-Key	Name	Type	Description
	entity_type	numeric(6,0)	NOT NULL default 2002
	person_id	numeric(12,0)	NOT NULL PRIMARY KEY
	export_id	character varying(16)	UNIQUE
	birth_date	date
public -> gender_code	gender	numeric(6,0)	NOT NULL
	deceased	character(1)	NOT NULL default 'F'
	description	character varying(512)

public.person_info Constraints
Name	Constraint
"RI_ConstraintTrigger_30761"	FOREIGN KEY (entity_type, entity_id) REFERENCES entity_info(entity_type, person_id)
person_info_deceased_bool	CHECK (deceased = 'T'::bpchar) OR (deceased = 'F'::bpchar)
person_info_entity_type_chk	CHECK entity_type = '2002'::"numeric"

Tables referencing this one via Foreign Key Constraints:

public.person_affiliation
public.person_external_id
public.person_name

Index - Schema public

Table: public.person_name

public.person_name Structure
F-Key	Name	Type	Description
public -> person_info	person_id	numeric(12,0)	NOT NULL
public -> person_name_code	name_variant	numeric(6,0)	NOT NULL
public -> authoritative_system_code	source_system	numeric(6,0)	NOT NULL
	name	character varying(256)	NOT NULL

public.person_name Constraints
Name	Constraint
person_name_pk	PRIMARY KEY (person_id, name_variant, source_system)

Index - Schema public

Table: public.person_name_code

public.person_name_code Structure
Name	Type	Description
code	numeric(6,0)	NOT NULL PRIMARY KEY
code_str	character varying(16)	NOT NULL UNIQUE
description	character varying(512)	NOT NULL

Tables referencing this one via Foreign Key Constraints:

public.person_name

Index - Schema public

Table: public.quarantine_code

public.quarantine_code Structure
Name	Type	Description
code	numeric(6,0)	NOT NULL PRIMARY KEY
code_str	character varying(16)	NOT NULL UNIQUE
description	character varying(512)	NOT NULL
duration	numeric(4,0)

Tables referencing this one via Foreign Key Constraints:

public.entity_quarantine

Index - Schema public

Table: public.value_domain_code

public.value_domain_code Structure
Name	Type	Description
code	numeric(6,0)	NOT NULL PRIMARY KEY
code_str	character varying(16)	NOT NULL UNIQUE
description	character varying(512)	NOT NULL

Tables referencing this one via Foreign Key Constraints:

public.entity_name

Index - Schema public

W3C HTML 4.01 Strict