db_toff on pggeodb.nancy.inra.fr |
|
Table: tr_taxonomic_reference_tax
db_toff on pggeodb.nancy.inra.fr |
|
Table: tr_taxonomic_reference_tax
Schema
Owner
postgres
Tablespace
(default)
Descriptions
Table displaying the taxonomic reference / Table contenant les références taxonomiques et leurs versions
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
tax_id |
serial |
|
|
|
nextval('tr_taxonomic_reference_tax_tax_id_seq'::regclass) |
Automatic ID of the taxonomic reference / Identifiant automatique de la référence taxonomique |
|
|
tax_name |
varchar(128) |
|
|
|
|
Taxonomic reference name / Nom de la référence taxonomique |
|
|
tax_version |
varchar(10) |
|
|
|
|
Taxonomic reference version /Version de la référence taxonomique |
|
|
tax_link |
varchar |
|
|
|
|
Optional link to another source of information / Lien éventuel vers une information en ligne associée à la référence taxonomique |
Foreign Keys
There are no foreign keys for table tr_taxonomic_reference_tax
Check Constraints
There are no check constraints for table tr_taxonomic_reference_tax
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
tax_name, tax_version |
|
|
name and version must be unique / le couple nom / version ne peut contenir de doublons |
|
btree |
|
tax_id |
|
|
|
Triggers
There are no triggers for table tr_taxonomic_reference_tax
Rules
There are no rules for table tr_taxonomic_reference_tax
Policies
There are no policies for table tr_taxonomic_reference_tax
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
spe_tax_id |
tax_id |
No Action |
No Action |
|
Immediate |
A species can be related to only one taxonomic reference / Une espèce est rattachée à une et une seule référence taxonomique |
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
tax_id SERIAL,
tax_name VARCHAR(128) NOT NULL,
tax_version VARCHAR(10) NOT NULL,
tax_link VARCHAR,
CONSTRAINT c_uni_name_version_tax UNIQUE(tax_name, tax_version),
CONSTRAINT tr_taxonomic_reference_tax_pkey PRIMARY KEY(tax_id)
)
WITH (oids = false);
COMMENT ON TABLE public.tr_taxonomic_reference_tax
IS 'Table displaying the taxonomic reference / Table contenant les références taxonomiques et leurs versions';
COMMENT ON COLUMN public.tr_taxonomic_reference_tax.tax_id
IS 'Automatic ID of the taxonomic reference / Identifiant automatique de la référence taxonomique';
COMMENT ON COLUMN public.tr_taxonomic_reference_tax.tax_name
IS 'Taxonomic reference name / Nom de la référence taxonomique';
COMMENT ON COLUMN public.tr_taxonomic_reference_tax.tax_version
IS 'Taxonomic reference version /Version de la référence taxonomique';
COMMENT ON COLUMN public.tr_taxonomic_reference_tax.tax_link
IS 'Optional link to another source of information / Lien éventuel vers une information en ligne associée à la référence taxonomique';
COMMENT ON CONSTRAINT c_uni_name_version_tax ON public.tr_taxonomic_reference_tax
IS 'name and version must be unique / le couple nom / version ne peut contenir de doublons';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 19/06/2019 10:17 |
|