Bonds Table - Sirius Case Management

Bonds relating to clients on deputyships

Stability: The bonds table is to be considered unstable .

Analytical Platform : Yes

Alternative formats : JSON

bonds table columns

Column Name	Column Type	Character Maximum	Is Nullable	Default	Constrained values
id	integer		NO
order_id	integer		YES
bondreferencenumber	character varying	255	YES	NULL::character varying
requiredbondamount	numeric		YES
bondamounttaken	numeric		YES
dischargedate	date		YES
dispensedreason	character varying	255	YES	NULL::character varying
registeredonsystemdate	date		YES
status	character varying	255	YES	NULL::character varying
bond_provider_id	integer		YES
bondcompanyname	character varying	255	YES	NULL::character varying