supervision.order_deputy

table columns

Column Name	Column Type	Character Maximum	Is Nullable	Default	Constrained values
id	integer		NO
maincorrespondent	boolean		YES
deputy_id	integer		YES
statuschangedate	timestamp without time zone		YES	NULL::timestamp without time zone
order_id	integer		YES
statusoncaseoverride	character varying	255	YES	NULL::character varying
statusnotes	text		YES
deputytype	character varying	255	YES
statusoncase	character varying	255	YES
relationshiptoclient	character varying	255	YES
relationshipother	character varying	255	YES	NULL::character varying