Bucardo/tables/bucardo.customcode map
From Bucardo
Table: bucardo.customcode_map
| 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(id) ON DELETE CASCADE |
| customcode_map_sync_fk | FOREIGN KEY (sync) REFERENCES bucardo.sync(name) ON UPDATE CASCADE ON DELETE SET NULL |
| customcode_map_goat_fk | FOREIGN KEY (goat) REFERENCES bucardo.goat(id) ON DELETE SET NULL |
| customcode_map_syncgoat | CHECK (sync IS NULL OR goat IS NULL) |
| Index | Unique? | Definition |
|---|---|---|
| customcode_map_unique_sync | Yes | (code,sync) WHERE sync IS NOT NULL |
| customcode_map_unique_goat | Yes | (code,goat) WHERE goat IS NOT NULL |
