Schema
Owner
albenard
Tablespace
(default)
Descriptions
There is no description for table espece
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
idespece |
serial |
|
nextval('espece_idespece_seq'::regclass) |
|
|||
|
idgenre |
integer |
|
|
|
|
||
|
|
nom |
varchar(100) |
|
|
|
|
|
|
|
mini |
numeric |
|
|
|
|
|
|
|
maxi |
numeric |
|
|
|
|
|
|
|
commentaire |
varchar(500) |
|
|
|
|
|
|
|
date_creation |
date |
|
|
|
|
|
|
|
date_maj |
date |
|
|
|
|
|
|
idespece_pere |
integer |
|
|
|
|
|
|
|
idespece_mere |
integer |
|
|
|
|
|
|
|
|
recup_code |
varchar(50) |
|
|
|
|
|
|
|
code |
varchar(3) |
|
|
|
|
|
|
|
reciproque |
varchar(3) |
|
|
|
|
|
|
|
espece_crb32 |
varchar(10) |
|
|
|
|
Code alpha utilisé par le bureau des ressources genetiques pour l identification internationale. |
Foreign Keys
Name | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|
idespece_pere |
idespece |
No Action |
No Action |
|
Immediate |
|
||
idespece_mere |
idespece |
No Action |
No Action |
|
Immediate |
|
||
idgenre |
idgenre |
No Action |
No Action |
|
Immediate |
|
Check Constraints
There are no check constraints for table espece
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
btree |
|
idgenre, code |
|
|
||
btree |
|
idgenre, nom |
|
|
||
btree |
|
idespece |
|
Triggers
There are no triggers for table espece
Rules
There are no rules for table espece
Policies
There are no policies for table espece
Referenced
Table | Schema | Foreign Key | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|---|---|
idespece_pere |
idespece |
No Action |
No Action |
|
Immediate |
|
||||
idespece_mere |
idespece |
No Action |
No Action |
|
Immediate |
|
||||
idespece |
idespece |
No Action |
No Action |
|
Immediate |
|
||||
idespece |
idespece |
No Action |
No Action |
|
Immediate |
|
||||
idespece |
idespece |
No Action |
No Action |
|
Immediate |
|
||||
idespece |
idespece |
No Action |
No Action |
|
Immediate |
|
||||
idespece |
idespece |
No Action |
No Action |
|
Immediate |
|
||||
idespece |
idespece |
No Action |
No Action |
|
Immediate |
|
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
130 |
Pages |
2 |
System |
|
Temporary |
|
With OID |
Definition
CREATE TABLE public.espece (
idespece SERIAL,
idgenre INTEGER NOT NULL,
nom VARCHAR(100) NOT NULL,
mini NUMERIC,
maxi NUMERIC,
commentaire VARCHAR(500),
date_creation DATE,
date_maj DATE,
idespece_pere INTEGER,
idespece_mere INTEGER,
recup_code VARCHAR(50),
code VARCHAR(3) NOT NULL,
reciproque VARCHAR(3),
espece_crb32 VARCHAR(10),
CONSTRAINT genre_code UNIQUE(idgenre, code),
CONSTRAINT genre_nom UNIQUE(idgenre, nom),
CONSTRAINT pk_espece PRIMARY KEY(idespece),
CONSTRAINT fk_espece_espece FOREIGN KEY (idespece_pere)
REFERENCES public.espece(idespece)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT fk_espece_espece1 FOREIGN KEY (idespece_mere)
REFERENCES public.espece(idespece)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT fk_espece_genre FOREIGN KEY (idgenre)
REFERENCES public.genre(idgenre)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON COLUMN public.espece.espece_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) |