Dumped on 2004-4-20.

Index of database - xwomen041504

Table: public.alternative_heading

public.alternative_heading Structure
F-Key Name Type Description
althead_id integerNOT NULL PRIMARY KEY default nextval('althead_seq'::text)
heading character varying(256)
public -> theme_one theme_one_id integer
public -> theme_two theme_two_id integer

Index - Schema public

Table: public.documentary_instance

public.documentary_instance Structure
F-Key Name Type Description
di_id integerNOT NULL PRIMARY KEY default nextval('manifest_seq'::text)
state_of_respon character varying(256)
edition character varying(256)
place_of_publication character varying(80)
publisher character varying(80)
date_of_publication integer
series_statement character varying(256)
physical_desc_form character varying(80)
physical_desc_extent character varying(80)
physical_desc_dimensions character varying(80)
descriptive_note character varying(256)
di_identifier character varying(80)
source_identifier character varying(80)
location character varying(256)
location_type character varying(80)
alt_title character varying(80)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: public.eo_pk_table

public.eo_pk_table Structure
F-Key Name Type Description
name character(256)
pk integer

Index - Schema public

Table: public.names

public.names Structure
F-Key Name Type Description
name_id integerNOT NULL PRIMARY KEY default nextval('name_seq'::text)
public -> person person_id integer
chinese character varying(256)
romanized character varying(256)
english character varying(256)
start_date integer
start_place integer
end_date integer
desc_note text
prim_name integerdefault 0
pinyin character varying(256)
wade_giles character varying(256)
other character varying(256)

Index - Schema public

Table: public.person

public.person Structure
F-Key Name Type Description
person_id integerNOT NULL PRIMARY KEY default nextval('person_seq'::text)
birth_date integer
death_date integer
desc_note text
ethnic_race character varying(80)
social_status character varying(80)
sex character(1)
name_id integer
source text

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: public.person_di

public.person_di Structure
F-Key Name Type Description
public -> person person_id integer
public -> documentary_instance di_id integer

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_work_about

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

Index - Schema public

Table: public.person_work_created

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

Index - Schema public

Table: public.related_one_one

public.related_one_one Structure
F-Key Name Type Description
public -> theme_one theme_id_one integer
public -> theme_one theme_id_two integer

Index - Schema public

Table: public.related_one_two

public.related_one_two Structure
F-Key Name Type Description
public -> theme_one theme_id_one integer
public -> theme_two theme_id_two integer

Index - Schema public

Table: public.related_two_two

public.related_two_two Structure
F-Key Name Type Description
public -> theme_two theme_id_one integer
public -> theme_two theme_id_two integer

Index - Schema public

Table: public.theme_one

public.theme_one Structure
F-Key Name Type Description
theme_id integerNOT NULL PRIMARY KEY default nextval('theme_seq'::text)
heading character varying(256)
description character varying(512)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: public.theme_one_sub_theme

public.theme_one_sub_theme Structure
F-Key Name Type Description
public -> theme_one theme_one_id integer
public -> theme_two theme_two_id integer

Index - Schema public

Table: public.theme_one_work

public.theme_one_work Structure
F-Key Name Type Description
public -> theme_one theme_id integer
public -> work work_id integer

Index - Schema public

Table: public.theme_two

public.theme_two Structure
F-Key Name Type Description
theme_id integerNOT NULL PRIMARY KEY default nextval('theme_seq'::text)
heading character varying(256)
description character varying(256)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: public.theme_two_work

public.theme_two_work Structure
F-Key Name Type Description
public -> theme_two theme_id integer
public -> work work_id integer

Index - Schema public

Table: public.title

public.title Structure
F-Key Name Type Description
title_id integerNOT NULL PRIMARY KEY default nextval('work_seq'::text)
title character varying(80)
preferred_title integerdefault 0
language character varying(32)
public -> work work_id integer
public -> documentary_instance doc_instance_id integer

Index - Schema public

Table: public.union_child

public.union_child Structure
F-Key Name Type Description
uc_id integerNOT NULL PRIMARY KEY default nextval('uc_seq'::text)
public -> person person_id integer
public -> unions union_id integer
birth_order integer

Index - Schema public

Table: public.union_parent

public.union_parent Structure
F-Key Name Type Description
up_id integerNOT NULL PRIMARY KEY default nextval('up_seq'::text)
public -> person person_id integer
public -> unions union_id integer
parent_type character varying(80)

Index - Schema public

Table: public.unions

public.unions Structure
F-Key Name Type Description
union_id integerNOT NULL PRIMARY KEY default nextval('union_seq'::text)
start_date integer
start_place integer
pri_residence character varying(256)
end_date integer
mother_status character varying(80)
desc_note text

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: public.work

public.work Structure
F-Key Name Type Description
work_id integerNOT NULL PRIMARY KEY default nextval('work_seq'::text)
work_identifier character varying(80)
creation_date integer
role character varying(80)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: public.work_di

public.work_di Structure
F-Key Name Type Description
public -> work work_id integer
public -> documentary_instance di_id integer

Index - Schema public

Table: public.work_in_work

public.work_in_work Structure
F-Key Name Type Description
public -> work work_id_one integer
public -> work work_id_two integer

Index - Schema public

W3C HTML 4.01 Strict