Authored by fred.perso


Edited 1.57 KB
  • Le DDL SQL

    NB : Ne contient pas les lignes commentées ci-dessus.

    CREATE TABLE public.sights_placetreedetail (
        id_placetreedetail int4 NOT NULL DEFAULT nextval('sights_placetreedetail_id_placetreedetail_seq'::regclass),
        visit_date date NOT NULL,
        state varchar(10) NOT NULL,
        gite_high int4 NULL,
        gite_tree_diameter numeric(3,1) NULL,
        aqua_dist int4 NULL,
        "comment" text NULL,
        timestamp_create timestamptz NOT NULL,
        timestamp_update timestamptz NOT NULL,
        creator_id int4 NULL,
        interest_id int4 NULL,
        place_id int4 NOT NULL,
        specie_id int4 NULL,
        CONSTRAINT sights_placetreedetail_pkey PRIMARY KEY (id_placetreedetail),
        CONSTRAINT sights_placetreedeta_interest_id_a859b76b_fk_sights_di FOREIGN KEY (interest_id) REFERENCES public.sights_dictinterest(id),
        CONSTRAINT sights_placetreedeta_place_id_1f82bcba_fk_sights_pl FOREIGN KEY (place_id) REFERENCES public.sights_place(id_place),
        CONSTRAINT sights_placetreedeta_specie_id_7eed0be9_fk_sights_di FOREIGN KEY (specie_id) REFERENCES public.sights_dicttreespecies(id),
        CONSTRAINT sights_placetreedetail_creator_id_e997ebe0_fk_auth_user_id FOREIGN KEY (creator_id) REFERENCES public.auth_user(id)
Markdown is supported
0% or
You are about to add 0 people to the discussion. Proceed with caution.
Finish editing this message first!
Please register or to comment