create table HouseHold(
   ID integer PRIMARY KEY,
   street varchar(30),
   city varchar(30),
   state varchar(2),
   zipcode char(5),
   phoneNumber char(12)
   );

create table Person (
   ID integer PRIMARY KEY,
   title varchar(4),
   firstName varchar(15),
   lastName varchar(15),
   membershipStatus char(1) CHECK (membershipStatus IN ('m','a','c')),
   gender char(1),
   birthdate date,
   householdID integer REFERENCES HouseHold(ID),
   householdRole varchar(10),
   homeGroupID integer REFERENCES HomeGroup(ID),
   homeGroupRole varchar(15),
   CHECK (title IS NOT NULL OR membershipStatus = 'c')
   );

create table HomeGroup(
   ID integer PRIMARY KEY,
   name varchar(20),
   meetingTime varchar(20),
   topic varchar(40)
   );

create table Team(
   name varchar(20) PRIMARY KEY,
   mandate varchar(128)
   );

create table PersonTeam(
   ID integer PRIMARY KEY,
   personID integer REFERENCES Person(ID),
   teamName varchar(20) REFERENCES Team(name),
   role varchar(15),
   duration varchar(10)
   );

create table Request(
   ID integer PRIMARY KEY,
   originatorHouseHoldID integer REFERENCES HouseHold(ID),
   requestDate date,
   responderID integer REFERENCES Person(ID),
   text varchar(256),
   infoAccess char(1),
   response varchar(256)
   );