Bucardo/tables/bucardo.herdmap

From Bucardo

Table: bucardo.herdmap

Associates a goat with one or more herds

Column	Type	Notes
herd	TEXT	NOT NULL
goat	INTEGER	NOT NULL
priority	SMALLINT	NOT NULL DEFAULT 0
cdate	TIMESTAMPTZ	NOT NULL DEFAULT now()

Constraint	Definition
herdmap_herd_fk	FOREIGN KEY (herd) REFERENCES bucardo.herd(name) ON UPDATE CASCADE ON DELETE CASCADE
herdmap_goat_fk	FOREIGN KEY (goat) REFERENCES bucardo.goat(id) ON DELETE CASCADE

Index	Unique?	Definition
bucardo_herdmap_unique	Yes	(herd,goat)