RAFT for APEX 2
-- run this script as the administrator. It will create a user account named RAFT and build the tables in that schema
-- these statements may fail the first time you run this script because the tables do not yet exist
drop view RAFT.person;
drop table RAFT.scheduledFor;
drop table RAFT.appointment;
drop table RAFT.room;
drop table RAFT.employee;
drop table RAFT.client;
drop table RAFT.counselor;
-- Drop USER RAFT
DROP USER RAFT CASCADE;
-- USER SQL
CREATE USER RAFT IDENTIFIED BY Temporary_Password_1234;
-- ADD ROLES
GRANT CONNECT TO RAFT;
GRANT RESOURCE TO RAFT;
GRANT CREATE VIEW TO RAFT;
ALTER USER RAFT DEFAULT ROLE CONNECT,RESOURCE;
ALTER USER RAFT QUOTA UNLIMITED on DATA;
-- ENABLE REST
BEGIN
ORDS.ENABLE_SCHEMA(
p_enabled => TRUE,
p_schema => 'RAFT',
p_url_mapping_type => 'BASE_PATH',
p_url_mapping_pattern => 'raft',
p_auto_rest_auth=> TRUE
);
commit;
END;
/
create table RAFT.Counselor(
CounselorID int GENERATED ALWAYS as IDENTITY(START with 100 increment by 10) primary key ,
FirstName varchar(50),
LastName varchar(50),
Address varchar(50),
City varchar(50),
State char(2),
ZIP char(10),
Phone varchar(14),
Email varchar(100),
DegreeSuffix varchar(50)
);
create table RAFT.Client(
ClientID int GENERATED ALWAYS as IDENTITY(START with 101 increment by 10) primary key ,
FirstName varchar(50),
LastName varchar(50),
Address varchar(50),
City varchar(50),
State char(2),
ZIP char(10),
Phone varchar(14),
Email varchar(100),
FoundOut varchar(50),
ReminderMethod varchar(50),
ReferredBy int references RAFT.client
);
create table RAFT.Employee(
EmployeeID int GENERATED ALWAYS as IDENTITY(START with 102 increment by 10) primary key ,
FirstName varchar(50),
LastName varchar(50),
Address varchar(50),
City varchar(50),
State char(2),
ZIP char(10),
Phone varchar(14),
Email varchar(100),
DateHired date,
Wage number(4,2),
SupervisorID int references RAFT.Employee
);
create table RAFT.Room(
RoomNumber int primary key,
RoomName varchar(50)
);
create table RAFT.Appointment(
AppointmentID int GENERATED ALWAYS as IDENTITY(START with 1000) primary key,
AppointmentTime date,
Duration int,
CounselorID int references RAFT.counselor not null,
EmployeeID int references RAFT.employee not null,
RoomNumber int references RAFT.room not null,
Notes varchar(3000)
);
create table RAFT.ScheduledFor(
AppointmentID int references RAFT.Appointment,
ClientID int references RAFT.Client,
Assignment VARCHAR(300),
kept number(1),
PRIMARY KEY (AppointmentID,ClientID)
);
/*data for Counselors*/
insert into RAFT.Counselor(firstname, lastname, address, city, state, zip, phone, email, DegreeSuffix)
values('Quinn','Fowler','5208 Walmsley Blvd','Richmond','VA','23224','(804) 286-4422','qfowler@raftcounseling.com', 'MS');
insert into RAFT.Counselor(firstname, lastname, address, city, state, zip, phone, email, DegreeSuffix)
values('Elizabeth','Baker','3409 Irvington St','Richmond','VA','23234','(804) 539-9337','ebaker@raftcounseling.com', 'PhD');
insert into RAFT.Counselor(firstname, lastname, address, city, state, zip, phone, email, DegreeSuffix)
values('Darold','Cooper','4003 Corbin St','Richmond','VA','23222','(804) 286-4422','dbcooper@raftcounseling.com', 'MFT');
insert into RAFT.Counselor(firstname, lastname, address, city, state, zip, phone, email, DegreeSuffix)
values('Diana','Chandler','600 Idlewood Ave','Richmond','VA','23220','(804) 737-9704','dchandler@raftcounseling.com', 'EdD');
insert into RAFT.Counselor(firstname, lastname, address, city, state, zip, phone, email, DegreeSuffix)
values('Phoebe','Wright','707 Old Locke Lane','Richmond','VA','23226','(804) 592-0056','pwright@raftcounseling.com', 'MFT');
/*data for Clients*/
insert into RAFT.Client(firstname, lastname, address, city, state, zip, phone, email, foundOut , reminderMethod)
values('Randall','Mason','3513 A Grove Ave','Richmond','VA','23221','(804) 612-2961','masonjar27@msn.com', 'Radio','Phone');
insert into RAFT.Client(firstname, lastname, address, city, state, zip, phone, email, foundOut , reminderMethod)
values('Leola','White','1625 W Laburnum Ave','Richmond','VA','23227','(804) 786-0698','thewhitehouse@yahoo.com', 'Billboard','Text');
insert into RAFT.Client(firstname, lastname, address, city, state, zip, phone, email, foundOut, reminderMethod, referredBy)
values('Tyrone','McSweeney','5717 Campbell Ave','Richmond','VA','23231','(804) 518-7098','Janessa1820@gmail.com', 'Family','Text',
(select clientID from RAFT.client where firstName = 'Leola')
);
insert into RAFT.Client(firstname, lastname, address, city, state, zip, phone, email, foundOut, reminderMethod)
values('Shannon','Fake','3019 E Marshall St','Richmond','VA','23223','(804) 223-8622','therealshannon@gmail.com', 'Billboard','Email');
insert into RAFT.Client(firstname, lastname, address, city, state, zip, phone, email, foundOut, reminderMethod, referredBy)
values('Yasini','Brothers','205 Wickham St','Richmond','VA','23222','(804) 966-8112','brothersk@me.com', 'Family','Text',
(select clientID from RAFT.client where firstName = 'Shannon')
);
insert into RAFT.Client(firstname, lastname, address, city, state, zip, phone, email, foundOut, reminderMethod, referredBy)
values('Wendi','Overton','915 N 33rd St','Richmond','VA','23223','(804) 649-6464','wendycity99@gmail.com', 'Family','Text',
(select clientID from RAFT.client where firstName = 'Shannon')
);
insert into RAFT.Client(firstname, lastname, address, city, state, zip, phone, email, foundOut, reminderMethod, referredBy)
values('Bessie','Murchison','2918 Edgewood Ave','Richmond','VA','23222','(804) 620-9185','bmurch77@yahoo.com', Null,'Postcard',
(select clientID from RAFT.client where firstName = 'Shannon')
);
insert into RAFT.Client(firstname, lastname, address, city, state, zip, phone, email, foundOut, reminderMethod)
values('Bernice','Mason','3513 A Grove Ave','Richmond','VA','23221','(804) 612-2961','masonjar27@msn.com', 'Radio','Phone');
insert into RAFT.Client(firstname, lastname, address, city, state, zip, phone, email, foundOut, reminderMethod, referredBy)
values('Russ','Overton','915 N 33rd St','Richmond','VA','23223','(804) 649-6464','russ.overon.1982@gmail.com', 'Family','Text',
(select clientID from RAFT.client where firstName = 'Wendi')
);
insert into RAFT.Client(firstname, lastname, address, city, state, zip, phone, email, foundOut, reminderMethod, referredBy)
values('Samantha','Murchison','2918 Edgewood Ave','Richmond','VA','23222','(804) 620-9185','samantha.murch.2002@yahoo.com', Null,'Postcard',
(select clientID from RAFT.client where firstName = 'Bessie')
);
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Jeniffer','MacAleese','9 Linden Plaza','Lorraine','VA','23103','571-305-3716','jmacaleese8@kickstarter.com', 'Radio','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Averil','Rogger','80 West Lane','Lorraine','VA','23103','540-222-0774','aroggerw@smugmug.com', 'Family','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Constancy','Brandin','4123 Hayes Parkway','Lorraine','VA','23103','757-518-1820','cbrandin1a@uiuc.edu', 'Print Ad','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Alleen','Stampfer','23244 Village Place','Lorraine','VA','23103','757-999-2719','astampfer1q@ca.gov', 'Family','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Horatio','Fant','95 Goodland Lane','Lorraine','VA','23103','804-261-5747','hfant25@scribd.com', 'Google','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Pancho','Itzcovich','60119 Mitchell Lane','Lorraine','VA','23103','434-961-4652','pitzcovich3j@g.co', Null,'Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Libbie','Housbey','57 Cottonwood Trail','Lorraine','VA','23103','804-149-1171','lhousbey3y@rambler.ru', 'Family','Phone');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Pierrette','Reignould','5320 Coleman Junction','Lorraine','VA','23103','757-935-7128','preignould40@comsenz.com', 'Family','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Bordy','Marlon','3 Forest Run Road','Lorraine','VA','23103','804-591-8163','bmarlon44@princeton.edu', 'Family','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Maje','Fautly','76248 Kropf Place','Lorraine','VA','23103','804-812-4705','mfautly45@vistaprint.com', 'Google','Phone');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Alain','Ipsly','46 South Drive','Lorraine','VA','23103','571-753-8829','aipsly49@cargocollective.com', 'Family','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Inness','Tuttle','8 Luster Court','Lorraine','VA','23103','571-493-8264','ituttle4g@eventbrite.com', 'Family','Phone');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Elisabetta','Cranshaw','85 Burrows Circle','Lorraine','VA','23103','804-458-9005','ecranshaw4m@senate.gov', 'Family','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Paxton','Gossage','0483 Nelson Way','Lorraine','VA','23103','571-948-0682','pgossage4s@comsenz.com', 'Family','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('George','Jankin','222 Sage Court','Lorraine','VA','23103','757-872-8441','gjankin5b@diigo.com', 'Family','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Allistir','Champion','8549 Hayes Street','Lorraine','VA','23103','804-869-8289','achampion5y@desdev.cn', 'Radio','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Terese','McGaugie','9038 Blackbird Pass','Lorraine','VA','23103','804-206-7889','tmcgaugie6q@cdbaby.com', 'Family','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Jessa','Burr','2 Novick Point','Lorraine','VA','23103','757-426-8303','jburr6s@about.me', 'Radio','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Bianca','Scopes','4 Golf Course Avenue','Lorraine','VA','23103','571-610-2638','bscopes9b@about.com', 'Radio','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Janela','Krysztofowicz','2 Cambridge Avenue','Lorraine','VA','23103','804-428-4052','jkrysztofowiczaf@unesco.org', 'Radio','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Lonny','Kilius','70 Arizona Avenue','Lorraine','VA','23103','434-539-3745','lkiliusay@friendfeed.com', Null,'Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Tiphany','Bartens','759 Pearson Point','Lorraine','VA','23103','804-817-4698','tbartensb3@squarespace.com', 'Print Ad','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Poul','Garford','1 Farwell Place','Lorraine','VA','23103','540-532-4041','pgarfordbi@123-reg.co.uk', 'Print Ad','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Bordie','Eyton','411 Larry Way','Lorraine','VA','23103','434-897-6013','beytonbs@instagram.com', 'Family','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Morna','Dedman','6 5th Street','Lorraine','VA','23103','804-131-1661','mdedmanbw@mlb.com', Null,'Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Brody','Chadwick','8 Roth Place','Lorraine','VA','23103','571-545-4962','bchadwickc3@bigcartel.com', 'Family','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Emery','Cabral','00257 Oak Drive','Lorraine','VA','23103','804-417-8949','ecabralcu@samsung.com', 'Print Ad','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Jandy','Topley','64551 Gale Street','Lorraine','VA','23103','434-141-4433','jtopleyd9@mac.com', 'Billboard','Phone');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Forest','Greening','9783 Brentwood Crossing','Lorraine','VA','23103','804-433-0414','fgreeningdl@guardian.co.uk', 'Family','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Wadsworth','Balharrie','82 Starling Street','Lorraine','VA','23103','540-602-5267','wbalharriedt@amazon.co.uk', 'Google','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Rorie','Ziems','19 Hagan Street','Lorraine','VA','23103','804-749-3844','rziemsf2@phoca.cz', 'Radio','Phone');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Britte','Jewes','53 Prentice Park','Lorraine','VA','23103','757-328-7404','bjewesf5@xrea.com', 'Family','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Barnaby','Cromack','25 La Follette Circle','Lorraine','VA','23103','571-794-6350','bcromackfa@nhs.uk', 'Radio','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Albrecht','Fearnehough','36 2nd Point','Lorraine','VA','23103','434-249-1828','afearnehoughfe@pbs.org', 'Radio','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Bowie','Iles','43 Morning Lane','Lorraine','VA','23103','571-559-8855','bilesfk@jiathis.com', 'Billboard','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Nikita','Coats','40 4th Lane','Lorraine','VA','23103','757-320-3449','ncoatsft@indiegogo.com', 'Family','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Niko','Mussared','4 Shopko Plaza','Lorraine','VA','23103','703-112-4883','nmussaredg0@fotki.com', 'Family','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Judon','Kinforth','5805 Laurel Trail','Lorraine','VA','23103','540-566-0869','jkinforthg6@wunderground.com', 'Radio','Phone');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Wrennie','Real','01 Mockingbird Trail','Lorraine','VA','23103','804-425-3983','wrealgj@fema.gov', Null,'Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Freemon','Tondeur','35 Jana Trail','Lorraine','VA','23103','804-570-5457','ftondeurgw@yolasite.com', 'Facebook','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Kissie','Swains','2 Ridgeway Circle','Lorraine','VA','23103','804-309-6110','kswainshi@youtube.com', Null,'Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Myrna','Shivlin','61473 Orin Circle','Lorraine','VA','23103','757-617-1260','mshivlinhk@about.me', 'Radio','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Meryl','Curlis','48 Roxbury Junction','Lorraine','VA','23103','804-970-2170','mcurlisih@surveymonkey.com', Null,'Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Wynny','Foort','77 David Crossing','Lorraine','VA','23103','804-580-8739','wfoortjq@tumblr.com', 'Facebook','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Meggi','Beaby','29 Ridgeway Way','Lorraine','VA','23103','540-734-1883','mbeabyjw@edublogs.org', 'Billboard','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Joby','Moseley','801 Jenifer Road','Lorraine','VA','23103','540-640-6942','jmoseleyk1@jigsy.com', Null,'Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Tate','Tysack','6 Old Gate Place','Lorraine','VA','23103','571-352-6897','ttysackk5@dyndns.org', 'Print Ad','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Rem','Standfield','37113 Ridge Oak Street','Lorraine','VA','23103','804-950-0887','rstandfieldm3@scribd.com', 'Radio','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Ellery','Larkkem','0211 2nd Point','Lorraine','VA','23103','571-379-6584','elarkkemm6@last.fm', 'Radio','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Hank','Kloser','2 Surrey Way','Lorraine','VA','23103','434-198-3426','hkloserm7@goodreads.com', 'Family','Phone');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Nada','Dexter','5372 Kinsman Way','Lorraine','VA','23103','703-668-5696','ndextermg@facebook.com', 'Print Ad','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Shir','Mechell','65146 Springs Terrace','Lorraine','VA','23103','540-966-4424','smechellml@mayoclinic.com', 'Print Ad','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Cyndi','Mityushkin','3940 Northridge Park','Lorraine','VA','23103','571-570-4981','cmityushkinn0@ebay.co.uk', 'Billboard','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Upton','Casarini','81733 Atwood Lane','Lorraine','VA','23103','804-730-2790','ucasarinino@sfgate.com', 'Radio','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Wade','McAllan','62862 Evergreen Court','Lorraine','VA','23103','571-894-4251','wmcallannq@fc2.com', 'Google','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Alejandrina','O'' Culligan','92123 Eagle Crest Parkway','Lorraine','VA','23103','571-706-9538','aoculliganou@multiply.com', 'Billboard','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Yolane','Friese','50886 Tomscot Crossing','Lorraine','VA','23103','757-104-6180','yfriesep5@vinaora.com', 'Print Ad','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Adan','Takis','6 Mariners Cove Street','Lorraine','VA','23103','540-776-1794','atakispp@i2i.jp', 'Radio','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Marin','Miguet','9 Springs Parkway','Lorraine','VA','23103','571-870-8361','mmiguetqe@adobe.com', 'Radio','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Cam','Possel','95222 Delladonna Place','Lorraine','VA','23103','804-705-7154','cposselrf@mail.ru', 'Facebook','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Jilly','Stansfield','8 Dapin Lane','Lorraine','VA','23103','703-937-5669','jstansfieldrl@hugedomains.com', 'Radio','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Amalee','Casswell','8 Declaration Terrace','Lorraine','VA','23103','757-454-7888','acasswellrn@toplist.cz', 'Family','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Odette','Scruby','0659 Thackeray Drive','Laurel','VA','23228','757-860-9140','oscruby9@4shared.com', 'Google','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Ruby','Cuddon','207 Cascade Place','Laurel','VA','23228','757-559-1029','rcuddon11@domainmarket.com', 'Radio','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Arline','Engall','9 Pleasure Alley','Laurel','VA','23228','703-656-5894','aengall15@opensource.org', 'Billboard','Phone');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Wake','Lutz','3 Starling Road','Laurel','VA','23228','540-562-9265','wlutz1f@samsung.com', 'Google','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Kamillah','Chardin','75622 Mcguire Alley','Laurel','VA','23228','757-828-6264','kchardin1s@google.fr', 'Radio','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Diana','Sokill','764 Forster Street','Laurel','VA','23228','540-467-7305','dsokill1z@opensource.org', Null,'Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Glenden','Lockless','6 Lyons Plaza','Laurel','VA','23228','540-200-5869','glockless23@topsy.com', 'Google','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Margarette','Beglin','6107 Cordelia Way','Laurel','VA','23228','571-473-8511','mbeglin28@netlog.com', 'Family','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Aguistin','Filyaev','9420 Canary Place','Laurel','VA','23228','757-433-7362','afilyaev2f@clickbank.net', Null,'Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Dugald','Whitewood','2 Oxford Point','Laurel','VA','23228','434-836-3684','dwhitewood2q@mayoclinic.com', 'Google','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Nelle','Pactat','736 Mcbride Lane','Laurel','VA','23228','757-893-0375','npactat2y@prnewswire.com', 'Facebook','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Marcia','Faunch','3376 Dapin Circle','Laurel','VA','23228','540-725-6744','mfaunch3z@artisteer.com', 'Facebook','Phone');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Reider','Plunket','83 Dixon Parkway','Laurel','VA','23228','540-694-1893','rplunket4o@t.co', 'Family','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Ernaline','Beden','02233 Linden Court','Laurel','VA','23228','540-577-9761','ebeden57@thetimes.co.uk', 'Print Ad','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Jehu','Defau','6805 Ludington Pass','Laurel','VA','23228','757-388-6400','jdefau5e@slideshare.net', Null,'Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Jarred','Shackle','6 Manufacturers Plaza','Laurel','VA','23228','571-964-3115','jshackle5f@gov.uk', 'Family','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Jo ann','Pechold','586 Garrison Place','Laurel','VA','23228','571-723-1745','jpechold5j@patch.com', 'Radio','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Ninetta','Elcombe','41368 Homewood Center','Laurel','VA','23228','804-459-5891','nelcombe67@mediafire.com', 'Radio','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Karly','Scourge','904 Ronald Regan Crossing','Laurel','VA','23228','757-638-4718','kscourge6b@cafepress.com', 'Facebook','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Aleece','Bridat','39042 Porter Hill','Laurel','VA','23228','757-943-4069','abridat6d@theatlantic.com', 'Google','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Nissie','Panner','44 Shopko Avenue','Laurel','VA','23228','571-522-4083','npanner6g@wordpress.com', 'Google','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Selma','Hudghton','30 Pawling Road','Laurel','VA','23228','571-475-7365','shudghton6n@bluehost.com', 'Billboard','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Consuela','Calvey','2 Kenwood Point','Laurel','VA','23228','571-147-2935','ccalvey6r@simplemachines.org', 'Radio','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Corabel','Taks','30 Armistice Terrace','Laurel','VA','23228','571-241-2535','ctaks6v@un.org', 'Radio','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Lynelle','Eastman','9983 Mallard Avenue','Laurel','VA','23228','540-635-6533','leastman77@wisc.edu', 'Radio','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Alexandra','Nickols','7735 Sutteridge Street','Laurel','VA','23228','757-618-2627','anickols7p@moonfruit.com', 'Facebook','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Montgomery','Martello','907 Melvin Point','Laurel','VA','23228','571-595-7939','mmartello7v@photobucket.com', Null,'Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Tucker','Heckney','2966 Utah Point','Laurel','VA','23228','540-394-7520','theckney7z@un.org', 'Family','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Jorgan','Corbishley','089 Mayfield Place','Laurel','VA','23228','804-654-3524','jcorbishley89@wikia.com', 'Family','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Chicky','Orthmann','0 Pleasure Crossing','Laurel','VA','23228','540-878-2025','corthmann8c@bizjournals.com', 'Print Ad','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Sandie','Gerrill','7 Glacier Hill Road','Laurel','VA','23228','540-320-8443','sgerrill8m@msn.com', 'Radio','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Kathie','Nickerson','55 Nevada Street','Laurel','VA','23228','571-517-9076','knickerson8v@usnews.com', 'Radio','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Nara','Lockyer','6 Petterle Lane','Laurel','VA','23228','571-127-8728','nlockyer90@cbslocal.com', 'Radio','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Cristabel','Goodale','03290 Di Loreto Circle','Laurel','VA','23228','757-408-2882','cgoodale95@oaic.gov.au', 'Radio','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Lyn','Kelbie','3 Birchwood Junction','Laurel','VA','23228','540-186-8630','lkelbie9a@telegraph.co.uk', 'Radio','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Hill','Cuesta','079 Troy Lane','Laurel','VA','23228','571-702-1506','hcuestaan@gmpg.org', 'Radio','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Adora','Ferrar','255 Barnett Center','Laurel','VA','23228','540-829-8525','aferrarb2@cdbaby.com', 'Family','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Nertie','Heining','990 Shopko Crossing','Laurel','VA','23228','434-557-0212','nheiningb6@vkontakte.ru', 'Radio','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Ulrich','Nicklin','88575 Miller Road','Laurel','VA','23228','804-345-7462','unicklinbp@t.co', 'Radio','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Susanetta','Wanden','51321 Muir Drive','Laurel','VA','23228','757-468-1719','swandenbu@huffingtonpost.com', 'Google','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Alexina','Oddy','80 Shelley Lane','Laurel','VA','23228','757-360-6785','aoddyc2@walmart.com', 'Print Ad','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Trixy','Tolchar','574 Stephen Road','Laurel','VA','23228','571-680-5744','ttolcharc4@tamu.edu', 'Billboard','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Garnet','Mackstead','87245 Jenifer Crossing','Laurel','VA','23228','571-749-4069','gmacksteadcr@a8.net', 'Billboard','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Addison','Coldwell','713 Harper Street','Laurel','VA','23228','540-767-0896','acoldwellcx@google.co.jp', 'Family','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Nathan','Tidbury','73002 Dakota Road','Laurel','VA','23228','804-162-7872','ntidburydh@hibu.com', 'Google','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Harriett','Ratledge','73 Forster Crossing','Laurel','VA','23228','757-109-8050','hratledgeeh@japanpost.jp', 'Radio','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Nevile','Coupland','90 Saint Paul Park','Laurel','VA','23228','757-506-7621','ncouplandf1@yale.edu', 'Facebook','Phone');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Mella','Veltman','7 Columbus Parkway','Laurel','VA','23228','571-482-4636','mveltmango@tinyurl.com', 'Family','Phone');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Geno','Yorston','4218 Monterey Center','Laurel','VA','23228','757-981-6918','gyorstonh7@msu.edu', 'Radio','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Dion','Reven','9 Milwaukee Circle','Laurel','VA','23228','804-178-7053','drevenhc@huffingtonpost.com', 'Radio','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Giuseppe','Hattrick','561 Lillian Drive','Laurel','VA','23228','757-150-9307','ghattrickhf@ezinearticles.com', 'Billboard','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Humberto','Surmeir','25182 Brown Parkway','Laurel','VA','23228','804-736-0071','hsurmeirhs@accuweather.com', Null,'Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Les','Robbert','71554 Pine View Hill','Laurel','VA','23228','434-421-0707','lrobberti4@guardian.co.uk', 'Family','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Shayne','McKenny','512 Meadow Vale Lane','Laurel','VA','23228','540-361-1494','smckennyi7@jigsy.com', 'Billboard','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Chan','Verbrugghen','185 Clemons Parkway','Laurel','VA','23228','571-289-9608','cverbrugghenie@sohu.com', 'Family','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Rufus','Bock','0 American Plaza','Laurel','VA','23228','804-758-4863','rbockig@g.co', 'Family','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Adan','Grayshan','5250 Boyd Lane','Laurel','VA','23228','703-794-1132','agrayshanit@cafepress.com', 'Family','Phone');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Bink','Grimestone','75 Oak Road','Laurel','VA','23228','757-543-6612','bgrimestoneiu@ft.com', 'Google','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Shanie','Milkin','9 Bartillon Parkway','Laurel','VA','23228','804-109-1747','smilkiniw@posterous.com', 'Radio','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Valerie','Douch','68449 Maywood Road','Laurel','VA','23228','757-598-2785','vdouchjt@mapy.cz', 'Print Ad','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Sholom','Hiddersley','40 Derek Crossing','Laurel','VA','23228','571-121-6522','shiddersleyk4@webeden.co.uk', 'Family','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Shena','Freke','9748 Garrison Junction','Laurel','VA','23228','540-754-8389','sfrekeki@woothemes.com', 'Family','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Paige','Medlin','6616 Memorial Crossing','Laurel','VA','23228','757-904-1785','pmedlinks@about.com', 'Family','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Otto','Teese','64 Pond Lane','Laurel','VA','23228','757-237-4069','oteeseku@cdbaby.com', 'Family','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Berta','Pischof','2 7th Park','Laurel','VA','23228','571-146-6853','bpischofkw@flickr.com', Null,'Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Judi','Choke','20965 Crest Line Park','Laurel','VA','23228','757-457-8909','jchokela@github.io', Null,'Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Adelice','Bleesing','60916 Warner Drive','Laurel','VA','23228','804-926-8029','ableesingld@comcast.net', 'Radio','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Osmond','Swalough','40378 Roxbury Pass','Laurel','VA','23228','804-840-9772','oswaloughlj@narod.ru', 'Billboard','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Elset','Peplow','986 Hollow Ridge Park','Laurel','VA','23228','434-606-6282','epeplown7@ow.ly', 'Family','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Cinderella','McCrackem','03499 Dryden Street','Laurel','VA','23228','540-686-5468','cmccrackemo6@nhs.uk', 'Radio','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Patricia','Mouser','61651 Dapin Junction','Laurel','VA','23228','804-971-6933','pmousero7@slashdot.org', 'Radio','Phone');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Gardner','Girardot','6185 Mayfield Lane','Laurel','VA','23228','757-296-3335','ggirardotoz@behance.net', 'Family','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('D''arcy','Collingham','6235 Bowman Pass','Laurel','VA','23228','757-170-7863','dcollinghamp7@friendfeed.com', 'Print Ad','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Garnet','Horsey','249 Golf Avenue','Laurel','VA','23228','571-863-1141','ghorseyp8@ca.gov', 'Family','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Hermann','Bodell','0 Russell Street','Laurel','VA','23228','804-941-6569','hbodellp9@stumbleupon.com', 'Facebook','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Dallas','Gorch','3 Jay Circle','Laurel','VA','23228','757-218-8574','dgorchpe@so-net.ne.jp', 'Facebook','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Caria','Molineaux','955 Basil Hill','Laurel','VA','23228','540-253-9241','cmolineauxpj@dedecms.com', 'Billboard','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Jenn','Simmell','56413 Red Cloud Terrace','Laurel','VA','23228','804-515-1917','jsimmellpo@newsvine.com', 'Print Ad','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Claudette','McAnulty','50689 Oak Valley Court','Laurel','VA','23228','571-917-0991','cmcanultyqd@hao123.com', 'Family','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Idalina','Maclean','4 Dunning Trail','Laurel','VA','23228','571-914-2470','imacleanqh@artisteer.com', 'Print Ad','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Adrian','Mcmanaman','31 High Crossing Parkway','Laurel','VA','23228','757-422-9296','amcmanamanqn@tuttocitta.it', 'Radio','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Jolee','Lattey','6228 Eagle Crest Road','Laurel','VA','23228','434-474-5215','jlatteyqo@ibm.com', 'Family','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Lazaro','Whyteman','22 Becker Avenue','Laurel','VA','23228','703-359-5249','lwhytemanr2@statcounter.com', 'Print Ad','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Dougie','Whitwell','08 Grover Circle','Laurel','VA','23228','571-813-9685','dwhitwellrd@bravesites.com', 'Facebook','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Sara-ann','Darragh','615 American Junction','Mechanicsville','VA','23111','540-970-3096','sdarragh1k@economist.com', Null,'Phone');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Garner','Erasmus','3109 Forest Road','Mechanicsville','VA','23111','571-953-7365','gerasmus39@yahoo.com', 'Billboard','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Agnesse','Halfacree','93 Welch Place','Mechanicsville','VA','23111','757-708-3820','ahalfacree41@msn.com', 'Facebook','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Bliss','Nickerson','38 Drewry Road','Mechanicsville','VA','23111','757-318-9563','bnickerson4q@123-reg.co.uk', 'Family','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Mufi','Walczak','356 Red Cloud Place','Mechanicsville','VA','23111','757-668-0825','mwalczak8i@sun.com', 'Family','Phone');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Davida','De Lisle','624 Green Ridge Pass','Mechanicsville','VA','23111','757-758-9018','ddelisle8o@apple.com', Null,'Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Nero','Bearman','664 Hanson Center','Mechanicsville','VA','23111','757-449-3716','nbearman9t@ucla.edu', 'Billboard','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Jeremie','Lindenboim','6314 Evergreen Court','Mechanicsville','VA','23111','804-739-6082','jlindenboimag@google.pl', 'Facebook','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Clayborne','Ceschi','9 Mayer Avenue','Mechanicsville','VA','23111','434-831-4066','cceschib9@ifeng.com', 'Facebook','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Saundra','Addyman','5 Buhler Center','Mechanicsville','VA','23111','757-415-5625','saddymanep@sciencedaily.com', 'Family','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Colman','Quincee','5 Loftsgordon Court','Mechanicsville','VA','23111','804-655-3446','cquinceefr@ezinearticles.com', 'Billboard','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Jess','Gilpillan','0091 John Wall Way','Mechanicsville','VA','23111','540-671-6117','jgilpillangr@cafepress.com', 'Facebook','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Micky','Carette','13 Declaration Pass','Mechanicsville','VA','23111','757-188-0955','mcarettehj@miitbeian.gov.cn', Null,'Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Ninetta','Thorndale','0 Warner Place','Mechanicsville','VA','23111','540-686-2764','nthorndalei5@hatena.ne.jp', 'Radio','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Tanner','Varey','795 Mandrake Point','Mechanicsville','VA','23111','540-589-2893','tvareyok@amazonaws.com', 'Print Ad','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Ryley','Ilchenko','4940 Pierstorff Pass','Highland Springs','VA','23075','757-417-4531','rilchenko0@scribd.com', 'Billboard','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Cally','Lowensohn','18529 Oxford Plaza','Highland Springs','VA','23075','571-364-6329','clowensohn2p@trellian.com', 'Radio','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Luciano','Mence','3 Duke Court','Highland Springs','VA','23075','540-666-0033','lmence34@auda.org.au', 'Radio','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Arlyn','Le Jean','19 Rowland Plaza','Highland Springs','VA','23075','757-340-4374','alejean4u@indiatimes.com', 'Google','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Frants','Reihill','009 Randy Hill','Highland Springs','VA','23075','757-390-5236','freihill4v@furl.net', 'Print Ad','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Regine','Bussel','317 Dwight Plaza','Highland Springs','VA','23075','757-898-9093','rbussel4w@miitbeian.gov.cn', 'Radio','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Kenon','Croney','3003 Dorton Parkway','Highland Springs','VA','23075','202-645-9542','kcroney5x@hhs.gov', 'Billboard','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Charyl','Bossel','4 Fremont Pass','Highland Springs','VA','23075','540-113-1726','cbossel7o@dot.gov', Null,'Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Arleen','Gutsell','2 Vermont Center','Highland Springs','VA','23075','434-896-2185','agutsell9n@livejournal.com', 'Billboard','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Octavia','Beeden','79213 Charing Cross Point','Highland Springs','VA','23075','571-876-8196','obeedena2@hhs.gov', 'Billboard','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Bertram','Cribbott','87 Rieder Junction','Highland Springs','VA','23075','757-784-6104','bcribbottaq@gov.uk', 'Radio','Phone');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Darrin','Gillies','086 Kingsford Circle','Highland Springs','VA','23075','434-468-4104','dgilliesc5@google.ca', 'Billboard','Email');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Janel','Sabban','087 Eagle Crest Terrace','Highland Springs','VA','23075','804-832-0347','jsabbandx@thetimes.co.uk', 'Facebook','Phone');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Mollie','Cantrell','15348 Continental Park','Highland Springs','VA','23075','434-164-6851','mcantrelle4@dailymotion.com', 'Radio','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Noak','Braunton','5 Grasskamp Point','Highland Springs','VA','23075','202-793-5526','nbrauntones@1688.com', 'Family','Postacard');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Kordula','Askem','8269 Hoepker Terrace','Highland Springs','VA','23075','804-852-4866','kaskemhw@dion.ne.jp', 'Radio','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Courtnay','McCromley','54 Farmco Alley','Highland Springs','VA','23075','757-249-5403','cmccromleyjg@prweb.com', 'Family','Text');
insert into RAFT.client(firstname, lastname, address, city, state, zip, phone, email, foundout, reminderMethod) values('Nomi','Shall','81 Acker Plaza','Highland Springs','VA','23075','804-429-7078','nshalljm@ameblo.jp', Null,'Text');
/*data for Employees*/
insert into RAFT.Employee (firstname, lastname, address, city, state, zip, phone, email, DateHired, Wage, supervisorId)
values('Holly','White','1414 Rogers St','Richmond','VA','23223','(804) 640-6817','hollyw@raftcounseling.com', TO_DATE('2013-07-01', 'yyyy-MM-dd'),'17.50', 102);
insert into RAFT.Employee (firstname, lastname, address, city, state, zip, phone, email, DateHired, Wage, supervisorId)
values('Mark','Lucas','1203 1/2 Oakwood Ave','Richmond','VA','23223','(804) 327-2454','markl@raftcounseling.com', TO_DATE('2013-09-01', 'yyyy-MM-dd'),'15.00', 102);
insert into RAFT.Employee (firstname, lastname, address, city, state, zip, phone, email, DateHired, Wage, supervisorId)
values('John','Taylor','913 N 3rd St','Richmond','VA','23219','(804) 331-2700','johnt@raftcounseling.com', TO_DATE('2020-08-01', 'yyyy-MM-dd'),'15.00', 112);
insert into RAFT.Employee (firstname, lastname, address, city, state, zip, phone, email, DateHired, Wage, supervisorId)
values('Molly','Helgeson','900 Maggie Walker Ave','Richmond','VA','23222','(804) 888-0759','mollyh@raftcounseling.com', TO_DATE('2013-06-01', 'yyyy-MM-dd'),'16.80', 112);
/*data for Rooms*/
insert into RAFT.room(roomnumber, roomName) values(1,'Clear sky');
insert into RAFT.room(roomnumber, roomName) values(2,'Flowing waters');
insert into RAFT.room(roomnumber, roomName) values(3,'Calm ocean');
insert into RAFT.room(roomnumber, roomName) values(4,'Peaceful woods');
/*data for Appointments*/
insert into RAFT.appointment(AppointmentTime,duration, counselorid, employeeid, roomnumber)
values(TO_DATE('2024-10-01 8:00:00', 'yyyy-MM-dd hh:mi:ss'),90,
(select counselorid from RAFT.counselor where firstname='Elizabeth'),
(select employeeid from RAFT.employee where firstname='Holly'),
(select roomnumber from RAFT.room where roomname='Clear sky')
);
insert into RAFT.ScheduledFor values(
(select max(appointmentId) from RAFT.appointment),
(select clientid from RAFT.client where firstname='Wendi'),
'Write a letter to Russ listing the things that you are glad he does for the family.',
1
);
insert into RAFT.ScheduledFor values(
(select max(appointmentId) from RAFT.appointment),
(select clientid from RAFT.client where firstname='Russ'),
'Write a letter to Wendi explaining how you first fell in love with her.',
1
);
insert into RAFT.appointment(AppointmentTime,duration, counselorid, employeeid, roomnumber)
values(TO_DATE('2024-10-01 11:00:00', 'yyyy-MM-dd hh:mi:ss'),60,
(select counselorid from RAFT.counselor where firstname='Elizabeth'),
(select employeeid from RAFT.employee where firstname='Holly'),
(select roomnumber from RAFT.room where roomname='Clear sky')
);
insert into RAFT.ScheduledFor values(
(select max(appointmentId) from RAFT.appointment),
(select clientid from RAFT.client where firstname='Bessie'),
'Come prepared to explain how you felt the day Samantha was born.',
1
);
insert into RAFT.ScheduledFor values(
(select max(appointmentId) from RAFT.appointment),
(select clientid from RAFT.client where firstname='Samantha'),
null,
1
);
insert into RAFT.appointment(AppointmentTime,duration, counselorid, employeeid, roomnumber)
values(TO_DATE('2024-10-01 10:00:00', 'yyyy-MM-dd hh:mi:ss'),60,
(select counselorid from RAFT.counselor where firstname='Quinn'),
(select employeeid from RAFT.employee where firstname='John'),
(select roomnumber from RAFT.room where roomname='Flowing waters')
);
insert into RAFT.ScheduledFor values(
(select max(appointmentId) from RAFT.appointment),
(select clientid from RAFT.client where firstname='Leola'),
null,
1
);
insert into RAFT.appointment(AppointmentTime,duration, counselorid, employeeid, roomnumber)
values(TO_DATE('2024-10-01 10:00:00', 'yyyy-MM-dd hh:mi:ss'),60,
(select counselorid from RAFT.counselor where firstname='Elizabeth'),
(select employeeid from RAFT.employee where firstname='Holly'),
(select roomnumber from RAFT.room where roomname='Calm ocean')
);
insert into RAFT.ScheduledFor values(
(select max(appointmentId) from RAFT.appointment),
(select clientid from RAFT.client where firstname='Shannon'),
null,
1
);
insert into RAFT.appointment(AppointmentTime,duration, counselorid, employeeid, roomnumber)
values(TO_DATE('2024-10-01 10:00:00', 'yyyy-MM-dd hh:mi:ss'),90,
(select counselorid from RAFT.counselor where firstname='Darold'),
(select employeeid from RAFT.employee where firstname='Holly'),
(select roomnumber from RAFT.room where roomname='Peaceful woods')
);
insert into RAFT.ScheduledFor values(
(select max(appointmentId) from RAFT.appointment),
(select clientid from RAFT.client where firstname='Bernice'),
null,
1
);
insert into RAFT.appointment(AppointmentTime,duration, counselorid, employeeid, roomnumber)
values(TO_DATE('2024-10-08 10:00:00', 'yyyy-MM-dd hh:mi:ss'),60,
(select counselorid from RAFT.counselor where firstname='Elizabeth'),
(select employeeid from RAFT.employee where firstname='Holly'),
(select roomnumber from RAFT.room where roomname='Calm ocean')
);
insert into RAFT.ScheduledFor values(
(select max(appointmentId) from RAFT.appointment),
(select clientid from RAFT.client where firstname='Shannon'),
null,
1
);
insert into RAFT.appointment(AppointmentTime,duration, counselorid, employeeid, roomnumber)
values(TO_DATE('2024-10-08 10:00:00', 'yyyy-MM-dd hh:mi:ss'),60,
(select counselorid from RAFT.counselor where firstname='Quinn'),
(select employeeid from RAFT.employee where firstname='Holly'),
(select roomnumber from RAFT.room where roomname='Flowing waters')
);
insert into RAFT.ScheduledFor values(
(select max(appointmentId) from RAFT.appointment),
(select clientid from RAFT.client where firstname='Leola'),
null,
1
);
insert into RAFT.appointment(AppointmentTime,duration, counselorid, employeeid, roomnumber)
values(TO_DATE('2024-10-08 10:00:00', 'yyyy-MM-dd hh:mi:ss'),90,
(select counselorid from RAFT.counselor where firstname='Darold'),
(select employeeid from RAFT.employee where firstname='Holly'),
(select roomnumber from RAFT.room where roomname='Peaceful woods')
);
insert into RAFT.ScheduledFor values(
(select max(appointmentId) from RAFT.appointment),
(select clientid from RAFT.client where firstname='Bernice'),
null,
1
);
/* person view */
create view RAFT.person as
select counselorID as personID, FIRSTNAME, LASTNAME, ADDRESS, CITY, STATE, ZIP, PHONE, EMAIL, 'counselor' as personType from counselor
union
select CLIENTID, FIRSTNAME, LASTNAME, ADDRESS, CITY, STATE, ZIP, PHONE, EMAIL, 'client' as personType from client
union
select employeeID, FIRSTNAME, LASTNAME, ADDRESS, CITY, STATE, ZIP, PHONE, EMAIL, 'employee' as personType from employee;
/* show data */
select * from RAFT.room;
select * from RAFT.client;
select * from RAFT.employee;
select * from RAFT.counselor;
select * from RAFT.appointment;
select * from RAFT.scheduledFor;
select * from RAFT.person;