Dumped on 2004-1-15.

Index of database - chaco

public

cdi_accession
collection
collection_survey_log
eo_pk_table
institution
log_collection
object
person
person_institution
person_project
project
project_collection
project_institution
site
site_object
site_project
storage_unit
storage_unit_log
storage_unit_object

Table: public.cdi_accession

public.cdi_accession Structure
F-Key	Name	Type	Description
	cdi_accession_key	integer	NOT NULL PRIMARY KEY default nextval('cdi_accession_seq'::text)
	cdi_file_catalog_number	character varying(80)
	physical_file_location	character varying(256)
	eltronic_file_uva	character varying(256)
	description_of_data	character varying(256)
	source_of_data	character varying(80)
	receiver_of_data	character varying(80)
	date_received	date
	entered_by	character varying(80)
	comments	character varying(256)
public -> object	object_key	integer
public -> collection	collection_key	integer

Tables referencing this one via Foreign Key Constraints:

public.object

Index - Schema public

Table: public.collection

public.collection Structure
F-Key	Name	Type	Description
	collection_key	integer	NOT NULL PRIMARY KEY default nextval('collection_seq'::text)
	name	character varying(80)
	number	character varying(80)
	finding_aid_available	integer
	finding_aid_notes	character varying(256)
	other_data_source	character varying(256)
	types_of_material	character varying(80)
	extent_of_material	character varying(80)
	recorders_comment	character varying(256)
	cdi_analyst_recorder	character varying(80)
	date_entered	date
public -> institution	institution_key	integer
public -> person	person_key	integer

Tables referencing this one via Foreign Key Constraints:

public.cdi_accession
public.log_collection
public.project_collection
public.storage_unit

Index - Schema public

Table: public.collection_survey_log

public.collection_survey_log Structure
F-Key	Name	Type	Description
	log_key	integer	NOT NULL PRIMARY KEY default nextval('log_seq'::text)
	visitation_number	character varying(80)
	cdi_staff_member	character varying(80)
	worked_with	character varying(256)
	begin_date_of_visit	date
	end_date_of_visit	date
	description_of_work	character varying(256)
	contact_next_visit	character varying(256)
public -> institution	institution_key	integer

Tables referencing this one via Foreign Key Constraints:

public.log_collection
public.storage_unit_log

Index - Schema public

Table: public.eo_pk_table

public.eo_pk_table Structure
F-Key	Name	Type	Description
	name	character varying(80)	NOT NULL
	pk	bigint	NOT NULL

Index - Schema public

Table: public.institution

public.institution Structure
Name	Type	Description
institution_key	integer	NOT NULL PRIMARY KEY default nextval('institution_seq'::text)
full_name	character varying(256)
abbrev	character varying(80)
office	character varying(80)
street1	character varying(80)
street2	character varying(80)
city	character varying(80)
state	character varying(80)
zipcode	character varying(32)
contact_person	character varying(80)
office_hours	character varying(80)
phone	character varying(80)
fax	character varying(80)
email	character varying(80)
url	character varying(256)

Tables referencing this one via Foreign Key Constraints:

public.collection
public.collection_survey_log
public.person_institution
public.project_institution

Index - Schema public

Table: public.log_collection

public.log_collection Structure
F-Key	Name	Type	Description
public -> collection_survey_log	log_key	integer
public -> collection	collection_key	integer

Index - Schema public

Table: public.object

public.object Structure
F-Key	Name	Type	Description
	object_key	integer	NOT NULL PRIMARY KEY default nextval('object_seq'::text)
	institutions_object_designation	character varying(80)
	cdi_object_no	character varying(80)
	cdi_object_type	character varying(80)
	cdi_description	character varying(256)
	published	integer
	publication_description	character varying(256)
	scanned	integer
	scanned_descrition_notes	character varying(256)
	photographed	integer
	photo_description_notes	character varying(256)
	copyright	integer
	copyright_information	character varying(256)
public -> project	project_key	integer
public -> cdi_accession	cdi_accession_key	integer

Tables referencing this one via Foreign Key Constraints:

public.cdi_accession
public.site_object
public.storage_unit_object

Index - Schema public

Table: public.person

