supervision.firm

table columns

Column Name	Column Type	Character Maximum	Is Nullable	Default	Constrained values
id	integer		NO
firmnumber	integer		YES
piireceived	date		YES
piiexpiry	date		YES
piiamount	numeric		YES	NULL::numeric
piirequested	date		YES
executivecasemanager_id	integer		YES
postcode	character varying	255	YES	NULL::character varying
phonenumber	character varying	255	YES	NULL::character varying
email	character varying	255	YES	NULL::character varying
firmname	character varying	255	NO
addressline1	character varying	255	YES	NULL::character varying
addressline2	character varying	255	YES	NULL::character varying
addressline3	character varying	255	YES	NULL::character varying
town	character varying	255	YES	NULL::character varying
county	character varying	255	YES	NULL::character varying