Bucardo/tables/bucardo.goat
From Bucardo
Table: bucardo.goat
| Column | Type | Notes |
|---|---|---|
| id | INTEGER | NOT NULL DEFAULT nextval('goat_id_seq') |
| db | TEXT | NOT NULL |
| schemaname | TEXT | NOT NULL |
| tablename | TEXT | NOT NULL |
| reltype | TEXT | NOT NULL DEFAULT 'table' |
| pkey | TEXT | NULL |
| qpkey | TEXT | NULL |
| pkeytype | TEXT | NULL |
| has_delta | BOOLEAN | NOT NULL DEFAULT 'false' |
| ping | BOOLEAN | NULL |
| customselect | TEXT | NULL |
| source_makedelta | ONOFF | NOT NULL DEFAULT 'inherits' |
| target_makedelta | ONOFF | NOT NULL DEFAULT 'inherits' |
| rebuild_index | SMALLINT | NULL DEFAULT 0 |
| ghost | BOOLEAN | NOT NULL DEFAULT 'false' |
| standard_conflict | TEXT | NULL |
| analyze_after_copy | BOOLEAN | NOT NULL DEFAULT 'true' |
| strict_checking | BOOLEAN | NOT NULL DEFAULT 'true' |
| delta_bypass | BOOLEAN | NOT NULL DEFAULT 'false' |
| delta_bypass_min | BIGINT | NULL |
| delta_bypass_count | BIGINT | NULL |
| delta_bypass_percent | SMALLINT | NULL |
| cdate | TIMESTAMPTZ | NOT NULL DEFAULT now() |
| Constraint | Definition |
|---|---|
| goat_id_pk | PRIMARY KEY (id) |
| goat_db_fk | FOREIGN KEY (db) REFERENCES bucardo.db(name) ON UPDATE CASCADE ON DELETE RESTRICT |
| has_schemaname | CHECK (length(schemaname) > 1) |
| valid_reltype | CHECK (reltype IN ('table','sequence')) |
| custom_needs_pkey | CHECK (customselect IS NULL OR length(pkey) > 1) |
| pkey_needs_type | CHECK (pkey = '' OR pkeytype IS NOT NULL) |
| standard_conflict | CHECK (((reltype <> 'table') OR (standard_conflict IS NULL)) OR (standard_conflict IN ('source','target','skip','random','latest','abort'))) |
| standard_conflict_sequence | CHECK (((reltype <> 'sequence') OR (standard_conflict IS NULL)) OR (standard_conflict IN ('source','target','skip','lowest','highest'))) |
