Schema
Owner
albenard
Tablespace
(default)
Descriptions
aout 2008. Suite a modification de tables pour les crus, suppression de la laison avec cru_geno, et mis liaison avec autre_cru_geno.
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
idlot_gr |
serial |
|
nextval('graine_idlot_gr_seq'::regclass) |
|
|||
|
idcru |
integer |
|
|
|
|
|
|
|
idespece |
integer |
|
|
|
|
||
|
idgeno_gr |
integer |
|
|
|
|
|
|
|
idlieu_recolte_gr |
integer |
|
|
|
|
|
|
|
|
annee |
integer |
|
|
|
|
|
|
|
nom_lot |
varchar(128) |
|
|
|
|
|
|
|
nom_court |
varchar(15) |
|
|
|
|
|
|
|
date_creation |
date |
|
|
|
|
|
|
|
date_maj |
date |
|
|
|
|
|
|
|
recoltant_exp |
varchar(100) |
|
|
|
|
|
|
|
recup_ch |
varchar(50) |
|
|
|
|
|
|
|
recup_code_espece |
varchar(50) |
|
|
|
|
|
|
|
recup_nom_lieu |
varchar(50) |
|
|
|
|
|
|
|
recup_nom_geno |
varchar(50) |
|
|
|
|
|
|
|
commentaire |
text |
|
|
|
|
|
|
|
idgeno_cru |
integer |
|
|
|
|
|
|
|
nb_lots |
integer |
|
|
|
|
HVS il peut y avoir des melanges dont les constituants ne sont pas indiques. |
|
|
certificat_maitre |
varchar(30) |
|
|
|
|
10-10-2007. Numero ou code pour les recoltes sur materiel homologué. |
|
iduser |
integer |
|
|
|
|
12-10-2007 tracabiltté |
Foreign Keys
Name | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|
idespece |
idespece |
No Action |
No Action |
|
Immediate |
|
||
idgeno_gr |
idgeno |
No Action |
No Action |
|
Immediate |
|
||
iduser |
iduser |
Restrict |
Restrict |
|
Immediate |
|
||
idlieu_recolte_gr |
idlieu |
No Action |
No Action |
|
Immediate |
|
||
idgeno_gr, idcru |
idgeno_autre_cru, idcru_autre_cru |
Restrict |
Restrict |
|
Immediate |
|
Check Constraints
There are no check constraints for table graine
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
btree |
|
iduser |
|
|
|
|
btree |
|
annee, nom_court |
|
|
||
btree |
|
idlot_gr |
|
Triggers
There are no triggers for table graine
Rules
There are no rules for table graine
Policies
There are no policies for table graine
Referenced
Table | Schema | Foreign Key | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|---|---|
idlot_gr |
idlot_gr |
No Action |
No Action |
|
Immediate |
|
||||
idlot_gr |
idlot_gr |
No Action |
No Action |
|
Immediate |
|
||||
idmelange |
idlot_gr |
No Action |
No Action |
|
Immediate |
|
||||
idlot_gr |
idlot_gr |
No Action |
No Action |
|
Immediate |
|
||||
idlot_gr |
idlot_gr |
No Action |
No Action |
|
Immediate |
|
||||
idlot_gr |
idlot_gr |
No Action |
No Action |
|
Immediate |
|
||||
idlot_gr |
idlot_gr |
No Action |
No Action |
|
Immediate |
|
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
13226 |
Pages |
178 |
System |
|
Temporary |
|
With OID |
Definition
CREATE TABLE public.graine (
idlot_gr SERIAL,
idcru INTEGER,
idespece INTEGER NOT NULL,
idgeno_gr INTEGER,
idlieu_recolte_gr INTEGER,
annee INTEGER NOT NULL,
nom_lot VARCHAR(128),
nom_court VARCHAR(15) NOT NULL,
date_creation DATE,
date_maj DATE,
recoltant_exp VARCHAR(100),
recup_ch VARCHAR(50),
recup_code_espece VARCHAR(50),
recup_nom_lieu VARCHAR(50),
recup_nom_geno VARCHAR(50),
commentaire TEXT,
idgeno_cru INTEGER,
nb_lots INTEGER,
certificat_maitre VARCHAR(30),
iduser INTEGER,
CONSTRAINT graine_annee_key UNIQUE(annee, nom_court),
CONSTRAINT pk_graine PRIMARY KEY(idlot_gr),
CONSTRAINT fk_graine_espece FOREIGN KEY (idespece)
REFERENCES public.espece(idespece)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT fk_graine_genotype FOREIGN KEY (idgeno_gr)
REFERENCES public.genotype(idgeno)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT fk_graine_iduser FOREIGN KEY (iduser)
REFERENCES public.utilisateur(iduser)
ON DELETE RESTRICT
ON UPDATE RESTRICT
NOT DEFERRABLE,
CONSTRAINT fk_graine_lieu FOREIGN KEY (idlieu_recolte_gr)
REFERENCES public.lieu(idlieu)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT idgeno_idcru FOREIGN KEY (idgeno_gr, idcru)
REFERENCES public.autre_cru_geno(idgeno_autre_cru, idcru_autre_cru)
ON DELETE RESTRICT
ON UPDATE RESTRICT
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.graine
IS 'aout 2008. Suite a modification de tables pour les crus, suppression de la laison avec cru_geno, et mis liaison avec autre_cru_geno.';
COMMENT ON COLUMN public.graine.nb_lots
IS 'HVS il peut y avoir des melanges dont les constituants ne sont pas indiques.';
COMMENT ON COLUMN public.graine.certificat_maitre
IS '10-10-2007. Numero ou code pour les recoltes sur materiel homologué.';
COMMENT ON COLUMN public.graine.iduser
IS '12-10-2007 tracabiltté';
CREATE INDEX fki_graine_iduser ON public.graine
USING btree (iduser);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) |