public.person Structure
F-Key	Name	Type	Description
	person_key	integer	NOT NULL PRIMARY KEY default nextval('person_seq'::text)
	scholar	character varying(80)

Tables referencing this one via Foreign Key Constraints:

public.collection
public.person_institution
public.person_project

Index - Schema public

Table: public.person_institution

public.person_institution Structure
F-Key	Name	Type	Description
	prim_key	integer	NOT NULL PRIMARY KEY default nextval('personinstitution_seq'::text)
public -> person	person_key	integer
public -> institution	institution_key	integer
	role	character varying(80)
	dates	character varying(80)

Index - Schema public

Table: public.person_project

public.person_project Structure
F-Key	Name	Type	Description
	prim_key	integer	NOT NULL PRIMARY KEY default nextval('projectperson_seq'::text)
public -> person	person_key	integer
public -> project	project_key	integer
	director	integer
	supervisor	integer
	excavator	integer
	staff_analyst	integer
	other	integer
	dates	character varying(80)

Index - Schema public

Table: public.project

public.project Structure
Name	Type	Description
project_key	integer	NOT NULL PRIMARY KEY default nextval('project_seq'::text)
name	character varying(80)
description	character varying(512)
begin_fieldwork	date
end_fieldwork	date

Tables referencing this one via Foreign Key Constraints:

public.object
public.person_project
public.project_collection
public.project_institution
public.site_project

Index - Schema public

Table: public.project_collection

public.project_collection Structure
F-Key	Name	Type	Description
public -> project	project_key	integer
public -> collection	collection_key	integer

Index - Schema public

Table: public.project_institution

public.project_institution Structure
F-Key	Name	Type	Description
	prim_key	integer	NOT NULL PRIMARY KEY default nextval('projectinstitution_seq'::text)
public -> project	project_key	integer
public -> institution	institution_key	integer
	funding	integer
	staff	integer
	space	integer
	repository	integer
	dates	character varying(80)

Index - Schema public

Table: public.site

public.site Structure
Name	Type	Description
site_key	integer	NOT NULL PRIMARY KEY default nextval('site_seq'::text)
popular_name	character varying(80)
cdi_site_name	character varying(80)
state	character varying(80)
state_official	character varying(80)
bc_site_number	character varying(80)
nps_site_number	character varying(80)
comments	character varying(256)

Tables referencing this one via Foreign Key Constraints:

public.site_object
public.site_project

Index - Schema public

Table: public.site_object

public.site_object Structure
F-Key	Name	Type	Description
public -> site	site_key	integer
public -> object	object_key	integer

Index - Schema public

Table: public.site_project

public.site_project Structure
F-Key	Name	Type	Description
public -> site	site_key	integer
public -> project	project_key	integer

Index - Schema public

Table: public.storage_unit

public.storage_unit Structure
F-Key	Name	Type	Description
	storage_unit_key	integer	NOT NULL PRIMARY KEY default nextval('storage_unit_seq'::text)
	institutions_catalog_no	character varying(80)
	institutions_catalog_descriptions	character varying(256)
	cdi_storage_unit_designator	character varying(80)
	cdi_description_of_materials	character varying(256)
	post_fieldwork_manuscript	integer
	manuscript_documentation	character varying(256)
	field_notes	integer
	field_notes_description	character varying(256)
	field_catalog	integer
	field_catalog_description	character varying(256)
	photographs	integer
	photographs_description	character varying(256)
	drawings	integer
	drawings_description	character varying(256)
	maps	integer
	maps_description	character varying(256)
	correspondence	integer
	correspondence_description	character varying(256)
	other_description	character varying(256)
	actions_needed	character varying(256)
	action_date	date
	copyright_information	character varying(256)
public -> collection	collection_key	integer

Tables referencing this one via Foreign Key Constraints:

public.storage_unit_log
public.storage_unit_object

Index - Schema public

Table: public.storage_unit_log

public.storage_unit_log Structure
F-Key	Name	Type	Description
public -> storage_unit	storage_unit_key	integer
public -> collection_survey_log	log_key	integer

Index - Schema public

Table: public.storage_unit_object

public.storage_unit_object Structure
F-Key	Name	Type	Description
public -> storage_unit	storage_unit_key	integer
public -> object	object_key	integer

Index - Schema public

W3C HTML 4.01 Strict