db_globoxylo |
|
Table: t_sample_sam
db_globoxylo |
|
Table: t_sample_sam
Schema
Owner
postgres
Tablespace
(default)
Descriptions
Sample table
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
sam_id |
serial |
|
|
|
nextval('t_sample_sam_sam_id_seq'::regclass) |
digital automatic identifier of the sample |
|
|
sam_tre_id |
integer |
|
|
|
|
digital automatic identifier of the tree from which the sample comes |
|
|
sam_code |
varchar(16) |
|
|
|
|
Sample code (unique for the tree of provenance) |
|
|
sam_date |
date |
|
|
|
|
Date of sample collection |
|
|
sam_note |
varchar(255) |
|
|
|
|
general remark concerning the sample |
Foreign Keys
Name | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
sam_tre_id |
tre_id |
No Action |
No Action |
|
Immediate |
|
Check Constraints
There are no check constraints for table t_sample_sam
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
sam_tre_id, sam_code |
|
|
The tree identifier / sample code pair is unique |
|
btree |
|
sam_id |
|
|
|
Triggers
There are no triggers for table t_sample_sam
Rules
There are no rules for table t_sample_sam
Policies
There are no policies for table t_sample_sam
Referenced
Table | Schema | Foreign Key | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
msam_sam_id |
sam_id |
No Action |
No Action |
|
Immediate |
a measure must be attached to one and only one object |
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
-1 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
sam_id SERIAL,
sam_tre_id INTEGER NOT NULL,
sam_code VARCHAR(16) NOT NULL,
sam_date DATE,
sam_note VARCHAR(255),
CONSTRAINT c_uni_tre_code_ech UNIQUE(sam_tre_id, sam_code),
CONSTRAINT t_sample_sam_pkey PRIMARY KEY(sam_id),
CONSTRAINT c_fk_tre_ech FOREIGN KEY (sam_tre_id)
REFERENCES public.t_tree_tre(tre_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.t_sample_sam
IS 'Sample table';
COMMENT ON COLUMN public.t_sample_sam.sam_id
IS 'digital automatic identifier of the sample';
COMMENT ON COLUMN public.t_sample_sam.sam_tre_id
IS 'digital automatic identifier of the tree from which the sample comes';
COMMENT ON COLUMN public.t_sample_sam.sam_code
IS 'Sample code (unique for the tree of provenance)';
COMMENT ON COLUMN public.t_sample_sam.sam_date
IS 'Date of sample collection';
COMMENT ON COLUMN public.t_sample_sam.sam_note
IS 'general remark concerning the sample';
COMMENT ON CONSTRAINT c_uni_tre_code_ech ON public.t_sample_sam
IS 'The tree identifier / sample code pair is unique';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) |
|