
CREATE TABLE "Addresses" (
	"Address_ID" VARCHAR(100) NOT NULL, 
	"Line_1" VARCHAR(255), 
	"Line_2" VARCHAR(255), 
	"City_Town" VARCHAR(255), 
	"State_County" VARCHAR(255), 
	"Other_Details" VARCHAR(255), 
	PRIMARY KEY ("Address_ID"), 
	UNIQUE ("Address_ID")
)


CREATE TABLE "Bookings" (
	"Booking_ID" INTEGER NOT NULL, 
	"Customer_ID" INTEGER NOT NULL, 
	"Workshop_Group_ID" VARCHAR(100) NOT NULL, 
	"Status_Code" CHAR(15) NOT NULL, 
	"Store_ID" INTEGER NOT NULL, 
	"Order_Date" DATETIME NOT NULL, 
	"Planned_Delivery_Date" DATETIME NOT NULL, 
	"Actual_Delivery_Date" DATETIME NOT NULL, 
	"Other_Order_Details" VARCHAR(255), 
	PRIMARY KEY ("Booking_ID"), 
	FOREIGN KEY("Customer_ID") REFERENCES "Clients" ("Client_ID"), 
	FOREIGN KEY("Workshop_Group_ID") REFERENCES "Drama_Workshop_Groups" ("Workshop_Group_ID"), 
	UNIQUE ("Booking_ID")
)


CREATE TABLE "Bookings_Services" (
	"Order_ID" INTEGER NOT NULL, 
	"Product_ID" INTEGER NOT NULL, 
	PRIMARY KEY ("Order_ID", "Product_ID"), 
	FOREIGN KEY("Order_ID") REFERENCES "Bookings" ("Booking_ID"), 
	FOREIGN KEY("Product_ID") REFERENCES "Services" ("Service_ID")
)


CREATE TABLE "Clients" (
	"Client_ID" INTEGER NOT NULL, 
	"Address_ID" INTEGER NOT NULL, 
	"Customer_Email_Address" VARCHAR(255), 
	"Customer_Name" VARCHAR(255), 
	"Customer_Phone" VARCHAR(255), 
	"Other_Details" VARCHAR(255), 
	PRIMARY KEY ("Client_ID"), 
	FOREIGN KEY("Address_ID") REFERENCES "Addresses" ("Address_ID"), 
	UNIQUE ("Client_ID")
)


CREATE TABLE "Customer_Orders" (
	"Order_ID" INTEGER NOT NULL, 
	"Customer_ID" INTEGER NOT NULL, 
	"Store_ID" INTEGER NOT NULL, 
	"Order_Date" DATETIME NOT NULL, 
	"Planned_Delivery_Date" DATETIME NOT NULL, 
	"Actual_Delivery_Date" DATETIME NOT NULL, 
	"Other_Order_Details" VARCHAR(255), 
	PRIMARY KEY ("Order_ID"), 
	FOREIGN KEY("Customer_ID") REFERENCES "Customers" ("Customer_ID"), 
	FOREIGN KEY("Store_ID") REFERENCES "Stores" ("Store_ID"), 
	UNIQUE ("Order_ID")
)


CREATE TABLE "Customers" (
	"Customer_ID" VARCHAR(100) NOT NULL, 
	"Address_ID" INTEGER NOT NULL, 
	"Customer_Name" VARCHAR(255), 
	"Customer_Phone" VARCHAR(255), 
	"Customer_Email_Address" VARCHAR(255), 
	"Other_Details" VARCHAR(255), 
	PRIMARY KEY ("Customer_ID"), 
	FOREIGN KEY("Address_ID") REFERENCES "Addresses" ("Address_ID"), 
	UNIQUE ("Customer_ID")
)


CREATE TABLE "Drama_Workshop_Groups" (
	"Workshop_Group_ID" INTEGER NOT NULL, 
	"Address_ID" INTEGER NOT NULL, 
	"Currency_Code" CHAR(15) NOT NULL, 
	"Marketing_Region_Code" CHAR(15) NOT NULL, 
	"Store_Name" VARCHAR(255), 
	"Store_Phone" VARCHAR(255), 
	"Store_Email_Address" VARCHAR(255), 
	"Other_Details" VARCHAR(255), 
	PRIMARY KEY ("Workshop_Group_ID"), 
	FOREIGN KEY("Address_ID") REFERENCES "Addresses" ("Address_ID"), 
	UNIQUE ("Workshop_Group_ID")
)


