Column | Type | Notes |
---|---|---|
id | INTEGER | NOT NULL DEFAULT nextval('bucardo_custom_trigger_id_seq') |
goat | INTEGER | NOT NULL |
trigger_name | TEXT | NOT NULL |
trigger_type | TEXT | NOT NULL |
trigger_language | TEXT | NOT NULL DEFAULT 'plpgsql' |
trigger_body | TEXT | NOT NULL |
trigger_level | TEXT | NOT NULL |
status | TEXT | NOT NULL DEFAULT 'active' |
cdate | TIMESTAMPTZ | NOT NULL DEFAULT now() |
Constraint | Definition |
---|---|
bucardo_custom_trigger_id_pk | PRIMARY KEY (id) |
bucardo_custom_trigger_goat_fk | FOREIGN KEY ([goat](/Bucardo/object_types/goat)) REFERENCES [bucardo.goat](/Bucardo/schema/goat)(id) ON DELETE CASCADE |
type_is_delta_or_trigger | CHECK (trigger_type IN ('delta', 'triggerkick')) |
level_is_row_statement | CHECK (trigger_level IN ('ROW', 'STATEMENT')) |
Index | Unique? | Definition |
---|---|---|
bucardo_custom_trigger_goat_type_unique | Yes | ([goat](/Bucardo/object_types/goat), trigger_type) |
End Point Dev offers professional support for Bucardo, as well as specializing in developing, designing, and marketing effective websites. Since 1995, our diverse team of developers has shown that End Point can handle your organization’s greatest web and database challenges.