Bucardo tables goat

Table: bucardo.goat

**Holds information on each table or sequence that may be replicated**
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](/Bucardo/schema/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](/Bucardo/operations/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')))