CREATE TABLE "Invoice_Items" (
	"Invoice_Item_ID" INTEGER NOT NULL, 
	"Invoice_ID" INTEGER NOT NULL, 
	"Order_ID" INTEGER NOT NULL, 
	"Order_Item_ID" INTEGER NOT NULL, 
	"Product_ID" INTEGER NOT NULL, 
	"Order_Quantity" INTEGER, 
	"Other_Item_Details" VARCHAR(255), 
	PRIMARY KEY ("Invoice_Item_ID"), 
	FOREIGN KEY("Order_Item_ID") REFERENCES "Order_Items" ("Order_Item_ID"), 
	FOREIGN KEY("Invoice_ID") REFERENCES "Invoices" ("Invoice_ID"), 
	FOREIGN KEY("Order_ID", "Product_ID") REFERENCES "Bookings_Services" ("Order_ID", "Product_ID")
)


CREATE TABLE "Invoices" (
	"Invoice_ID" INTEGER NOT NULL, 
	"Order_ID" INTEGER NOT NULL, 
	payment_method_code CHAR(15), 
	"Product_ID" INTEGER NOT NULL, 
	"Order_Quantity" VARCHAR(288), 
	"Other_Item_Details" VARCHAR(255), 
	"Order_Item_ID" INTEGER NOT NULL, 
	PRIMARY KEY ("Invoice_ID"), 
	FOREIGN KEY("Order_ID") REFERENCES "Customer_Orders" ("Order_ID"), 
	FOREIGN KEY("Order_ID") REFERENCES "Bookings" ("Booking_ID"), 
	FOREIGN KEY(payment_method_code) REFERENCES "Ref_Payment_Methods" (payment_method_code)
)


CREATE TABLE "Marketing_Regions" (
	"Marketing_Region_Code" CHAR(15) NOT NULL, 
	"Marketing_Region_Name" VARCHAR(255) NOT NULL, 
	"Marketing_Region_Descriptrion" VARCHAR(255) NOT NULL, 
	"Other_Details" VARCHAR(255), 
	PRIMARY KEY ("Marketing_Region_Code"), 
	UNIQUE ("Marketing_Region_Code")
)


CREATE TABLE "Order_Items" (
	"Order_Item_ID" INTEGER NOT NULL, 
	"Order_ID" INTEGER NOT NULL, 
	"Product_ID" INTEGER NOT NULL, 
	"Order_Quantity" VARCHAR(288), 
	"Other_Item_Details" VARCHAR(255), 
	PRIMARY KEY ("Order_Item_ID"), 
	FOREIGN KEY("Order_ID") REFERENCES "Customer_Orders" ("Order_ID"), 
	FOREIGN KEY("Product_ID") REFERENCES "Products" ("Product_ID")
)


CREATE TABLE "Performers" (
	"Performer_ID" INTEGER NOT NULL, 
	"Address_ID" INTEGER NOT NULL, 
	"Customer_Name" VARCHAR(255), 
	"Customer_Phone" VARCHAR(255), 
	"Customer_Email_Address" VARCHAR(255), 
	"Other_Details" VARCHAR(255), 
	PRIMARY KEY ("Performer_ID"), 
	FOREIGN KEY("Address_ID") REFERENCES "Addresses" ("Address_ID"), 
	UNIQUE ("Performer_ID")
)


CREATE TABLE "Performers_in_Bookings" (
	"Order_ID" INTEGER NOT NULL, 
	"Performer_ID" INTEGER NOT NULL, 
	PRIMARY KEY ("Order_ID", "Performer_ID"), 
	FOREIGN KEY("Performer_ID") REFERENCES "Performers" ("Performer_ID"), 
	FOREIGN KEY("Order_ID") REFERENCES "Bookings" ("Booking_ID")
)


CREATE TABLE "Products" (
	"Product_ID" VARCHAR(100) NOT NULL, 
	"Product_Name" VARCHAR(255), 
	"Product_Price" DECIMAL(20, 4), 
	"Product_Description" VARCHAR(255), 
	"Other_Product_Service_Details" VARCHAR(255), 
	PRIMARY KEY ("Product_ID"), 
	UNIQUE ("Product_ID")
)


CREATE TABLE "Ref_Payment_Methods" (
	payment_method_code CHAR(10) NOT NULL, 
	payment_method_description VARCHAR(80), 
	PRIMARY KEY (payment_method_code), 
	UNIQUE (payment_method_code)
)


