supervision.assurance

table columns

Column Name	Column Type	Character Maximum	Is Nullable	Default	Constrained values
requesteddate	timestamp without time zone		NO
requestedby	integer		YES
reviewedby	integer		YES
commissioneddate	timestamp without time zone		YES	NULL::timestamp without time zone
reportduedate	timestamp without time zone		YES	NULL::timestamp without time zone
id	integer		NO
reportreceiveddate	timestamp without time zone		YES	NULL::timestamp without time zone
deputy_id	integer		YES
reportreviewdate	timestamp without time zone		YES	NULL::timestamp without time zone
type	character varying	255	NO
assurancevisitoutcome	character varying	255	YES	NULL::character varying
reportmarkedas	character varying	255	YES	NULL::character varying
visitorallocated	character varying	255	YES	NULL::character varying
pdroutcome	character varying	255	YES	NULL::character varying
note	character varying	1000	YES	NULL::character varying