/[openfoncier]/trunk/data/pgsql/v3.12.0-a1.sql
ViewVC logotype

Diff of /trunk/data/pgsql/v3.12.0-a1.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 2549 by softime, Wed Nov 27 18:21:48 2013 UTC revision 2550 by nhaye, Wed Nov 27 18:23:43 2013 UTC
# Line 1511  COMMENT ON COLUMN rivoli.rivoli IS 'Iden Line 1511  COMMENT ON COLUMN rivoli.rivoli IS 'Iden
1511  COMMENT ON COLUMN rivoli.libelle IS 'Code rivoli';  COMMENT ON COLUMN rivoli.libelle IS 'Code rivoli';
1512    
1513  -- service  -- service
1514    COMMENT ON TABLE service IS 'Services consultés lors de l''instruction d''un dossier';
1515    COMMENT ON COLUMN service.service IS 'Identifiant unique';
1516    COMMENT ON COLUMN service.abrege IS 'Code du service';
1517    COMMENT ON COLUMN service.libelle IS 'Libellé du service';
1518    COMMENT ON COLUMN service.adresse IS 'Adresse du service';
1519    COMMENT ON COLUMN service.adresse2 IS 'Complément d''adresse du service';
1520    COMMENT ON COLUMN service.cp IS 'Code postal du service';
1521    COMMENT ON COLUMN service.ville IS 'Ville du service';
1522    COMMENT ON COLUMN service.email IS 'Email du service';
1523    COMMENT ON COLUMN service.delai IS 'Delai de consultation au service';
1524    COMMENT ON COLUMN service.consultation_papier IS 'La consultation nécessite l''envoi d''un courrier';
1525    COMMENT ON COLUMN service.notification_email IS 'La consultation nécessite l''envoi d''un email';
1526    COMMENT ON COLUMN service.om_validite_debut IS 'Date de début de validité du service';
1527    COMMENT ON COLUMN service.om_validite_fin IS 'Date de fin de validité du service';
1528    COMMENT ON COLUMN service.type_consultation IS 'Type de consultation (pour conformité, avis attendu, pour information)';
1529    
1530  -- service_categorie  -- service_categorie
1531    
Legend:
Removed from v.2549  
changed lines
  Added in v.2550
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26