Dumped on 2004-7-15.

Index of database - chaco-05-05-04

public

alternative_title
cdi_accession
collection
collection_survey_log
documentary_instance
eo_pk_table
institution
institution_work
log_collection
notes
object
person
person_created_work
person_doc_inst
person_in_work
person_institution
person_project
project
project_collection
project_institution
site
site_object
site_project
storage_unit
storage_unit_log
storage_unit_object
work
work_work

Table: public.alternative_title

public.alternative_title Structure
F-Key	Name	Type	Description
	alt_title_key	integer	NOT NULL PRIMARY KEY default nextval('alt_title_seq'::text)
public -> work	work_id	integer
public -> documentary_instance	doc_inst_id	integer
	title	character varying(256)

Index - Schema public

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)
	entered_by	character varying(80)
	comments	character varying(256)
public -> object	object_key	integer
public -> collection	collection_key	integer
	date_received	integer
	type	character varying(80)

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)
public -> institution	institution_key	integer
public -> person	person_key	integer
	date_entered	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)
	description_of_work	character varying(256)
	contact_next_visit	character varying(256)
public -> institution	institution_key	integer
	begin_date_of_visit	integer
	end_date_of_visit	integer
	survey_number	integer

Tables referencing this one via Foreign Key Constraints:

public.log_collection
public.storage_unit_log

Index - Schema public

Table: public.documentary_instance

public.documentary_instance Structure
F-Key	Name	Type	Description
	doc_inst_key	integer	NOT NULL PRIMARY KEY default nextval('doc_inst_seq'::text)
	preferred_title	character varying(256)
	statement_of_responsibilty	character varying(256)
	edition_statement	character varying(256)
	place_of_publication	character varying(80)
	publisher	character varying(80)
	publication_year	character varying(80)
	publication_year_circa	integer
	series_statement	character varying(80)
	physical_description_form	character varying(80)
	physical_description_extent	character varying(80)
	identifier	character varying(80)
	source_identifier	character varying(80)
	location	character varying(256)
	cdi_location	character varying(80)
public -> work	work_id	integer
public -> institution	institution_id	integer
	descriptive_note	character varying(512)

Tables referencing this one via Foreign Key Constraints:

public.alternative_title
public.person_doc_inst

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.documentary_instance
public.institution_work
public.person_institution
public.project_institution

Index - Schema public

Table: public.institution_work

public.institution_work Structure
F-Key	Name	Type	Description
public -> institution	institution_id	integer
public -> work	work_id	integer

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.notes

public.notes Structure
Name	Type	Description
notes_key	integer	NOT NULL PRIMARY KEY default nextval('notes_seq'::text)
number	character varying(32)
contents	character varying(1024)

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(512)
	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
	extent	character varying(50)
	actions_needed	character varying(200)
	object_number	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_created_work
public.person_doc_inst
public.person_in_work
public.person_institution
public.person_project

Index - Schema public

Table: public.person_created_work

public.person_created_work Structure
F-Key	Name	Type
public -> person	person_id	integer
public -> work	work_id	integer
	role	character varying(80)
	docorder	character varying(80)

Index - Schema public

Table: public.person_doc_inst

public.person_doc_inst Structure
F-Key	Name	Type
public -> person	person_id	integer
public -> documentary_instance	doc_inst_id	integer
	role	character varying(80)
	docorder	character varying(80)

Index - Schema public

Table: public.person_in_work

public.person_in_work Structure
F-Key	Name	Type	Description
public -> person	person_id	integer
public -> work	work_id	integer

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)
	notes	character varying(512)

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	integer
end_fieldwork	integer

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)
	role	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)
	copyright_information	character varying(256)
public -> collection	collection_key	integer
	action_date	integer
	unit_number	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

Table: public.work

public.work Structure
Name	Type	Description
work_key	integer	NOT NULL PRIMARY KEY default nextval('work_seq'::text)
work_identifier	character varying(80)
preferred_title	character varying(256)
creation_year1	character varying(32)
creation_year1_circa	integer
cdi_location	character varying(256)
descriptive_note	character varying(512)

Tables referencing this one via Foreign Key Constraints:

public.alternative_title
public.documentary_instance
public.institution_work
public.person_created_work
public.person_in_work
public.work_work
public.work_work

Index - Schema public

Table: public.work_work

public.work_work Structure
F-Key	Name	Type	Description
public -> work	work1_id	integer
public -> work	work2_id	integer

Index - Schema public

W3C HTML 4.01 Strict