use AP;
drop index AP.zip_index;
drop table AP.members;
drop table AP.members_group;
drop table AP.groups;

create index AP.zip_index on AP.Vendors(zip_code);

create table AP.members(
member_id int primary key,
First_Name varchar(200),
Last_Name varchar(200),
Address varchar(1000),
city varchar(1000),
state varchar(1000),
phone varchar(10)
);

create table AP.groups(
group_id int primary key,
group_name varchar(1000));

create table AP.members_group(
member_id int foreign key references members(member_id),
group_id int foreign key references groups(group_id));