CREATE TABLE "Ref_Service_Types" (
	"Service_Type_Code" CHAR(15) NOT NULL, 
	"Parent_Service_Type_Code" CHAR(15), 
	"Service_Type_Description" VARCHAR(255), 
	PRIMARY KEY ("Service_Type_Code"), 
	UNIQUE ("Service_Type_Code")
)


CREATE TABLE "Services" (
	"Service_ID" INTEGER NOT NULL, 
	"Service_Type_Code" CHAR(15), 
	"Workshop_Group_ID" INTEGER NOT NULL, 
	"Product_Description" VARCHAR(255), 
	"Product_Name" VARCHAR(255), 
	"Product_Price" DECIMAL(20, 4), 
	"Other_Product_Service_Details" VARCHAR(255), 
	PRIMARY KEY ("Service_ID"), 
	FOREIGN KEY("Workshop_Group_ID") REFERENCES "Drama_Workshop_Groups" ("Workshop_Group_ID"), 
	FOREIGN KEY("Service_Type_Code") REFERENCES "Ref_Service_Types" ("Service_Type_Code"), 
	UNIQUE ("Service_ID")
)


CREATE TABLE "Stores" (
	"Store_ID" VARCHAR(100) NOT NULL, 
	"Address_ID" INTEGER NOT NULL, 
	"Marketing_Region_Code" CHAR(15) NOT NULL, 
	"Store_Name" VARCHAR(255), 
	"Store_Phone" VARCHAR(255), 
	"Store_Email_Address" VARCHAR(255), 
	"Other_Details" VARCHAR(255), 
	PRIMARY KEY ("Store_ID"), 
	FOREIGN KEY("Address_ID") REFERENCES "Addresses" ("Address_ID"), 
	FOREIGN KEY("Marketing_Region_Code") REFERENCES "Marketing_Regions" ("Marketing_Region_Code"), 
	UNIQUE ("Store_ID")
)

CREATE TABLE "Addresses" (
	"Address_ID" VARCHAR(100) NOT NULL, 
	"Line_1" VARCHAR(255), 
	"Line_2" VARCHAR(255), 
	"City_Town" VARCHAR(255), 
	"State_County" VARCHAR(255), 
	"Other_Details" VARCHAR(255), 
	PRIMARY KEY ("Address_ID"), 
	UNIQUE ("Address_ID")
)

/*
2 rows from Addresses table:
Address_ID	Line_1	Line_2	City_Town	State_County	Other_Details
110	4753 Dach Highway	Suite 846	Feliciaberg	Florida	None
124	391 Vandervort Fall Apt. 446	Apt. 107	West Sherwoodstad	Indiana	None
*/


CREATE TABLE "Bookings" (
	"Booking_ID" INTEGER NOT NULL, 
	"Customer_ID" INTEGER NOT NULL, 
	"Workshop_Group_ID" VARCHAR(100) NOT NULL, 
	"Status_Code" CHAR(15) NOT NULL, 
	"Store_ID" INTEGER NOT NULL, 
	"Order_Date" DATETIME NOT NULL, 
	"Planned_Delivery_Date" DATETIME NOT NULL, 
	"Actual_Delivery_Date" DATETIME NOT NULL, 
	"Other_Order_Details" VARCHAR(255), 
	PRIMARY KEY ("Booking_ID"), 
	FOREIGN KEY("Customer_ID") REFERENCES "Clients" ("Client_ID"), 
	FOREIGN KEY("Workshop_Group_ID") REFERENCES "Drama_Workshop_Groups" ("Workshop_Group_ID"), 
	UNIQUE ("Booking_ID")
)

/*
2 rows from Bookings table:
Booking_ID	Customer_ID	Workshop_Group_ID	Status_Code	Store_ID	Order_Date	Planned_Delivery_Date	Actual_Delivery_Date	Other_Order_Details
1	938	140	good	8	2016-12-12 10:43:01	2013-03-10 18:47:05	1997-11-21 10:07:40	None
2	868	838	stop	7	1976-08-20 00:33:08	2009-07-09 09:18:38	1976-01-08 07:19:23	None
*/


CREATE TABLE "Bookings_Services" (
	"Order_ID" INTEGER NOT NULL, 
	"Product_ID" INTEGER NOT NULL, 
	PRIMARY KEY ("Order_ID", "Product_ID"), 
	FOREIGN KEY("Order_ID") REFERENCES "Bookings" ("Booking_ID"), 
	FOREIGN KEY("Product_ID") REFERENCES "Services" ("Service_ID")
)

