pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr |
|
Table: tr_synonym_syn
pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr |
|
Table: tr_synonym_syn
Schema
Owner
ychaval
Tablespace
(default)
Descriptions
Management of synonymy
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
syn_id |
serial |
|
|
|
nextval('para_phy.tr_synonym_syn_syn_id_seq'::regclass) |
ID of the synonymy |
|
|
syn_former_etiq |
text |
|
|
|
|
former ani_etiq |
|
|
syn_ani_etiq |
text |
|
|
|
|
new ani_etiq |
Foreign Keys
There are no foreign keys for table tr_synonym_syn
Check Constraints
There are no check constraints for table tr_synonym_syn
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
syn_id |
|
|
|
Triggers
There are no triggers for table tr_synonym_syn
Rules
There are no rules for table tr_synonym_syn
Policies
There are no policies for table tr_synonym_syn
Referenced
There are no tables referenced by table tr_synonym_syn
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
syn_id SERIAL,
syn_former_etiq TEXT NOT NULL,
syn_ani_etiq TEXT,
CONSTRAINT tr_synonym_syn_pkey PRIMARY KEY(syn_id)
)
WITH (oids = false);
COMMENT ON TABLE para_phy.tr_synonym_syn
IS 'Management of synonymy';
COMMENT ON COLUMN para_phy.tr_synonym_syn.syn_id
IS 'ID of the synonymy';
COMMENT ON COLUMN para_phy.tr_synonym_syn.syn_former_etiq
IS 'former ani_etiq';
COMMENT ON COLUMN para_phy.tr_synonym_syn.syn_ani_etiq
IS 'new ani_etiq';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23 |
|