Schema
Owner
albenard
Tablespace
(default)
Descriptions
There is no description for table pays_ref
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
idpays |
serial |
|
nextval('pays_ref_idpays_seq'::regclass) |
|
|||
|
|
nom_unique |
varchar(128) |
|
|
|
||
|
|
abreviation |
varchar(20) |
|
|
|
||
|
|
latitude_haute |
numeric |
|
|
|
|
|
|
|
latitude_basse |
numeric |
|
|
|
|
|
|
|
longitude_gauche |
numeric |
|
|
|
|
|
|
|
longitude_droite |
numeric |
|
|
|
|
|
|
|
commentaire |
text |
|
|
|
|
|
|
|
date_creation |
date |
|
|
|
|
|
|
|
date_maj |
date |
|
|
|
|
|
|
|
ns_haut |
varchar(1) |
|
|
|
|
|
|
|
ns_bas |
varchar(1) |
|
|
|
|
|
|
|
eo_gauche |
varchar(1) |
|
|
|
|
|
|
|
eo_droite |
varchar(1) |
|
|
|
|
|
|
|
pays_crb32 |
varchar(10) |
|
|
|
|
Code alpha utilisé par le bureau des ressources genetiques pour l identification internationale. |
Foreign Keys
There are no foreign keys for table pays_ref
Check Constraints
There are no check constraints for table pays_ref
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
btree |
|
abreviation |
|
|
||
btree |
|
nom_unique |
|
|
||
btree |
|
idpays |
|
Triggers
There are no triggers for table pays_ref
Rules
There are no rules for table pays_ref
Policies
There are no policies for table pays_ref
Referenced
Table | Schema | Foreign Key | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|---|---|
idpays |
idpays |
No Action |
No Action |
|
Immediate |
|
||||
idpays |
idpays |
No Action |
No Action |
|
Immediate |
|
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
58 |
Pages |
1 |
System |
|
Temporary |
|
With OID |
Definition
CREATE TABLE public.pays_ref (
idpays SERIAL,
nom_unique VARCHAR(128) NOT NULL,
abreviation VARCHAR(20) NOT NULL,
latitude_haute NUMERIC,
latitude_basse NUMERIC,
longitude_gauche NUMERIC,
longitude_droite NUMERIC,
commentaire TEXT,
date_creation DATE,
date_maj DATE,
ns_haut VARCHAR(1),
ns_bas VARCHAR(1),
eo_gauche VARCHAR(1),
eo_droite VARCHAR(1),
pays_crb32 VARCHAR(10),
CONSTRAINT pays_ref_abreviation_key UNIQUE(abreviation),
CONSTRAINT pays_ref_nom_unique_key UNIQUE(nom_unique),
CONSTRAINT pk_pays_ref PRIMARY KEY(idpays)
) ;
COMMENT ON COLUMN public.pays_ref.pays_crb32
IS 'Code alpha utilisé par le bureau des ressources genetiques pour l identification internationale.';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) |