/*
2 rows from Bookings_Services table:
Order_ID	Product_ID
1	396
1	779
*/


CREATE TABLE "Clients" (
	"Client_ID" INTEGER NOT NULL, 
	"Address_ID" INTEGER NOT NULL, 
	"Customer_Email_Address" VARCHAR(255), 
	"Customer_Name" VARCHAR(255), 
	"Customer_Phone" VARCHAR(255), 
	"Other_Details" VARCHAR(255), 
	PRIMARY KEY ("Client_ID"), 
	FOREIGN KEY("Address_ID") REFERENCES "Addresses" ("Address_ID"), 
	UNIQUE ("Client_ID")
)

/*
2 rows from Clients table:
Client_ID	Address_ID	Customer_Email_Address	Customer_Name	Customer_Phone	Other_Details
423	201	branson94@example.net	Clifford	(042)912-3404x5135	VIP
426	383	alba04@example.com	Bettye	(604)849-0214	None
*/


CREATE TABLE "Customer_Orders" (
	"Order_ID" INTEGER NOT NULL, 
	"Customer_ID" INTEGER NOT NULL, 
	"Store_ID" INTEGER NOT NULL, 
	"Order_Date" DATETIME NOT NULL, 
	"Planned_Delivery_Date" DATETIME NOT NULL, 
	"Actual_Delivery_Date" DATETIME NOT NULL, 
	"Other_Order_Details" VARCHAR(255), 
	PRIMARY KEY ("Order_ID"), 
	FOREIGN KEY("Customer_ID") REFERENCES "Customers" ("Customer_ID"), 
	FOREIGN KEY("Store_ID") REFERENCES "Stores" ("Store_ID"), 
	UNIQUE ("Order_ID")
)

/*
2 rows from Customer_Orders table:
Order_ID	Customer_ID	Store_ID	Order_Date	Planned_Delivery_Date	Actual_Delivery_Date	Other_Order_Details
1	516	231	1994-08-03 12:34:58	1977-03-11 03:58:19	1992-07-21 22:11:11	None
2	418	229	2014-07-10 10:56:01	1996-08-26 19:19:59	1998-08-22 17:57:32	None
*/


CREATE TABLE "Customers" (
	"Customer_ID" VARCHAR(100) NOT NULL, 
	"Address_ID" INTEGER NOT NULL, 
	"Customer_Name" VARCHAR(255), 
	"Customer_Phone" VARCHAR(255), 
	"Customer_Email_Address" VARCHAR(255), 
	"Other_Details" VARCHAR(255), 
	PRIMARY KEY ("Customer_ID"), 
	FOREIGN KEY("Address_ID") REFERENCES "Addresses" ("Address_ID"), 
	UNIQUE ("Customer_ID")
)

/*
2 rows from Customers table:
Customer_ID	Address_ID	Customer_Name	Customer_Phone	Customer_Email_Address	Other_Details
240	286	Harold	624-096-7791	jerde.harmon@example.com	None
267	98	Federico	914-915-7483	johnson27@example.com	None
*/


CREATE TABLE "Drama_Workshop_Groups" (
	"Workshop_Group_ID" INTEGER NOT NULL, 
	"Address_ID" INTEGER NOT NULL, 
	"Currency_Code" CHAR(15) NOT NULL, 
	"Marketing_Region_Code" CHAR(15) NOT NULL, 
	"Store_Name" VARCHAR(255), 
	"Store_Phone" VARCHAR(255), 
	"Store_Email_Address" VARCHAR(255), 
	"Other_Details" VARCHAR(255), 
	PRIMARY KEY ("Workshop_Group_ID"), 
	FOREIGN KEY("Address_ID") REFERENCES "Addresses" ("Address_ID"), 
	UNIQUE ("Workshop_Group_ID")
)

/*
2 rows from Drama_Workshop_Groups table:
Workshop_Group_ID	Address_ID	Currency_Code	Marketing_Region_Code	Store_Name	Store_Phone	Store_Email_Address	Other_Details
136	383	EU	FR	Amely Cafe	122-084-8029	amely.ruecker@example.com	None
140	180	EU	DE	Veda Film	793-966-9311x5303	breitenberg.veda@example.com	None
*/


