CREATE TYPE membership
(
   IDNum	integer,
   Surname	varchar (40),
   MiddleName	varchar (40),
   FirstName	varchar (40),
   Expires	date,
   Category	integer
);