Author: bleny Date: 2011-07-04 10:37:10 +0000 (Mon, 04 Jul 2011) New Revision: 1367 Log: more documentation Added: trunk/src/site/resources/database_schema.txt trunk/src/site/rst/common/navires.rst Modified: trunk/src/site/rst/common/utilisateurs.rst trunk/src/site/rst/obsDeb/observateur.rst trunk/src/site/site_fr.xml Added: trunk/src/site/resources/database_schema.txt =================================================================== --- trunk/src/site/resources/database_schema.txt (rev 0) +++ trunk/src/site/resources/database_schema.txt 2011-07-04 10:37:10 UTC (rev 1367) @@ -0,0 +1,832 @@ + + Table « public.boat » + Colonne | Type | Modificateurs +-----------------+-----------------------------+--------------- + topiaid | character varying(255) | non NULL + topiaversion | bigint | non NULL + topiacreatedate | timestamp without time zone | + immatriculation | integer | + name | text | + boatlength | integer | + buildyear | integer | + active | boolean | + shipowner | character varying(255) | + boatdistrict | character varying(255) | + staffsize | double precision | + portofregistry | character varying(255) | + boatgroup | character varying(255) | + fleet | character varying(255) | +Index : + "boat_pkey" PRIMARY KEY, btree (topiaid) + "boat_immatriculation_idx" UNIQUE, btree (immatriculation) + "boat_immatriculation_key" UNIQUE, btree (immatriculation) +Contraintes de clés étrangères : + "boat_boatdistrict_fkey" FOREIGN KEY (boatdistrict) REFERENCES boatdistrict(topiaid) + "boatgroup_fkey" FOREIGN KEY (boatgroup) REFERENCES boatgroup(topiaid) + "fk2e39408e559143" FOREIGN KEY (shipowner) REFERENCES shipowner(topiaid) + "fleet_fkey" FOREIGN KEY (fleet) REFERENCES fleet(topiaid) + "portofregistry_fkey" FOREIGN KEY (portofregistry) REFERENCES terrestriallocation(topiaid) +Référencé par : + TABLE "samplerow" CONSTRAINT "boat_fkey" FOREIGN KEY (boat) REFERENCES boat(topiaid) + TABLE "contact" CONSTRAINT "fk38b7242070b2d8eb" FOREIGN KEY (boat) REFERENCES boat(topiaid) + TABLE "elligibleboat" CONSTRAINT "fk9c3f3a3570b2d8eb" FOREIGN KEY (boat) REFERENCES boat(topiaid) + TABLE "boatinfos" CONSTRAINT "fka23bd02570b2d8eb" FOREIGN KEY (boat) REFERENCES boat(topiaid) + TABLE "activitycalendar" CONSTRAINT "fkc0e4d36d70b2d8eb" FOREIGN KEY (boat) REFERENCES boat(topiaid) + +Index « public.boat_immatriculation_idx » + Colonne | Type +-----------------+--------- + immatriculation | integer +unique, btree, pour la table « public.boat » + +Index « public.boat_immatriculation_key » + Colonne | Type +-----------------+--------- + immatriculation | integer +unique, btree, pour la table « public.boat » + + Index « public.boat_pkey » + Colonne | Type +---------+------------------------ + topiaid | character varying(255) +clé primaire, btree, pour la table « public.boat » + + Table « public.boatdistrict » + Colonne | Type | Modificateurs +-----------------+-----------------------------+--------------- + topiaid | character varying(255) | non NULL + topiaversion | bigint | non NULL + topiacreatedate | timestamp without time zone | non NULL + code | character varying(10) | non NULL + name | text | + latitude | double precision | + longitude | double precision | +Index : + "boatdistrict_pkey" PRIMARY KEY, btree (topiaid) + "boatdistrict_code_key" UNIQUE, btree (code) +Référencé par : + TABLE "boat" CONSTRAINT "boat_boatdistrict_fkey" FOREIGN KEY (boatdistrict) REFERENCES boatdistrict(topiaid) + +Index « public.boatdistrict_code_key » + Colonne | Type +---------+----------------------- + code | character varying(10) +unique, btree, pour la table « public.boatdistrict » + +Index « public.boatdistrict_pkey » + Colonne | Type +---------+------------------------ + topiaid | character varying(255) +clé primaire, btree, pour la table « public.boatdistrict » + + Table « public.boatgroup » + Colonne | Type | Modificateurs +-----------------+-----------------------------+--------------- + topiaid | character varying(255) | non NULL + topiaversion | bigint | non NULL + topiacreatedate | timestamp without time zone | non NULL + code | character varying(255) | + commune | text | + sector | text | + lengthgroup | text | + staffsizegroup | text | +Index : + "boatgroup_pkey" PRIMARY KEY, btree (topiaid) +Référencé par : + TABLE "boat" CONSTRAINT "boatgroup_fkey" FOREIGN KEY (boatgroup) REFERENCES boatgroup(topiaid) + + Index « public.boatgroup_pkey » + Colonne | Type +---------+------------------------ + topiaid | character varying(255) +clé primaire, btree, pour la table « public.boatgroup » + + Table « public.boatinfos » + Colonne | Type | Modificateurs +--------------------+-----------------------------+--------------- + topiaid | character varying(255) | non NULL + topiaversion | bigint | non NULL + topiacreatedate | timestamp without time zone | + contactfirstname | text | + contactlastname | text | + contactemail | text | + contactphonenumber | text | + dup | integer | + comment | text | + company | character varying(255) | + boat | character varying(255) | + contactaddress1 | text | + contactaddress2 | text | + contactcity | text | + contactpostalcode | integer | + contactsiret | text | +Index : + "boatinfos_pkey" PRIMARY KEY, btree (topiaid) +Contraintes de clés étrangères : + "fka23bd02570b2d8eb" FOREIGN KEY (boat) REFERENCES boat(topiaid) + "fka23bd025f28824af" FOREIGN KEY (company) REFERENCES company(topiaid) + + Index « public.boatinfos_pkey » + Colonne | Type +---------+------------------------ + topiaid | character varying(255) +clé primaire, btree, pour la table « public.boatinfos » + + Table « public.company » + Colonne | Type | Modificateurs +-----------------+-----------------------------+--------------- + topiaid | character varying(255) | non NULL + topiaversion | bigint | non NULL + topiacreatedate | timestamp without time zone | + name | text | + phonenumber | text | + address1 | text | + address2 | text | + active | boolean | + email | text | + city | text | + postalcode | integer | +Index : + "company_pkey" PRIMARY KEY, btree (topiaid) +Référencé par : + TABLE "samplerow" CONSTRAINT "fk4256f3d0f28824af" FOREIGN KEY (company) REFERENCES company(topiaid) + TABLE "waouser" CONSTRAINT "fk42d03050f28824af" FOREIGN KEY (company) REFERENCES company(topiaid) + TABLE "boatinfos" CONSTRAINT "fka23bd025f28824af" FOREIGN KEY (company) REFERENCES company(topiaid) + TABLE "news" CONSTRAINT "news_company_fkey" FOREIGN KEY (company) REFERENCES company(topiaid) + + Index « public.company_pkey » + Colonne | Type +---------+------------------------ + topiaid | character varying(255) +clé primaire, btree, pour la table « public.company » + + Table « public.contact » + Colonne | Type | Modificateurs +-------------------------+-----------------------------+------------------------ + topiaid | character varying(255) | non NULL + topiaversion | bigint | non NULL + topiacreatedate | timestamp without time zone | + observationbegindate | timestamp without time zone | + observationenddate | timestamp without time zone | + nbobservants | integer | + mammalsobservation | boolean | + mammalscapture | boolean | + validationprogram | boolean | + validationcompany | boolean | + datainputdate | timestamp without time zone | + comment | text | + tidenbdays | integer | + mainobserver | character varying(255) | + samplerow | character varying(255) | + boat | character varying(255) | + state | smallint | + commentadmin | text | + commentcoordinator | text | + emailsent | boolean | + datareliabilityordinal | smallint | non NULL Par défaut, 4 + obsprogramordinal | smallint | non NULL + samplingstrategyordinal | smallint | + completesampling | boolean | + terrestriallocation | character varying(255) | + mammalsinfo | text | + contactstatemotif | character varying(255) | + creationdate | timestamp without time zone | + landingdate | timestamp without time zone | + observationtypeordinal | smallint | + obsdebcode | character varying(255) | +Index : + "contact_pkey" PRIMARY KEY, btree (topiaid) +Contraintes de clés étrangères : + "contactstatemotif_fkey" FOREIGN KEY (contactstatemotif) REFERENCES contactstatemotif(topiaid) + "fk38b724206e5f00b5" FOREIGN KEY (samplerow) REFERENCES samplerow(topiaid) + "fk38b7242070b2d8eb" FOREIGN KEY (boat) REFERENCES boat(topiaid) + "fk38b72420f0bd0d5b" FOREIGN KEY (mainobserver) REFERENCES waouser(topiaid) + "obsdebcode_fkey" FOREIGN KEY (obsdebcode) REFERENCES obsdebcode(topiaid) + "terrestriallocation_fkey" FOREIGN KEY (terrestriallocation) REFERENCES terrestriallocation(topiaid) +Référencé par : + TABLE "contact_secondaryobservers" CONSTRAINT "contact_fkey" FOREIGN KEY (contact) REFERENCES contact(topiaid) + + Index « public.contact_pkey » + Colonne | Type +---------+------------------------ + topiaid | character varying(255) +clé primaire, btree, pour la table « public.contact » + + Table « public.contact_secondaryobservers » + Colonne | Type | Modificateurs +--------------------+------------------------+--------------- + contact | character varying(255) | non NULL + secondaryobservers | character varying(255) | non NULL +Contraintes de clés étrangères : + "contact_fkey" FOREIGN KEY (contact) REFERENCES contact(topiaid) + "secondaryobservers_fkey" FOREIGN KEY (secondaryobservers) REFERENCES waouser(topiaid) + + Table « public.contactstatemotif » + Colonne | Type | Modificateurs +---------------------+-----------------------------+--------------- + topiaid | character varying(255) | non NULL + topiaversion | bigint | non NULL + topiacreatedate | timestamp without time zone | non NULL + contactstateordinal | smallint | + code | character varying(255) | + name | character varying(1000) | + color | character varying(20) | +Index : + "contactstatemotif_pkey" PRIMARY KEY, btree (topiaid) +Référencé par : + TABLE "contact" CONSTRAINT "contactstatemotif_fkey" FOREIGN KEY (contactstatemotif) REFERENCES contactstatemotif(topiaid) + +Index « public.contactstatemotif_pkey » + Colonne | Type +---------+------------------------ + topiaid | character varying(255) +clé primaire, btree, pour la table « public.contactstatemotif » + + Table « public.dcf5code » + Colonne | Type | Modificateurs +------------------+-----------------------------+--------------- + topiaid | character varying(255) | non NULL + topiaversion | bigint | non NULL + topiacreatedate | timestamp without time zone | non NULL + fishinggeardcf | character varying(255) | non NULL + targetspeciesdcf | character varying(255) | +Index : + "dcf5code_pkey" PRIMARY KEY, btree (topiaid) + "dcf5code_fishinggeardcf_key" UNIQUE, btree (fishinggeardcf, targetspeciesdcf) +Contraintes de clés étrangères : + "fishinggeardcf_fkey" FOREIGN KEY (fishinggeardcf) REFERENCES fishinggeardcf(topiaid) + "targetspeciesdcf_fkey" FOREIGN KEY (targetspeciesdcf) REFERENCES targetspeciesdcf(topiaid) +Référencé par : + TABLE "dcf5code_samplerow" CONSTRAINT "dcf5code_fkey" FOREIGN KEY (dcf5code) REFERENCES dcf5code(topiaid) + +Index « public.dcf5code_fishinggeardcf_key » + Colonne | Type +------------------+------------------------ + fishinggeardcf | character varying(255) + targetspeciesdcf | character varying(255) +unique, btree, pour la table « public.dcf5code » + + Index « public.dcf5code_pkey » + Colonne | Type +---------+------------------------ + topiaid | character varying(255) +clé primaire, btree, pour la table « public.dcf5code » + + Table « public.dcf5code_samplerow » + Colonne | Type | Modificateurs +-----------+------------------------+--------------- + dcf5code | character varying(255) | non NULL + samplerow | character varying(255) | non NULL +Contraintes de clés étrangères : + "dcf5code_fkey" FOREIGN KEY (dcf5code) REFERENCES dcf5code(topiaid) + "samplerow_fkey" FOREIGN KEY (samplerow) REFERENCES samplerow(topiaid) + + Table « public.elligibleboat » + Colonne | Type | Modificateurs +-----------------+-----------------------------+--------------- + topiaid | character varying(255) | non NULL + topiaversion | bigint | non NULL + topiacreatedate | timestamp without time zone | + globalactive | boolean | + companyactive | boolean | + boat | character varying(255) | + samplerow | character varying(255) | +Index : + "elligibleboat_pkey" PRIMARY KEY, btree (topiaid) +Contraintes de clés étrangères : + "fk9c3f3a356e5f00b5" FOREIGN KEY (samplerow) REFERENCES samplerow(topiaid) + "fk9c3f3a3570b2d8eb" FOREIGN KEY (boat) REFERENCES boat(topiaid) + +Index « public.elligibleboat_pkey » + Colonne | Type +---------+------------------------ + topiaid | character varying(255) +clé primaire, btree, pour la table « public.elligibleboat » + + Table « public.fishinggeardcf » + Colonne | Type | Modificateurs +-----------------+-----------------------------+--------------- + topiaid | character varying(255) | non NULL + topiaversion | bigint | non NULL + topiacreatedate | timestamp without time zone | non NULL + code | character varying(10) | non NULL +Index : + "fishinggeardcf_pkey" PRIMARY KEY, btree (topiaid) + "fishinggeardcf_code_key" UNIQUE, btree (code) +Référencé par : + TABLE "dcf5code" CONSTRAINT "fishinggeardcf_fkey" FOREIGN KEY (fishinggeardcf) REFERENCES fishinggeardcf(topiaid) + +Index « public.fishinggeardcf_code_key » + Colonne | Type +---------+----------------------- + code | character varying(10) +unique, btree, pour la table « public.fishinggeardcf » + +Index « public.fishinggeardcf_pkey » + Colonne | Type +---------+------------------------ + topiaid | character varying(255) +clé primaire, btree, pour la table « public.fishinggeardcf » + + Table « public.fishingzone » + Colonne | Type | Modificateurs +-----------------+-----------------------------+--------------- + topiaid | character varying(255) | non NULL + topiaversion | bigint | non NULL + topiacreatedate | timestamp without time zone | + sectorname | text | + facadename | text | + districtcode | text | +Index : + "fishingzone_pkey" PRIMARY KEY, btree (topiaid) +Référencé par : + TABLE "fishingzone_samplerow" CONSTRAINT "fk736b8c27fbbd6b41" FOREIGN KEY (fishingzone) REFERENCES fishingzone(topiaid) + +Index « public.fishingzone_pkey » + Colonne | Type +---------+------------------------ + topiaid | character varying(255) +clé primaire, btree, pour la table « public.fishingzone » + + Table « public.fishingzone_samplerow » + Colonne | Type | Modificateurs +-------------+------------------------+--------------- + fishingzone | character varying(255) | non NULL + samplerow | character varying(255) | non NULL +Contraintes de clés étrangères : + "fk736b8c276e5f00b5" FOREIGN KEY (samplerow) REFERENCES samplerow(topiaid) + "fk736b8c27fbbd6b41" FOREIGN KEY (fishingzone) REFERENCES fishingzone(topiaid) + + Table « public.fleet » + Colonne | Type | Modificateurs +-----------------+-----------------------------+--------------- + topiaid | character varying(255) | non NULL + topiaversion | bigint | non NULL + topiacreatedate | timestamp without time zone | non NULL + code | character varying(255) | + fleetname | character varying(255) | + subfleetname | character varying(255) | + subsubfleetname | character varying(255) | +Index : + "fleet_pkey" PRIMARY KEY, btree (topiaid) +Référencé par : + TABLE "boat" CONSTRAINT "fleet_fkey" FOREIGN KEY (fleet) REFERENCES fleet(topiaid) + + Index « public.fleet_pkey » + Colonne | Type +---------+------------------------ + topiaid | character varying(255) +clé primaire, btree, pour la table « public.fleet » + + Table « public.indicator » + Colonne | Type | Modificateurs +-----------------+-----------------------------+--------------- + topiaid | character varying(255) | non NULL + topiaversion | bigint | non NULL + topiacreatedate | timestamp without time zone | non NULL + indicatorid | smallint | + coefficient | double precision | +Index : + "indicator_pkey" PRIMARY KEY, btree (topiaid) +Référencé par : + TABLE "indicatorlevel" CONSTRAINT "indicator_fkey" FOREIGN KEY (indicator) REFERENCES indicator(topiaid) + + Index « public.indicator_pkey » + Colonne | Type +---------+------------------------ + topiaid | character varying(255) +clé primaire, btree, pour la table « public.indicator » + + Table « public.indicatorlevel » + Colonne | Type | Modificateurs +-----------------+-----------------------------+--------------- + topiaid | character varying(255) | non NULL + topiaversion | bigint | non NULL + topiacreatedate | timestamp without time zone | non NULL + level | smallint | + upperbound | double precision | + indicator | character varying(255) | +Index : + "indicatorlevel_pkey" PRIMARY KEY, btree (topiaid) +Contraintes de clés étrangères : + "indicator_fkey" FOREIGN KEY (indicator) REFERENCES indicator(topiaid) + +Index « public.indicatorlevel_pkey » + Colonne | Type +---------+------------------------ + topiaid | character varying(255) +clé primaire, btree, pour la table « public.indicatorlevel » + + Table « public.indicatorlog » + Colonne | Type | Modificateurs +------------------+-----------------------------+--------------- + topiaid | character varying(255) | non NULL + topiaversion | bigint | non NULL + topiacreatedate | timestamp without time zone | non NULL + logtext | text | + comment | text | + modificationdate | timestamp without time zone | + author | character varying(255) | +Index : + "indicatorlog_pkey" PRIMARY KEY, btree (topiaid) +Contraintes de clés étrangères : + "author_fkey" FOREIGN KEY (author) REFERENCES waouser(topiaid) + +Index « public.indicatorlog_pkey » + Colonne | Type +---------+------------------------ + topiaid | character varying(255) +clé primaire, btree, pour la table « public.indicatorlog » + + Table « public.news » + Colonne | Type | Modificateurs +-----------------+-----------------------------+--------------- + topiaid | character varying(255) | non NULL + topiaversion | bigint | non NULL + topiacreatedate | timestamp without time zone | + title | text | + content | text | + company | character varying(255) | +Index : + "news_pkey" PRIMARY KEY, btree (topiaid) +Contraintes de clés étrangères : + "news_company_fkey" FOREIGN KEY (company) REFERENCES company(topiaid) + + Index « public.news_pkey » + Colonne | Type +---------+------------------------ + topiaid | character varying(255) +clé primaire, btree, pour la table « public.news » + + Table « public.obsdebcode » + Colonne | Type | Modificateurs +-----------------+-----------------------------+--------------- + topiaid | character varying(255) | non NULL + topiaversion | bigint | non NULL + topiacreatedate | timestamp without time zone | non NULL + code | character varying(255) | +Index : + "obsdebcode_pkey" PRIMARY KEY, btree (topiaid) +Référencé par : + TABLE "obsdebcodedetails" CONSTRAINT "obsdebcode_fkey" FOREIGN KEY (obsdebcode) REFERENCES obsdebcode(topiaid) + TABLE "contact" CONSTRAINT "obsdebcode_fkey" FOREIGN KEY (obsdebcode) REFERENCES obsdebcode(topiaid) + + Index « public.obsdebcode_pkey » + Colonne | Type +---------+------------------------ + topiaid | character varying(255) +clé primaire, btree, pour la table « public.obsdebcode » + + Table « public.obsdebcodedetails » + Colonne | Type | Modificateurs +-----------------+-----------------------------+--------------- + topiaid | character varying(255) | non NULL + topiaversion | bigint | non NULL + topiacreatedate | timestamp without time zone | non NULL + obsdebcode | character varying(255) | + label | text | + region | character varying(255) | +Index : + "obsdebcodedetails_pkey" PRIMARY KEY, btree (topiaid) +Contraintes de clés étrangères : + "obsdebcode_fkey" FOREIGN KEY (obsdebcode) REFERENCES obsdebcode(topiaid) + "region_fkey" FOREIGN KEY (region) REFERENCES terrestriallocation(topiaid) + +Index « public.obsdebcodedetails_pkey » + Colonne | Type +---------+------------------------ + topiaid | character varying(255) +clé primaire, btree, pour la table « public.obsdebcodedetails » + + Table « public.observers_samplerow » + Colonne | Type | Modificateurs +-----------+------------------------+--------------- + samplerow | character varying(255) | non NULL + observers | character varying(255) | non NULL +Contraintes de clés étrangères : + "observers_fkey" FOREIGN KEY (observers) REFERENCES waouser(topiaid) + "samplerow_fkey" FOREIGN KEY (samplerow) REFERENCES samplerow(topiaid) + + Table « public.profession » + Colonne | Type | Modificateurs +-----------------+-----------------------------+--------------- + topiaid | character varying(255) | non NULL + topiaversion | bigint | non NULL + topiacreatedate | timestamp without time zone | + meshsize | text | + size | text | + other | text | + libelle | text | + species | text | +Index : + "profession_pkey" PRIMARY KEY, btree (topiaid) +Référencé par : + TABLE "samplerow" CONSTRAINT "fk4256f3d0505de23" FOREIGN KEY (profession) REFERENCES profession(topiaid) + + Index « public.profession_pkey » + Colonne | Type +---------+------------------------ + topiaid | character varying(255) +clé primaire, btree, pour la table « public.profession » + + Table « public.samplemonth » + Colonne | Type | Modificateurs +---------------------+-----------------------------+--------------- + topiaid | character varying(255) | non NULL + topiaversion | bigint | non NULL + topiacreatedate | timestamp without time zone | + realtidesvalue | integer | + expectedtidesvalue | integer | + perioddate | timestamp without time zone | + samplerow | character varying(255) | + estimatedtidesvalue | integer | +Index : + "samplemonth_pkey" PRIMARY KEY, btree (topiaid) +Contraintes de clés étrangères : + "fk822b6f66e5f00b5" FOREIGN KEY (samplerow) REFERENCES samplerow(topiaid) + +Index « public.samplemonth_pkey » + Colonne | Type +---------+------------------------ + topiaid | character varying(255) +clé primaire, btree, pour la table « public.samplemonth » + + Table « public.samplerow » + Colonne | Type | Modificateurs +--------------------------+-----------------------------+------------------- + topiaid | character varying(255) | non NULL + topiaversion | bigint | non NULL + topiacreatedate | timestamp without time zone | + nbobservants | integer | + averagetidetime | double precision | + code | text | + fishingzonesinfos | text | + comment | text | + programname | text | + periodbegin | timestamp without time zone | + periodend | timestamp without time zone | + profession | character varying(255) | + company | character varying(255) | + obsprogramordinal | smallint | non NULL + samplingstrategyordinal | smallint | + terrestriallocation | character varying(255) | + terrestriallocationinfos | text | + expecteddate | timestamp without time zone | + groupname | character varying(255) | + observationunit | character varying(255) | + blankrow | boolean | Par défaut, false + boat | character varying(255) | + observationtypeordinal | smallint | +Index : + "samplerow_pkey" PRIMARY KEY, btree (topiaid) + "samplerow_code_key" UNIQUE, btree (code) +Contraintes de clés étrangères : + "boat_fkey" FOREIGN KEY (boat) REFERENCES boat(topiaid) + "fk4256f3d0505de23" FOREIGN KEY (profession) REFERENCES profession(topiaid) + "fk4256f3d0f28824af" FOREIGN KEY (company) REFERENCES company(topiaid) + "observationunit_fkey" FOREIGN KEY (observationunit) REFERENCES terrestrialdivision(topiaid) + "terrestriallocation_fkey" FOREIGN KEY (terrestriallocation) REFERENCES terrestriallocation(topiaid) +Référencé par : + TABLE "contact" CONSTRAINT "fk38b724206e5f00b5" FOREIGN KEY (samplerow) REFERENCES samplerow(topiaid) + TABLE "samplerowlog" CONSTRAINT "fk4bfe5546e5f00b5" FOREIGN KEY (samplerow) REFERENCES samplerow(topiaid) + TABLE "fishingzone_samplerow" CONSTRAINT "fk736b8c276e5f00b5" FOREIGN KEY (samplerow) REFERENCES samplerow(topiaid) + TABLE "samplemonth" CONSTRAINT "fk822b6f66e5f00b5" FOREIGN KEY (samplerow) REFERENCES samplerow(topiaid) + TABLE "elligibleboat" CONSTRAINT "fk9c3f3a356e5f00b5" FOREIGN KEY (samplerow) REFERENCES samplerow(topiaid) + TABLE "dcf5code_samplerow" CONSTRAINT "samplerow_fkey" FOREIGN KEY (samplerow) REFERENCES samplerow(topiaid) + TABLE "observers_samplerow" CONSTRAINT "samplerow_fkey" FOREIGN KEY (samplerow) REFERENCES samplerow(topiaid) + +Index « public.samplerow_code_key » + Colonne | Type +---------+------ + code | text +unique, btree, pour la table « public.samplerow » + + Index « public.samplerow_pkey » + Colonne | Type +---------+------------------------ + topiaid | character varying(255) +clé primaire, btree, pour la table « public.samplerow » + + Table « public.samplerowlog » + Colonne | Type | Modificateurs +-----------------+-----------------------------+--------------- + topiaid | character varying(255) | non NULL + topiaversion | bigint | non NULL + topiacreatedate | timestamp without time zone | + logtext | text | + comment | text | + samplerow | character varying(255) | + author | character varying(255) | + fromadmin | boolean | +Index : + "samplerowlog_pkey" PRIMARY KEY, btree (topiaid) +Contraintes de clés étrangères : + "fk4bfe5546e5f00b5" FOREIGN KEY (samplerow) REFERENCES samplerow(topiaid) + "fk4bfe554e17bbdd4" FOREIGN KEY (author) REFERENCES waouser(topiaid) + +Index « public.samplerowlog_pkey » + Colonne | Type +---------+------------------------ + topiaid | character varying(255) +clé primaire, btree, pour la table « public.samplerowlog » + + Table « public.shipowner » + Colonne | Type | Modificateurs +-----------------+-----------------------------+--------------- + topiaid | character varying(255) | non NULL + topiaversion | bigint | non NULL + topiacreatedate | timestamp without time zone | + code | text | + firstname | text | + lastname | text | +Index : + "shipowner_pkey" PRIMARY KEY, btree (topiaid) + "shipowner_code_key" UNIQUE, btree (code) + "shipowner_idx" UNIQUE, btree (code) +Référencé par : + TABLE "boat" CONSTRAINT "fk2e39408e559143" FOREIGN KEY (shipowner) REFERENCES shipowner(topiaid) + +Index « public.shipowner_code_key » + Colonne | Type +---------+------ + code | text +unique, btree, pour la table « public.shipowner » + +Index « public.shipowner_idx » + Colonne | Type +---------+------ + code | text +unique, btree, pour la table « public.shipowner » + + Index « public.shipowner_pkey » + Colonne | Type +---------+------------------------ + topiaid | character varying(255) +clé primaire, btree, pour la table « public.shipowner » + + Table « public.targetspeciesdcf » + Colonne | Type | Modificateurs +-----------------+-----------------------------+--------------- + topiaid | character varying(255) | non NULL + topiaversion | bigint | non NULL + topiacreatedate | timestamp without time zone | non NULL + code | character varying(10) | non NULL +Index : + "targetspeciesdcf_pkey" PRIMARY KEY, btree (topiaid) + "targetspeciesdcf_code_key" UNIQUE, btree (code) +Référencé par : + TABLE "dcf5code" CONSTRAINT "targetspeciesdcf_fkey" FOREIGN KEY (targetspeciesdcf) REFERENCES targetspeciesdcf(topiaid) + +Index « public.targetspeciesdcf_code_key » + Colonne | Type +---------+----------------------- + code | character varying(10) +unique, btree, pour la table « public.targetspeciesdcf » + +Index « public.targetspeciesdcf_pkey » + Colonne | Type +---------+------------------------ + topiaid | character varying(255) +clé primaire, btree, pour la table « public.targetspeciesdcf » + + Table « public.terrestrialdivision » + Colonne | Type | Modificateurs +---------------------+-----------------------------+--------------- + topiaid | character varying(255) | non NULL + topiaversion | bigint | non NULL + topiacreatedate | timestamp without time zone | non NULL + code | character varying(255) | + skillzonecode | character varying(255) | + skillzonename | character varying(255) | + subpopulationcode | character varying(255) | + subpopulationname | character varying(255) | + observationunitcode | character varying(255) | + observationunitname | character varying(255) | + port | character varying(255) | + regionifremer | character varying(255) | +Index : + "terrestrialdivision_pkey" PRIMARY KEY, btree (topiaid) +Contraintes de clés étrangères : + "port_fkey" FOREIGN KEY (port) REFERENCES terrestriallocation(topiaid) + "regionifremer_fkey" FOREIGN KEY (regionifremer) REFERENCES terrestriallocation(topiaid) +Référencé par : + TABLE "samplerow" CONSTRAINT "observationunit_fkey" FOREIGN KEY (observationunit) REFERENCES terrestrialdivision(topiaid) + +Index « public.terrestrialdivision_pkey » + Colonne | Type +---------+------------------------ + topiaid | character varying(255) +clé primaire, btree, pour la table « public.terrestrialdivision » + + Table « public.terrestriallocation » + Colonne | Type | Modificateurs +----------------------+-----------------------------+--------------- + topiaid | character varying(255) | non NULL + topiaversion | bigint | non NULL + topiacreatedate | timestamp without time zone | non NULL + locationtypeordinal | smallint | + code | character varying(255) | + name | character varying(255) | + portcode | character varying(255) | + portname | character varying(255) | + districtcode | character varying(255) | + districtname | character varying(255) | + departmentcode | character varying(255) | + departmentname | character varying(255) | + subregionifremercode | character varying(255) | + subregionifremername | character varying(255) | + regionifremercode | character varying(255) | + regionifremername | character varying(255) | + regioncode | character varying(255) | + regionname | character varying(255) | + regiontypecode | character varying(255) | + regiontypename | character varying(255) | + countrycode | character varying(255) | + countryname | character varying(255) | + seaboardcode | character varying(255) | + seaboardname | character varying(255) | + coastfaocode | character varying(255) | + coastfaoname | character varying(255) | +Index : + "terrestriallocation_pkey" PRIMARY KEY, btree (topiaid) +Référencé par : + TABLE "terrestrialdivision" CONSTRAINT "port_fkey" FOREIGN KEY (port) REFERENCES terrestriallocation(topiaid) + TABLE "boat" CONSTRAINT "portofregistry_fkey" FOREIGN KEY (portofregistry) REFERENCES terrestriallocation(topiaid) + TABLE "obsdebcodedetails" CONSTRAINT "region_fkey" FOREIGN KEY (region) REFERENCES terrestriallocation(topiaid) + TABLE "terrestrialdivision" CONSTRAINT "regionifremer_fkey" FOREIGN KEY (regionifremer) REFERENCES terrestriallocation(topiaid) + TABLE "samplerow" CONSTRAINT "terrestriallocation_fkey" FOREIGN KEY (terrestriallocation) REFERENCES terrestriallocation(topiaid) + TABLE "contact" CONSTRAINT "terrestriallocation_fkey" FOREIGN KEY (terrestriallocation) REFERENCES terrestriallocation(topiaid) + +Index « public.terrestriallocation_pkey » + Colonne | Type +---------+------------------------ + topiaid | character varying(255) +clé primaire, btree, pour la table « public.terrestriallocation » + + Table « public.tms_version » + Colonne | Type | Modificateurs +---------+------------------------+--------------- + version | character varying(255) | non NULL +Index : + "tms_version_pkey" PRIMARY KEY, btree (version) + +Index « public.tms_version_pkey » + Colonne | Type +---------+------------------------ + version | character varying(255) +clé primaire, btree, pour la table « public.tms_version » + + Table « public.userprofile » + Colonne | Type | Modificateurs +-------------------+-----------------------------+--------------- + topiaid | character varying(255) | non NULL + topiaversion | bigint | non NULL + topiacreatedate | timestamp without time zone | non NULL + waouser | character varying(255) | + obsprogramordinal | smallint | non NULL + userroleordinal | smallint | non NULL + canwrite | boolean | non NULL + token | character varying(50) | +Index : + "userprofile_pkey" PRIMARY KEY, btree (topiaid) +Contraintes de clés étrangères : + "waouser_fkey" FOREIGN KEY (waouser) REFERENCES waouser(topiaid) + +Index « public.userprofile_pkey » + Colonne | Type +---------+------------------------ + topiaid | character varying(255) +clé primaire, btree, pour la table « public.userprofile » + + Table « public.waouser » + Colonne | Type | Modificateurs +----------------------+-----------------------------+------------------- + topiaid | character varying(255) | non NULL + topiaversion | bigint | non NULL + topiacreatedate | timestamp without time zone | + firstname | text | + lastname | text | + phonenumber | text | + login | text | + password | text | + active | boolean | + company | character varying(255) | + mammalsnotifications | boolean | Par défaut, false +Index : + "waouser_pkey" PRIMARY KEY, btree (topiaid) +Contraintes de clés étrangères : + "fk42d03050f28824af" FOREIGN KEY (company) REFERENCES company(topiaid) +Référencé par : + TABLE "indicatorlog" CONSTRAINT "author_fkey" FOREIGN KEY (author) REFERENCES waouser(topiaid) + TABLE "contact" CONSTRAINT "fk38b72420f0bd0d5b" FOREIGN KEY (mainobserver) REFERENCES waouser(topiaid) + TABLE "samplerowlog" CONSTRAINT "fk4bfe554e17bbdd4" FOREIGN KEY (author) REFERENCES waouser(topiaid) + TABLE "observers_samplerow" CONSTRAINT "observers_fkey" FOREIGN KEY (observers) REFERENCES waouser(topiaid) + TABLE "contact_secondaryobservers" CONSTRAINT "secondaryobservers_fkey" FOREIGN KEY (secondaryobservers) REFERENCES waouser(topiaid) + TABLE "userprofile" CONSTRAINT "waouser_fkey" FOREIGN KEY (waouser) REFERENCES waouser(topiaid) + + Index « public.waouser_pkey » + Colonne | Type +---------+------------------------ + topiaid | character varying(255) +clé primaire, btree, pour la table « public.waouser » + Modified: trunk/src/site/rst/common/utilisateurs.rst =================================================================== --- trunk/src/site/rst/common/utilisateurs.rst 2011-07-01 15:06:42 UTC (rev 1366) +++ trunk/src/site/rst/common/utilisateurs.rst 2011-07-04 10:37:10 UTC (rev 1367) @@ -40,7 +40,7 @@ Comme pour les sociétés, il est possible de rendre un utilisateur inactif. Un utilisateur inactif ne peut se connecter à l'application. -L'identifiant de connection +L'identifiant de connexion $$$$$$$$$$$$$$$$$$$$$$$$$$$ Il est très fortement conseiller que l'identifiant de connection soit une Modified: trunk/src/site/rst/obsDeb/observateur.rst =================================================================== --- trunk/src/site/rst/obsDeb/observateur.rst 2011-07-01 15:06:42 UTC (rev 1366) +++ trunk/src/site/rst/obsDeb/observateur.rst 2011-07-04 10:37:10 UTC (rev 1367) @@ -43,7 +43,7 @@ l'enquête du navire donné dans le prévisionnel. ------------------------------------------------------------------------------- -Synchoniser mon agenda OBM, Thunderbird… avec Wao +Synchoniser votre agenda (OBM, Thunderbird ou autre) avec Wao ------------------------------------------------------------------------------- En ce qui concerne l'observation de terrain, Wao propose la possibilité de Modified: trunk/src/site/site_fr.xml =================================================================== --- trunk/src/site/site_fr.xml 2011-07-01 15:06:42 UTC (rev 1366) +++ trunk/src/site/site_fr.xml 2011-07-04 10:37:10 UTC (rev 1367) @@ -74,6 +74,7 @@ <item name="Cas d'utilisations" href="dev/usecases.html"/> <item name="Règles métier" href="dev/business-rules.html" /> <item name="Modèle de données" href="dev/model.html"/> + <item name="Schéma de la base" href="database_schema.txt"/> <item name="Installation" href="installation.html"/> </menu>