Dumped on 2003-12-11
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
Index -
Schema public
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
Tables referencing this one via Foreign Key Constraints:
Index -
Schema public
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
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
Index -
Schema public
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
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
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
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
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
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
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
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
Index -
Schema public
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
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