CREATE TABLE "Invoice_Items" (
	"Invoice_Item_ID" INTEGER NOT NULL, 
	"Invoice_ID" INTEGER NOT NULL, 
	"Order_ID" INTEGER NOT NULL, 
	"Order_Item_ID" INTEGER NOT NULL, 
	"Product_ID" INTEGER NOT NULL, 
	"Order_Quantity" INTEGER, 
	"Other_Item_Details" VARCHAR(255), 
	PRIMARY KEY ("Invoice_Item_ID"), 
	FOREIGN KEY("Order_Item_ID") REFERENCES "Order_Items" ("Order_Item_ID"), 
	FOREIGN KEY("Invoice_ID") REFERENCES "Invoices" ("Invoice_ID"), 
	FOREIGN KEY("Order_ID", "Product_ID") REFERENCES "Bookings_Services" ("Order_ID", "Product_ID")
)

/*
2 rows from Invoice_Items table:
Invoice_Item_ID	Invoice_ID	Order_ID	Order_Item_ID	Product_ID	Order_Quantity	Other_Item_Details
1	128	1	5	396	2	None
2	162	4	6	191	6	Good quality
*/


CREATE TABLE "Invoices" (
	"Invoice_ID" INTEGER NOT NULL, 
	"Order_ID" INTEGER NOT NULL, 
	payment_method_code CHAR(15), 
	"Product_ID" INTEGER NOT NULL, 
	"Order_Quantity" VARCHAR(288), 
	"Other_Item_Details" VARCHAR(255), 
	"Order_Item_ID" INTEGER NOT NULL, 
	PRIMARY KEY ("Invoice_ID"), 
	FOREIGN KEY("Order_ID") REFERENCES "Customer_Orders" ("Order_ID"), 
	FOREIGN KEY("Order_ID") REFERENCES "Bookings" ("Booking_ID"), 
	FOREIGN KEY(payment_method_code) REFERENCES "Ref_Payment_Methods" (payment_method_code)
)

/*
2 rows from Invoices table:
Invoice_ID	Order_ID	payment_method_code	Product_ID	Order_Quantity	Other_Item_Details	Order_Item_ID
128	14	MasterCard	4	2	None	1
162	13	MasterCard	9	2	None	9
*/


CREATE TABLE "Marketing_Regions" (
	"Marketing_Region_Code" CHAR(15) NOT NULL, 
	"Marketing_Region_Name" VARCHAR(255) NOT NULL, 
	"Marketing_Region_Descriptrion" VARCHAR(255) NOT NULL, 
	"Other_Details" VARCHAR(255), 
	PRIMARY KEY ("Marketing_Region_Code"), 
	UNIQUE ("Marketing_Region_Code")
)

/*
2 rows from Marketing_Regions table:
Marketing_Region_Code	Marketing_Region_Name	Marketing_Region_Descriptrion	Other_Details
CA	Canada	Our target market	None
CN	China	Our largest market	None
*/


CREATE TABLE "Order_Items" (
	"Order_Item_ID" INTEGER NOT NULL, 
	"Order_ID" INTEGER NOT NULL, 
	"Product_ID" INTEGER NOT NULL, 
	"Order_Quantity" VARCHAR(288), 
	"Other_Item_Details" VARCHAR(255), 
	PRIMARY KEY ("Order_Item_ID"), 
	FOREIGN KEY("Order_ID") REFERENCES "Customer_Orders" ("Order_ID"), 
	FOREIGN KEY("Product_ID") REFERENCES "Products" ("Product_ID")
)

/*
2 rows from Order_Items table:
Order_Item_ID	Order_ID	Product_ID	Order_Quantity	Other_Item_Details
1	3	233	1	None
2	15	300	2	None
*/


CREATE TABLE "Performers" (
	"Performer_ID" INTEGER NOT NULL, 
	"Address_ID" INTEGER NOT NULL, 
	"Customer_Name" VARCHAR(255), 
	"Customer_Phone" VARCHAR(255), 
	"Customer_Email_Address" VARCHAR(255), 
	"Other_Details" VARCHAR(255), 
	PRIMARY KEY ("Performer_ID"), 
	FOREIGN KEY("Address_ID") REFERENCES "Addresses" ("Address_ID"), 
	UNIQUE ("Performer_ID")
)

/*
2 rows from Performers table:
Performer_ID	Address_ID	Customer_Name	Customer_Phone	Customer_Email_Address	Other_Details
153	124	Shawna	664.495.1939	krogahn@example.com	None
211	124	Ashley	893-536-8857	preston45@example.net	None
*/


