pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr
Previous topic Chapter index Next topic

Table: tr_analysis_counting_cnt

 

 

Schema

para_phy

 

Owner

ychaval

 

Tablespace

(default)

 

Descriptions

Table containing the counting method used for parasites detection

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

cnt_id

serial

 

nextval('para_phy.tr_analysis_counting_cnt_cnt_id_seq'::regclass)

Counting id

 

 

cnt_analysis_type

text

 

 

Short description of the analysis

 

 

cnt_analysis_describe

text

 

 

 

 

More explicit description of the analysis

 

Foreign Keys

There are no foreign keys for table tr_analysis_counting_cnt

 

Check Constraints

There are no check constraints for table tr_analysis_counting_cnt

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

tr_analysis_counting_cnt_cnt_analysis_type_key

btree

 

cnt_analysis_type

 

 

tr_analysis_counting_cnt_pkey

btree

 

cnt_id

 

 

Triggers

There are no triggers for table tr_analysis_counting_cnt

 

Rules

There are no rules for table tr_analysis_counting_cnt

 

Policies

There are no policies for table tr_analysis_counting_cnt

 

Referenced

Table

Schema

Foreign Key

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

t_parasitology_para

para_phy

t_parasitology_para_fkey7

para_cnt_id

para_phy.tr_analysis_counting_cnt

cnt_id

No Action

No Action

 

Immediate

 

 

Properties

Property

Value

Inherited From

 

Rows

3

Pages

1

System

 

Temporary

 

With OID

 

 

Definition

CREATE TABLE para_phy.tr_analysis_counting_cnt (
 cnt_id SERIAL,
 cnt_analysis_type TEXT NOT NULL,
 cnt_analysis_describe TEXT,
 CONSTRAINT tr_analysis_counting_cnt_cnt_analysis_type_key UNIQUE(cnt_analysis_type),
 CONSTRAINT tr_analysis_counting_cnt_pkey PRIMARY KEY(cnt_id)
)
WITH (oids = false);

COMMENT ON TABLE para_phy.tr_analysis_counting_cnt
IS 'Table containing the counting method used for parasites detection';

COMMENT ON COLUMN para_phy.tr_analysis_counting_cnt.cnt_id
IS 'Counting id';

COMMENT ON COLUMN para_phy.tr_analysis_counting_cnt.cnt_analysis_type
IS 'Short description of the analysis';

COMMENT ON COLUMN para_phy.tr_analysis_counting_cnt.cnt_analysis_describe
IS 'More explicit description of the analysis';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23
Previous topic Chapter index Next topic