Bucardo/tables/bucardo.q
From Bucardo
Table: bucardo.q
| Column | Type | Notes |
|---|---|---|
| sync | TEXT | NULL |
| sourcedb | TEXT | NULL |
| targetdb | TEXT | NULL |
| ppid | INTEGER | NOT NULL |
| pid | INTEGER | NULL |
| synctype | TEXT | NULL |
| updates | BIGINT | NULL |
| inserts | BIGINT | NULL |
| deletes | BIGINT | NULL |
| started | TIMESTAMPTZ | NULL |
| aborted | TIMESTAMPTZ | NULL |
| whydie | TEXT | NULL |
| ended | TIMESTAMPTZ | NULL |
| cdate | TIMESTAMPTZ | NOT NULL DEFAULT now() |
| Constraint | Definition |
|---|---|
| q_sync_fk | FOREIGN KEY (sync) REFERENCES bucardo.sync(name) ON UPDATE CASCADE ON DELETE SET NULL |
| q_sdb_fk | FOREIGN KEY (sourcedb) REFERENCES bucardo.db(name) ON UPDATE CASCADE ON DELETE SET NULL |
| q_tdb_fk | FOREIGN KEY (targetdb) REFERENCES bucardo.db(name) ON UPDATE CASCADE ON DELETE SET NULL |
| Index | Unique? | Definition |
|---|---|---|
| q_unique | Yes | (sync,sourcedb,targetdb) WHERE started IS NULL |
| q_ppid | No | (ppid,pid) WHERE ended IS NULL AND aborted IS NULL |
| q_aborted | No | (sync) WHERE started IS NOT NULL AND aborted IS NOT NULL AND ended IS NULL |
| q_cleanup | No | (cdate) WHERE ended IS NOT NULL |
| q_stathelper | No | (cdate, sync) WHERE ended IS NOT NULL |
