db_venik

Table: pollen

Schema

public

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

Foreign Keys

Check Constraints

There are no check constraints for table pollen

Indices

Triggers

There are no triggers for table pollen

Rules

There are no rules for table pollen

Policies

There are no policies for table pollen

Referenced

Properties

Definition

CREATE TABLE public.pollen (
 idlot_pollen SERIAL,
 idlieu_recolte_p INTEGER,
 idcru INTEGER,
 idgeno_p INTEGER,
 idespece INTEGER NOT NULL,
 annee INTEGER NOT NULL,
 nom_lot VARCHAR(128),
 nom_court VARCHAR(15) NOT NULL,
 date_creation DATE,
 date_maj DATE,
 recoltant_exp VARCHAR(128),
 recup_nom_lieu VARCHAR(50),
 recup_nom_geno VARCHAR(50),
 recup_pollen VARCHAR(50),
 recup_code_espece VARCHAR(50),
 recup_com1 TEXT,
 recup_com2 TEXT,
 autre_lieu VARCHAR(128),
 commentaire TEXT,
 nb_lots INTEGER,
 iduser INTEGER,
 CONSTRAINT pk_pollen PRIMARY KEY(idlot_pollen),
 CONSTRAINT pollen_annee_key UNIQUE(annee, nom_court),
 CONSTRAINT fk_pollen_espece FOREIGN KEY (idespece)
   REFERENCES public.espece(idespece)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT fk_pollen_genotype FOREIGN KEY (idgeno_p)
   REFERENCES public.genotype(idgeno)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT fk_pollen_iduser FOREIGN KEY (iduser)
   REFERENCES public.utilisateur(iduser)
   ON DELETE RESTRICT
   ON UPDATE RESTRICT
   NOT DEFERRABLE,
 CONSTRAINT fk_pollen_lieu FOREIGN KEY (idlieu_recolte_p)
   REFERENCES public.lieu(idlieu)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT idgeno_idcru FOREIGN KEY (idgeno_p, idcru)
   REFERENCES public.autre_cru_geno(idgeno_autre_cru, idcru_autre_cru)
   ON DELETE RESTRICT
   ON UPDATE RESTRICT
   NOT DEFERRABLE
) ;

COMMENT ON TABLE public.pollen
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.pollen.nb_lots
IS 'HVS ajout pour faciliter la getion des melanges : nb de lots prevus';

COMMENT ON COLUMN public.pollen.iduser
IS '12-10-2007 tracabiltté';

CREATE INDEX fki_pollen_iduser ON public.pollen
 USING btree (iduser);

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com)