db_venik

Table: autre_cru_geno

Schema

public

Owner

albenard

Tablespace

(default)

Descriptions

Depuis le 27 mai 2008, cette table contient tous les éléments de cru_geno et cru_clone_geno.

Columns

Foreign Keys

Check Constraints

There are no check constraints for table autre_cru_geno

Indices

Triggers

There are no triggers for table autre_cru_geno

Rules

There are no rules for table autre_cru_geno

Policies

There are no policies for table autre_cru_geno

Referenced

Properties

Definition

CREATE TABLE public.autre_cru_geno (
 idgeno_autre_cru INTEGER NOT NULL,
 idcru_autre_cru INTEGER NOT NULL,
 idlieu_croisement INTEGER,
 idlc_protection_fleur INTEGER,
 idcru_pere INTEGER,
 idlot_pollen_pere INTEGER,
 idgeno_pere INTEGER,
 idlc_pose_pollen INTEGER,
 idlc_induction_mere INTEGER,
 idlc_environnement INTEGER,
 annee_croisement INTEGER,
 mois_croisement INTEGER,
 nb_sac_pose INTEGER,
 reussite_croisement VARCHAR(15),
 recup_nom_geno VARCHAR(50),
 idgeno_mere INTEGER,
 idcru_mere INTEGER,
 autre_lieu VARCHAR(128),
 commentaire TEXT,
 idlieu_ramet INTEGER,
 porte_greffe_clone VARCHAR(128),
 nom_cru VARCHAR(30) NOT NULL,
 CONSTRAINT autre_cru_geno_idgeno_autre_cru_key UNIQUE(idgeno_autre_cru, nom_cru),
 CONSTRAINT autre_cru_geno_pkey PRIMARY KEY(idgeno_autre_cru, idcru_autre_cru),
 CONSTRAINT fk_autre_cru_lieu_croisement FOREIGN KEY (idlieu_croisement)
   REFERENCES public.lieu(idlieu)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT fk_environnement FOREIGN KEY (idlc_environnement)
   REFERENCES public.donnees_liste_classique(id_lc)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT fk_induction_mere FOREIGN KEY (idlc_induction_mere)
   REFERENCES public.donnees_liste_classique(id_lc)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT fk_pose_pollen FOREIGN KEY (idlc_pose_pollen)
   REFERENCES public.donnees_liste_classique(id_lc)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT fk_protection_fleur FOREIGN KEY (idlc_protection_fleur)
   REFERENCES public.donnees_liste_classique(id_lc)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT idgeno FOREIGN KEY (idgeno_autre_cru)
   REFERENCES public.genotype(idgeno)
   ON DELETE RESTRICT
   ON UPDATE RESTRICT
   NOT DEFERRABLE,
 CONSTRAINT lieu_ramet FOREIGN KEY (idlieu_ramet)
   REFERENCES public.lieu(idlieu)
   ON DELETE RESTRICT
   ON UPDATE RESTRICT
   NOT DEFERRABLE,
 CONSTRAINT mere FOREIGN KEY (idgeno_mere, idcru_mere)
   REFERENCES public.autre_cru_geno(idgeno_autre_cru, idcru_autre_cru)
   ON DELETE RESTRICT
   ON UPDATE RESTRICT
   NOT DEFERRABLE,
 CONSTRAINT pere FOREIGN KEY (idgeno_pere, idcru_pere)
   REFERENCES public.autre_cru_geno(idgeno_autre_cru, idcru_autre_cru)
   ON DELETE RESTRICT
   ON UPDATE RESTRICT
   NOT DEFERRABLE,
 CONSTRAINT pollen FOREIGN KEY (idlot_pollen_pere)
   REFERENCES public.pollen(idlot_pollen)
   ON DELETE RESTRICT
   ON UPDATE RESTRICT
   NOT DEFERRABLE
) ;

COMMENT ON TABLE public.autre_cru_geno
IS 'Depuis le 27 mai 2008, cette table contient tous les éléments de cru_geno et cru_clone_geno.';

COMMENT ON COLUMN public.autre_cru_geno.idlieu_croisement
IS 'Pour Desc (PF 202, Poly 204, Pater 206)';

COMMENT ON COLUMN public.autre_cru_geno.idcru_pere
IS 'Pour Desc (PF 202, Poly 204, Pater 206)';

COMMENT ON COLUMN public.autre_cru_geno.idlot_pollen_pere
IS 'Pour Desc (PF 202, Poly 204, Pater 206)';

COMMENT ON COLUMN public.autre_cru_geno.idgeno_pere
IS 'Pour Desc (PF 202, Poly 204, Pater 206)';

COMMENT ON COLUMN public.autre_cru_geno.idgeno_mere
IS 'pour Desc  et clones. Repris de cru_geno';

COMMENT ON COLUMN public.autre_cru_geno.idcru_mere
IS 'pour Desc  et clones. Repris de cru_geno';

COMMENT ON COLUMN public.autre_cru_geno.autre_lieu
IS 'pour Desc  et clones. Repris de cru_geno';

COMMENT ON COLUMN public.autre_cru_geno.commentaire
IS 'pour Desc  et clones. Repris de cru_geno';

COMMENT ON COLUMN public.autre_cru_geno.idlieu_ramet
IS 'pour clones (204 et 205)';

COMMENT ON COLUMN public.autre_cru_geno.porte_greffe_clone
IS 'pour clones (204 et 205)';

COMMENT ON COLUMN public.autre_cru_geno.nom_cru
IS 'Ajout le 10-2008 pour donner un nom plus parlant. not null et unique avec idgeno_autre_cru';

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