Dumped on 2002-9-27.
Index of database - cerebrum
public.account_authentication Constraints
Name |
Constraint |
account_auth_pk |
PRIMARY KEY (account_id, method) |
Index - Schema public
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
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:
Index - Schema public
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
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
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
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
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
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
public.entity_address Constraints
Name |
Constraint |
entity_address_pk |
PRIMARY KEY (entity_id, source_system, address_type) |
Index - Schema public
public.entity_contact_info Constraints
Name |
Constraint |
entity_contact_info_pk |
PRIMARY KEY (entity_id, source_system, contact_type, contact_pref) |
Index - Schema public
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
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
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
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
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
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:
Index - Schema public
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
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
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
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
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
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
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
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
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
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
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
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
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
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
public.person_name Constraints
Name |
Constraint |
person_name_pk |
PRIMARY KEY (person_id, name_variant, source_system) |
Index - Schema public
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
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
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