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 ----------------------------------------------