Dumped on 2003-12-11

Index of database - zope3


Table: additional_sample_data

additional_sample_data Structure
F-Key Name Type Description
additional_sample_data_id serial PRIMARY KEY
sample.sample_id sample_id integer
key character varying(50) NOT NULL
value character varying(50)

Index - Schema public


Table: aliquot

aliquot Structure
F-Key Name Type Description
aliquot_id serial PRIMARY KEY
project.project_id project_id integer
sample.sample_id sample_id integer
volume_unit.volume_unit_id volume_id integer
weight_unit.weight_unit_id weight_id integer
concentration_unit.concentration_unit_id concentration_id integer
container.container_id container_id integer
volume numeric(9,3)
weight numeric(9,3)
concentration numeric(9,3)
depleted boolean NOT NULL
date date NOT NULL
commit_message text NOT NULL

Index - Schema public


Table: concentration_unit

concentration_unit Structure
F-Key Name Type Description
concentration_unit_id serial PRIMARY KEY
label character varying(255) NOT NULL
description character varying(255) NOT NULL
exponent numeric(26,20) NOT NULL
start_date date NOT NULL
end_date date
commit_message text NOT NULL

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: container

container Structure
F-Key Name Type Description
container_id serial PRIMARY KEY
name character varying(255) NOT NULL
container.container_id parent_id integer
location.location_id location_id integer
container_type.container_type_id type_id integer
commit_message text NOT NULL

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: container_type

container_type Structure
F-Key Name Type Description
container_type_id serial PRIMARY KEY
name character varying(255) NOT NULL
start_date date NOT NULL
end_date date
root boolean NOT NULL
commit_message text NOT NULL

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: location

location Structure
F-Key Name Type Description
location_id serial PRIMARY KEY
name character varying(255) NOT NULL
building character varying(255)
room character varying(255)
temperature integer
start_date date NOT NULL
end_date date
commit_message text NOT NULL

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: location_project

location_project Structure
F-Key Name Type Description
location_project_id serial PRIMARY KEY
project.project_id project_id integer
location.location_id location_id integer

Index - Schema public


Table: principal

principal Structure
F-Key Name Type Description
principal_id serial PRIMARY KEY
username text NOT NULL
fullname text
password text NOT NULL

Index - Schema public


Table: project

project Structure
F-Key Name Type Description
project_id serial PRIMARY KEY
name character varying(20) NOT NULL
commit_message text NOT NULL
start_date date NOT NULL
end_date date
require_commit_message boolean

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: sample

sample Structure
F-Key Name Type Description
sample_id serial PRIMARY KEY
name character varying(255)
other_id character varying(255)
date_generated date NOT NULL
comments text
subject_id character varying(255)
project.project_id project_id integer
sample_type.sample_type_id type_id integer
technician.technician_id technician_id integer
subject_type character varying(255)
derived boolean NOT NULL
commit_message text NOT NULL

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: sample_type

sample_type Structure
F-Key Name Type Description
sample_type_id serial PRIMARY KEY
name character varying(20) NOT NULL
schema_id character varying(255) NOT NULL
project.project_id project_id integer
start_date date NOT NULL
end_date date
commit_message text NOT NULL

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: sample_type_field

sample_type_field Structure
F-Key Name Type Description
sample_type_field_id serial PRIMARY KEY
name character varying(50) NOT NULL
description character varying(50) NOT NULL
sample_type.sample_type_id type_id integer
identifier character varying(50) NOT NULL
required boolean NOT NULL

Index - Schema public


Table: security_principal

security_principal Structure
F-Key Name Type Description
id serial PRIMARY KEY
principal_id character varying(255) NOT NULL
role_id character varying(255)
location character varying(255) NOT NULL
value integer NOT NULL

Index - Schema public


Table: security_role

security_role Structure
F-Key Name Type Description
id serial PRIMARY KEY
role_id character varying(255) NOT NULL
principal_id character varying(255)
location character varying(255) NOT NULL
value integer NOT NULL

Index - Schema public


Table: technician

technician Structure
F-Key Name Type Description
technician_id serial PRIMARY KEY
username character varying(50) NOT NULL
fullname character varying(255)
start_date date NOT NULL
end_date date
commit_message text NOT NULL

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: technician_project

technician_project Structure
F-Key Name Type Description
technician_project_id serial PRIMARY KEY
project.project_id project_id integer
technician.technician_id technician_id integer

Index - Schema public


Table: volume_unit

volume_unit Structure
F-Key Name Type Description
volume_unit_id serial PRIMARY KEY
label character varying(255) NOT NULL
description character varying(255) NOT NULL
exponent numeric(26,20) NOT NULL
start_date date NOT NULL
end_date date
commit_message text NOT NULL

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: weight_unit

weight_unit Structure
F-Key Name Type Description
weight_unit_id serial PRIMARY KEY
label character varying(255) NOT NULL
description character varying(255) NOT NULL
exponent numeric(26,20) NOT NULL
start_date date NOT NULL
end_date date
commit_message text NOT NULL

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Generated by PostgreSQL Autodoc

W3C HTML 4.01 Strict