Column | Type | Notes |
---|---|---|
code | INTEGER | NOT NULL |
sync | TEXT | NULL |
goat | INTEGER | NULL |
active | BOOLEAN | NOT NULL DEFAULT 'true' |
priority | SMALLINT | NOT NULL DEFAULT 0 |
cdate | TIMESTAMPTZ | NOT NULL DEFAULT now() |
Constraint | Definition |
---|---|
customcode_map_code_fk | FOREIGN KEY (code) REFERENCES [bucardo.customcode](/Bucardo/schema/customcode)(id) ON DELETE CASCADE |
customcode_map_sync_fk | FOREIGN KEY ([sync](/Bucardo/sync)) REFERENCES [bucardo.sync](/Bucardo/schema/sync)(name) ON UPDATE CASCADE ON DELETE SET NULL |
customcode_map_goat_fk | FOREIGN KEY ([goat](/Bucardo/object_types/goat)) REFERENCES [bucardo.goat](/Bucardo/schema/goat)(id) ON DELETE SET NULL |
customcode_map_sync[goat](/Bucardo/object_types/goat) | CHECK ([sync](/Bucardo/sync) IS NULL OR [goat](/Bucardo/object_types/goat) IS NULL) |
Index | Unique? | Definition |
---|---|---|
customcode_map_unique_[sync](/Bucardo/sync) | Yes | (code,[sync](/Bucardo/sync)) WHERE [sync](/Bucardo/sync) IS NOT NULL |
customcode_map_unique_[goat](/Bucardo/object_types/goat) | Yes | (code,[goat](/Bucardo/object_types/goat)) WHERE [goat](/Bucardo/object_types/goat) IS NOT NULL |
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.