CREATE TABLE "Performers_in_Bookings" (
	"Order_ID" INTEGER NOT NULL, 
	"Performer_ID" INTEGER NOT NULL, 
	PRIMARY KEY ("Order_ID", "Performer_ID"), 
	FOREIGN KEY("Performer_ID") REFERENCES "Performers" ("Performer_ID"), 
	FOREIGN KEY("Order_ID") REFERENCES "Bookings" ("Booking_ID")
)

/*
2 rows from Performers_in_Bookings table:
Order_ID	Performer_ID
1	153
1	341
*/


CREATE TABLE "Products" (
	"Product_ID" VARCHAR(100) NOT NULL, 
	"Product_Name" VARCHAR(255), 
	"Product_Price" DECIMAL(20, 4), 
	"Product_Description" VARCHAR(255), 
	"Other_Product_Service_Details" VARCHAR(255), 
	PRIMARY KEY ("Product_ID"), 
	UNIQUE ("Product_ID")
)

/*
2 rows from Products table:
Product_ID	Product_Name	Product_Price	Product_Description	Other_Product_Service_Details
11	photo	4448536.0000	None	None
154	film	2302.0000	None	None
*/


CREATE TABLE "Ref_Payment_Methods" (
	payment_method_code CHAR(10) NOT NULL, 
	payment_method_description VARCHAR(80), 
	PRIMARY KEY (payment_method_code), 
	UNIQUE (payment_method_code)
)

/*
2 rows from Ref_Payment_Methods table:
payment_method_code	payment_method_description
American E	credit
MasterCard	debit
*/


CREATE TABLE "Ref_Service_Types" (
	"Service_Type_Code" CHAR(15) NOT NULL, 
	"Parent_Service_Type_Code" CHAR(15), 
	"Service_Type_Description" VARCHAR(255), 
	PRIMARY KEY ("Service_Type_Code"), 
	UNIQUE ("Service_Type_Code")
)

/*
2 rows from Ref_Service_Types table:
Service_Type_Code	Parent_Service_Type_Code	Service_Type_Description
1	1	provide photo service
2	1	provide dinning service
*/


CREATE TABLE "Services" (
	"Service_ID" INTEGER NOT NULL, 
	"Service_Type_Code" CHAR(15), 
	"Workshop_Group_ID" INTEGER NOT NULL, 
	"Product_Description" VARCHAR(255), 
	"Product_Name" VARCHAR(255), 
	"Product_Price" DECIMAL(20, 4), 
	"Other_Product_Service_Details" VARCHAR(255), 
	PRIMARY KEY ("Service_ID"), 
	FOREIGN KEY("Workshop_Group_ID") REFERENCES "Drama_Workshop_Groups" ("Workshop_Group_ID"), 
	FOREIGN KEY("Service_Type_Code") REFERENCES "Ref_Service_Types" ("Service_Type_Code"), 
	UNIQUE ("Service_ID")
)

/*
2 rows from Services table:
Service_ID	Service_Type_Code	Workshop_Group_ID	Product_Description	Product_Name	Product_Price	Other_Product_Service_Details
191	1	415	None	film	58932775.8822	None
219	2	838	None	film	2704.4719	None
*/


CREATE TABLE "Stores" (
	"Store_ID" VARCHAR(100) NOT NULL, 
	"Address_ID" INTEGER NOT NULL, 
	"Marketing_Region_Code" CHAR(15) NOT NULL, 
	"Store_Name" VARCHAR(255), 
	"Store_Phone" VARCHAR(255), 
	"Store_Email_Address" VARCHAR(255), 
	"Other_Details" VARCHAR(255), 
	PRIMARY KEY ("Store_ID"), 
	FOREIGN KEY("Address_ID") REFERENCES "Addresses" ("Address_ID"), 
	FOREIGN KEY("Marketing_Region_Code") REFERENCES "Marketing_Regions" ("Marketing_Region_Code"), 
	UNIQUE ("Store_ID")
)

/*
2 rows from Stores table:
Store_ID	Address_ID	Marketing_Region_Code	Store_Name	Store_Phone	Store_Email_Address	Other_Details
150	286	IN	FJA Filming	+65(1)3590790358	fjacobson@example.com	None
229	266	CA	Rob Dinning	1-327-185-9368	rborer@example.org	5 stars
*/
Which city is the address of the store named "FJA Filming" located in?
SELECT T1.City_Town FROM Addresses AS T1 JOIN Stores AS T2 ON T1.Address_ID  =  T2.Address_ID WHERE T2.Store_Name  =  "FJA Filming"
[{'City_Town': 'New Lonzoville'}]