supervision.visits

table columns

Column Name	Column Type	Character Maximum	Is Nullable	Default	Constrained values
id	integer		NO
client_id	integer		YES
visitduedate	timestamp without time zone		YES
visitcreateddate	timestamp without time zone		YES
visitreportduedate	timestamp without time zone		YES	NULL::timestamp without time zone
visitcompleteddate	timestamp without time zone		YES	NULL::timestamp without time zone
visitreportreceiveddate	timestamp without time zone		YES	NULL::timestamp without time zone
visitreportrevieweddate	timestamp without time zone		YES	NULL::timestamp without time zone
visitcommissiondate	timestamp without time zone		YES	NULL::timestamp without time zone
firstextendedvisitreportduedate	timestamp without time zone		YES	NULL::timestamp without time zone
secondextendedvisitreportduedate	timestamp without time zone		YES	NULL::timestamp without time zone
visittype	character varying	255	YES
visitvisitorallocated	character varying	255	YES	NULL::character varying
visitcancellationreason	character varying	255	YES	NULL::character varying
visiturgency	character varying	255	YES	NULL::character varying
visitoutcome	character varying	255	YES	NULL::character varying
whotovisit	character varying	255	YES	NULL::character varying
visitassurancedecision	character varying	255	YES	NULL::character varying
visitreportmarkedas	character varying	255	YES	NULL::character varying
visitsubtype	character varying	255	YES	NULL::character varying