Dumped on 2002-9-27.

Index of database - cerebrum


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
F-Key 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:

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 dateNOT 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:

Index - Schema public


Table: public.account_type

public.account_type Structure
F-Key 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
F-Key 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:

Index - Schema public


Table: public.authentication_code

public.authentication_code Structure
F-Key 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:

Index - Schema public


Table: public.authoritative_system_code

public.authoritative_system_code Structure
F-Key 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:

Index - Schema public


Table: public.contact_info_code

public.contact_info_code Structure
F-Key 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:

Index - Schema public


Table: public.country_code

public.country_code Structure
F-Key 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:

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:

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 dateNOT NULL
start_date dateNOT 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
F-Key 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:

Index - Schema public


Table: public.gender_code

public.gender_code Structure
F-Key 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:

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 dateNOT 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:

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
F-Key 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:

Index - Schema public


Table: public.group_visibility_code

public.group_visibility_code Structure
F-Key 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:

Index - Schema public


Table: public.language_code

public.language_code Structure
F-Key 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:

Index - Schema public


Table: public.ou_info

public.ou_info Structure
F-Key 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:

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
F-Key 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:

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 dateNOT NULL
last_date dateNOT 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
F-Key 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:

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
F-Key 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:

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:

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
F-Key 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:

Index - Schema public


Table: public.quarantine_code

public.quarantine_code Structure
F-Key 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:

Index - Schema public


Table: public.value_domain_code

public.value_domain_code Structure
F-Key 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:

Index - Schema public

W3C HTML 4.01 Strict