MTabishS/Text2SQL

1SQLite format 3

@  ]

]-��
�O���|2~_�39V�C--
�9tableView_Unit_StatusView_Unit_StatusCREATE TABLE View_Unit_Status (4apt_id INTEGER,5apt_booking_id INTEGER,6status_date DATETIME NOT NULL,7available_yn BIT,8PRIMARY KEY (status_date),9FOREIGN KEY (apt_id) REFERENCES Apartments (apt_id),10FOREIGN KEY (apt_booking_id) REFERENCES Apartment_Bookings (apt_booking_id)11)?S-
indexsqlite_autoindex_View_Unit_Status_1View_Unit_Status
�	11
�itableApartment_BookingsApartment_Bookings12CREATE TABLE Apartment_Bookings (13apt_booking_id INTEGER NOT NULL,14apt_id INTEGER,15guest_id INTEGER NOT NULL,16booking_status_code CHAR(15) NOT NULL,17booking_start_date DATETIME,18booking_end_date DATETIME,19PRIMARY KEY (apt_booking_id),20UNIQUE (apt_booking_id),21FOREIGN KEY (apt_id) REFERENCES Apartments (apt_id),22FOREIGN KEY (guest_id) REFERENCES Guests (guest_id)23)C24W1
indexsqlite_autoindex_Apartment_Bookings_1Apartment_Bookings�^
�tableGuestsGuestsCREATE TABLE Guests (25guest_id INTEGER NOT NULL ,26gender_code CHAR(1),27guest_first_name VARCHAR(80),28guest_last_name VARCHAR(80),29date_of_birth DATETIME,30PRIMARY KEY (guest_id),31UNIQUE (guest_id)32)+?
indexsqlite_autoindex_Guests_1Guests	�m55
�}tableApartment_FacilitiesApartment_FacilitiesCREATE TABLE Apartment_Facilities (33apt_id INTEGER NOT NULL,34facility_code CHAR(15) NOT NULL,35PRIMARY KEY (apt_id, facility_code),36FOREIGN KEY (apt_id) REFERENCES Apartments (apt_id)37)G[5
indexsqlite_autoindex_Apartment_Facilities_1Apartment_Facilities�R!!
�otableApartmentsApartmentsCREATE TABLE Apartments (38apt_id INTEGER NOT NULL ,39building_id INTEGER NOT NULL,40apt_type_code CHAR(15),41apt_number CHAR(10),42bathroom_count INTEGER,43bedroom_count INTEGER,44room_count CHAR(5),45PRIMARY KEY (apt_id),46UNIQUE (apt_id),47FOREIGN KEY (building_id) REFERENCES Apartment_Buildings (building_id)48)3G!
indexsqlite_autoindex_Apartments_1Apartments�_
33
�etableApartment_BuildingsApartment_BuildingsCREATE TABLE Apartment_Buildings (49building_id INTEGER NOT NULL,50building_short_name CHAR(15),51building_full_name VARCHAR(80),52building_description VARCHAR(255),53building_address VARCHAR(255),54building_manager VARCHAR(50),55building_phone VARCHAR(80),56PRIMARY KEY (building_id),57UNIQUE (building_id)58)EY3
indexsqlite_autoindex_Apartment_Buildings_1Apartment_Buildings
	d� �Y
�
s�q�+59�60C	�	de�H##a5The ClintonThe ClintonFlat012 Arnoldo Mountain61Gerholdland, ID 23342Holly1-605-511-1973x25011t�(	##�%PetersfieldPetersfieldStudio54686 Christopher Circles Apt. 32162Daytonland, ID 88081-3991Juvenal318-398-8140m�))g/Biltmore PlazaBiltmore PlazaDuplex489 Josh Orchard Apt. 99863Sipesview, DE 69053Sydni544-148-5565x2847u�h''y3Silver TowersSilver TowersFlat1844 Armstrong Stravenue Suite 85364Myrnatown, CT 13528Claude1-667-728-2287x3158a�^'']'Windsor CourtWindsor CourtStudio601 Graham Roads65Port Luz, VA 29660-6703Olaf(480)480-7401t�!''y1Barclay TowerBarclay TowerFlat1579 Runte Forges Apt. 54866Leuschkeland, OK 12009-8683Rogers1-326-267-3386x613h�!!o1The AnthemThe AnthemFlat50804 Mason Isle Suite 84467West Whitney, ID 66511Ewald(909)086-5221x3455}�p	++�	'Stuyvesant TownStuyvesant TownStudio101 Queenie Mountains Suite 61968New Korbinmouth, KS 88726-1376Marie(145)411-6406�,55m5Peter Cooper VillagePeter Cooper VillageFlat861 Narciso Glens Suite 39269East Ottis, ND 73970Darlene1-224-619-0295x13195h�##q%Avalon ParkAvalon ParkDuplex6827 Kessler Parkway Suite 90870Ahmedberg, WI 48788Albert376-017-3538x�a++y1Columbus SquareColumbus SquareStudio0703 Danika Mountains Apt. 36271Mohrland, AL 56839-5028Kyle1-724-982-9507x640c�D##e%VIA 57 WESTVIA 57 WESTStudio959 Ethel Viaduct72West Efrainburgh, DE 40074Kathlyn681.772.2454^�?!!a'The EugeneThe EugeneFlat71537 Gorczany Inlet73Wisozkburgh, AL 08256Melyssa(609)946-0491h�))[-Mercedes HouseMercedes HouseStudio354 Otto Villages74Charliefort, VT 71664Brenden915-617-2408x832r�++o/Normandie CourtNormandie CourtStudio7950 Casper Vista Apt. 17675Marquiseberg, CA 70496Emma(948)040-1064x38776������������������((��������pp,,����������
X����uX:����vX

DuplexSuite 6348

�FlatApt. 8378


�DuplexApt. 4119

�DuplexApt. 4773	
�FlatApt. 794377

�DuplexApt. 8596		
pStudioApt. 9408

�FlatSuite 6939

StudioSuite 0886

�StudioApt. 1879

�FlatSuite 3079	
�DuplexSuite 7498	
�StudioApt. 9087

pFlatApt. 5855
	
(FlatSuite 645778����������������













79 80

		













		
��������
Gym

	Boardband
Cable TV
'Swimming Pool
Gym

Boardband
	Boardband81��������	

Gym

	Boardband

Cable TV
'
Swimming Pool	

Gym

Boardband
		Boardband

]��vM$���l@
�
�
�
])3FemaleTamiaMante2013-02-22 11:26:22-3FemaleJuvenalKautzer2003-07-29 22:08:15*
3FemaleElseRoberts1971-11-02 01:51:56*3MaleLouveniaCrona1983-08-26 15:45:08/!3MaleGregoriaSchowalter2015-02-03 23:34:13*823FemaleNikkiLehner1980-06-20 18:15:390	!3FemaleCrystalRunolfsson1971-01-04 04:22:58+3UnknownKeithHoeger2001-06-18 20:05:55(3FemaleMozellToy1997-01-20 17:11:31-3UnknownJosefinaJerde1978-03-08 04:43:04'3FemaleLouGrady1997-01-15 17:37:40'3FemaleGabeBode2007-09-11 19:01:39*3FemaleKeonTreutel1974-08-20 09:28:053'3UnknownRebecaRunolfsdottir1974-05-12 21:53:58'
3MaleKipDuBuque1995-11-04 07:09:5783����������������













84 85

		













		
{��I��[ 
�
�
i
,��{8�

33Confirmed2017-07-03 14:15:562017-11-12 01:05:098�

33Confirmed2017-04-07 04:53:272017-11-29 12:59:428�y

3386Confirmed2016-09-28 05:00:502017-09-30 18:41:04:�'

#33Provisional2016-04-17 12:53:592018-03-20 17:32:58:�o

#33Provisional2016-06-07 05:05:182017-11-13 13:59:45:�A

#33Provisional2017-03-04 02:23:492018-02-06 16:57:05:�?

#33Provisional2017-05-13 18:17:202017-10-06 11:15:588�

33Confirmed2016-11-26 05:04:312018-02-25 15:15:378�q

3387Confirmed2016-07-25 02:57:042017-09-28 11:08:15:�

#33Provisional2016-05-24 20:09:382017-10-03 01:56:218�m

33	Confirmed2017-02-11 14:34:142017-10-07 20:47:198�W

33
Confirmed2016-08-04 10:33:002017-09-29 12:43:50:�Q

#33Provisional2017-03-13 16:20:142018-02-19 16:59:08:�

#33Provisional2016-04-01 06:28:082017-10-25 11:08:42:�

#3388Provisional2016-09-26 17:13:492017-10-07 11:38:4889��������������������yy''ooAA??
�
�
�
�
m
m
W
W
Q
Q





�����oR5�����kN1
�
�
�
3	y2015-07-15 11:06:29
3	

W2015-06-19 07:59:01
3	
2014-12-10 13:53:21
3�2012-11-24 13:39:37
3		o2011-11-06 22:08:42
3	
�2011-02-12 09:04:07
3	90
�2006-02-23 05:50:04
	3	
�2003-08-02 08:36:36
3	
Q2003-07-25 10:13:48
3	
2001-02-17 20:17:0991
3

Q2000-02-04 07:50:09	
3	
�1990-11-04 17:57:50
3
�1985-11-05 11:46:35
3	
�1980-11-12 13:34:45
3	
?1978-12-28 11:53:34
3	'1977-04-15 13:42:19
3	
�1976-12-18 04:03:51
3	�1973-10-28 04:30:14
3	?1972-03-23 22:55:53

3	�1970-09-28 10:24:2992!�����qYA)������iQ9!3
2015-07-15 11:06:293
2015-06-19 07:59:013
2014-12-10 13:53:213
2012-11-24 13:39:373
2011-11-06 22:08:423
2011-02-12 09:04:073
2006-02-23 05:50:043
2003-08-02 08:36:36
3
2003-07-25 10:13:483
2001-02-17 20:17:093
2000-02-04 07:50:09933
1990-11-04 17:57:50	3
1985-11-05 11:46:353
1980-11-12 13:34:453
1978-12-28 11:53:343
1977-04-15 13:42:193
1976-12-18 04:03:513
1973-10-28 04:30:143
1972-03-23 22:55:533	1970-09-28 10:24:29