liquid_feedback_core

changeset 114:2abc6bc59f06

Added comments for columns of "event" table
author jbe
date Mon Mar 07 03:34:26 2011 +0100 (2011-03-07)
parents 76ffbafb23b5
children 30e0200f82e9
files core.sql
line diff
     1.1 --- a/core.sql	Sat Mar 05 22:05:13 2011 +0100
     1.2 +++ b/core.sql	Mon Mar 07 03:34:26 2011 +0100
     1.3 @@ -724,7 +724,7 @@
     1.4  
     1.5  COMMENT ON TABLE "membership" IS 'Interest of members in topic areas';
     1.6  
     1.7 -COMMENT ON COLUMN "membership"."autoreject"        IS 'TRUE = member votes against all initiatives, if he is neither direct_ or delegating_voter; Entries in the "interest" table can override this setting.';
     1.8 +COMMENT ON COLUMN "membership"."autoreject" IS 'TRUE = member votes against all initiatives, if he is neither direct_ or delegating_voter; Entries in the "interest" table can override this setting.';
     1.9  
    1.10  
    1.11  CREATE TABLE "interest" (
    1.12 @@ -1084,6 +1084,11 @@
    1.13  
    1.14  COMMENT ON TABLE "event" IS 'Event table, automatically filled by triggers';
    1.15  
    1.16 +COMMENT ON COLUMN "event"."occurrence" IS 'Point in time, when event occurred';
    1.17 +COMMENT ON COLUMN "event"."event"      IS 'Type of event (see TYPE "event_type")';
    1.18 +COMMENT ON COLUMN "event"."member_id"  IS 'Member who caused the event, if applicable';
    1.19 +COMMENT ON COLUMN "event"."state"      IS 'If issue_id is set: state of affected issue; If state changed: new state';
    1.20 +
    1.21  
    1.22  
    1.23  ----------------------------------------------

Impressum / About Us