/[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 2508 by nhaye, Fri Nov 22 17:26:26 2013 UTC revision 2509 by nhaye, Fri Nov 22 17:49:45 2013 UTC
# Line 970  COMMENT ON COLUMN dossier_commission.dat Line 970  COMMENT ON COLUMN dossier_commission.dat
970  COMMENT ON COLUMN dossier_commission.motivation IS 'Motivation de la demande de commission';  COMMENT ON COLUMN dossier_commission.motivation IS 'Motivation de la demande de commission';
971  COMMENT ON COLUMN dossier_commission.commission IS 'Identifiant de la commission effective';  COMMENT ON COLUMN dossier_commission.commission IS 'Identifiant de la commission effective';
972  COMMENT ON COLUMN dossier_commission.avis IS 'Avis rendu par la commission';  COMMENT ON COLUMN dossier_commission.avis IS 'Avis rendu par la commission';
973  COMMENT ON COLUMN dossier_commission.lu IS 'Permet de définir que l''instructeur à lu l''avis rendu';  COMMENT ON COLUMN dossier_commission.lu IS 'Permet de définir que l''instructeur a lu l''avis rendu';
974    
975  -- dossier_instruction_type  -- dossier_instruction_type
976  COMMENT ON TABLE dossier_instruction_type IS 'Type de dossier d''instruction (initial, modificatif, transfert, ...)';  COMMENT ON TABLE dossier_instruction_type IS 'Type de dossier d''instruction (initial, modificatif, transfert, ...)';
# Line 983  COMMENT ON COLUMN dossier_instruction_ty Line 983  COMMENT ON COLUMN dossier_instruction_ty
983  COMMENT ON COLUMN dossier_instruction_type.mouvement_sitadel IS 'Mouvement sitadel associé';  COMMENT ON COLUMN dossier_instruction_type.mouvement_sitadel IS 'Mouvement sitadel associé';
984    
985  -- dossier_message  -- dossier_message
986    COMMENT ON TABLE dossier_message IS 'Messages liés aux dossiers';
987    COMMENT ON COLUMN dossier_message.dossier_message IS 'Identifiant unique';
988    COMMENT ON COLUMN dossier_message.dossier IS 'Dossier d''instruction lié';
989    COMMENT ON COLUMN dossier_message.type IS 'Type de message ';
990    COMMENT ON COLUMN dossier_message.emetteur IS 'Service émetteur du message';
991    COMMENT ON COLUMN dossier_message.date_emission IS 'Date d''envoi du message';
992    COMMENT ON COLUMN dossier_message.lu IS 'Permet de définir que l''instructeur a lu le message';
993    COMMENT ON COLUMN dossier_message.contenu IS 'Contenu du message';
994    
995  -- dossier_parcelle  -- dossier_parcelle
996    
Legend:
Removed from v.2508  
changed lines
  Added in v.2509
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26