CREATE PROCEDURE DeleteManagement(IN pStaff_id INT, IN pFacility_id INT)
BEGIN
DELETE FROM Management WHERE staff_id = pStaff_id AND facility_id = pFacility_id;
END
CREATE PROCEDURE DeleteManagement(IN pStaff_id INT, IN pFacility_id INT)
BEGIN
DELETE FROM Management WHERE staff_id = pStaff_id AND facility_id = pFacility_id;
END
1. Activity表插入存储过程
CREATE PROCEDURE InsertActivity (IN pStart_time DATETIME, IN pEnd_time DATETIME, IN pActivity_content VARCHAR(1000))
BEGIN
INSERT INTO Activity(start_time, end_time, activity_content)
VALUES(pStart_time, pEnd_time, pActivity_content);
END
2. Facility表插入存储过程
CREATE PROCEDURE InsertFacility (IN pFacility_type_id INT, IN pLast_maintenance_time DATETIME, IN pProduction_time DATETIME, IN pStatus VARCHAR(20), IN pFacility_name VARCHAR(50))
BEGIN
INSERT INTO Facility(facility_type_id, last_maintenance_time, production_time, status, facility_name)
VALUES(pFacility_type_id, pLast_maintenance_time, pProduction_time, pStatus, pFacility_name);
END
3. Staff表插入存储过程
CREATE PROCEDURE InsertStaff (IN pPhone_number VARCHAR(20), IN pName VARCHAR(50), IN pPosition VARCHAR(20), IN pEmail_address VARCHAR(50))
BEGIN
INSERT INTO Staff(phone_number, name, position, email_address)
VALUES(pPhone_number, pName, pPosition, pEmail_address);
END
4. Feedback表插入存储过程
CREATE PROCEDURE InsertFeedback (IN pID_card_number VARCHAR(20), IN pFeedback_content VARCHAR(1000), IN pFeedback_time DATETIME)
BEGIN
INSERT INTO Feedback(ID_card_number, feedback_content, feedback_time)
VALUES(pID_card_number, pFeedback_content, pFeedback_time);
END
5. Visitor表插入存储过程
CREATE PROCEDURE InsertVisitor (IN pID_card_number VARCHAR(20), IN pName VARCHAR(50), IN pGender VARCHAR(10), IN pPhone_number VARCHAR(20))
BEGIN
INSERT INTO Visitor(ID_card_number, name, gender, phone_number)
VALUES(pID_card_number, pName, pGender, pPhone_number);
END
6. Ticket表插入存储过程
CREATE PROCEDURE InsertTicket (IN pTicket_type_id VARCHAR(20), IN pQuantity INT)
BEGIN
INSERT INTO Ticket(ticket_type_id, quantity)
VALUES(pTicket_type_id, pQuantity);
END
7. Management表插入存储过程
CREATE PROCEDURE InsertManagement (IN pStaff_id INT, IN pFacility_id INT)
BEGIN
INSERT INTO Management(staff_id, facility_id)
VALUES(pStaff_id, pFacility_id);
END
8. Purchase表插入存储过程
CREATE PROCEDURE InsertPurchase (IN pPurchase_time DATETIME, IN pOrder_status VARCHAR(20), IN pID_card_number VARCHAR(20), IN pTicket_type_id VARCHAR(20))
BEGIN
INSERT INTO Purchase(purchase_time, order_status, ID_card_number, ticket_type_id)
VALUES(pPurchase_time, pOrder_status, pID_card_number, pTicket_type_id);
END
9. Contain表插入存储过程
CREATE PROCEDURE InsertContain (IN pFacility_type_id INT, IN pActivity_id INT)
BEGIN
INSERT INTO Contain(facility_type_id, activity_id)
VALUES(pFacility_type_id, pActivity_id);
END
10. Activity表删除数据的存储过程
CREATE PROCEDURE DeleteActivity(IN pActivity_id INT)
BEGIN
DELETE FROM Activity WHERE activity_id = pActivity_id;
END
11. Facility表删除数据的存储过程
CREATE PROCEDURE DeleteFacility(IN pFacility_type_id INT)
BEGIN
DELETE FROM Facility WHERE facility_type_id = pFacility_type_id;
END
12. Staff表删除数据的存储过程
CREATE PROCEDURE DeleteStaff(IN pStaff_id INT)
BEGIN
DELETE FROM Staff WHERE staff_id = pStaff_id;
END
13. Feedback表删除数据的存储过程
CREATE PROCEDURE DeleteFeedback(IN pFeedback_id INT)
BEGIN
DELETE FROM Feedback WHERE feedback_id = pFeedback_id;
END
14. Visitor表删除数据的存储过程
CREATE PROCEDURE DeleteVisitor(IN pID_card_number VARCHAR(20))
BEGIN
DELETE FROM Visitor WHERE ID_card_number = pID_card_number;
END
15. Ticket表删除数据的存储过程
CREATE PROCEDURE DeleteTicket(IN pTicket_type_id VARCHAR(20))
BEGIN
DELETE FROM Ticket WHERE ticket_type_id = pTicket_type_id;
END
16. Management表删除数据的存储过程
CREATE PROCEDURE DeleteManagement(IN pStaff_id INT, IN pFacility_id INT)
BEGIN
DELETE FROM Management WHERE staff_id = pStaff_id AND facility_id = pFacility_id;
END
17. Purchase表删除数据的存储过程
CREATE PROCEDURE DeletePurchase(IN pPurchase_id INT)
BEGIN
DELETE FROM Purchase WHERE purchase_id = pPurchase_id;
END
18. Contain表删除数据的存储过程
CREATE PROCEDURE DeleteContain(IN pFacility_type_id INT, IN pActivity_id INT)
BEGIN
DELETE FROM Contain WHERE facility_type_id = pFacility_type_id AND activity_id = pActivity_id;
END
19. Activity表显示所有数据的存储过程
CREATE PROCEDURE ShowAllActivity()
BEGIN
SELECT activity_id AS '活动编号', start_time AS '开始时间', end_time AS '结束时间', activity_content AS '活动内容' FROM Activity;
END
20. Facility表显示所有数据的存储过程
CREATE PROCEDURE ShowAllFacility()
BEGIN
SELECT facility_type_id AS '设施类型编号', last_maintenance_time AS '上次维护时间', production_time AS '生产时间', status AS '状态', facility_name AS '设施名称' FROM Facility;
END
21. Staff表显示所有数据的存储过程
CREATE PROCEDURE ShowAllStaff()
BEGIN
SELECT staff_id AS '员工编号', phone_number AS '电话号码', name AS '姓名', position AS '职位', email_address AS '电子邮箱' FROM Staff;
END
22. Feedback表显示所有数据的存储过程
CREATE PROCEDURE ShowAllFeedback()
BEGIN
SELECT feedback_id AS '反馈编号', ID_card_number AS '身份证号码', feedback_content AS '反馈内容', feedback_time AS '反馈时间' FROM Feedback;
END
23. Visitor表显示所有数据的存储过程
CREATE PROCEDURE ShowAllVisitor()
BEGIN
SELECT ID_card_number AS '身份证号码', name AS '姓名', gender AS '性别', phone_number AS '电话号码' FROM Visitor;
END
24. Ticket表显示所有数据的存储过程
CREATE PROCEDURE ShowAllTicket()
BEGIN
SELECT ticket_type_id AS '票务类型编号', quantity AS '数量' FROM Ticket;
END
25. Management表显示所有数据的存储过程
CREATE PROCEDURE ShowAllManagement()
BEGIN
SELECT Management.staff_id AS '员工编号', Management.facility_id AS '设施编号' FROM Management;
END
26. Purchase表显示所有数据的存储过程
CREATE PROCEDURE ShowAllPurchase()
BEGIN
SELECT purchase_id AS '购买编号', purchase_time AS '购买时间', order_status AS '订单状态', Purchase.ID_card_number AS '身份证号码', Purchase.ticket_type_id AS '票务类型编号' FROM Purchase;
END
27. Contain表显示所有数据的存储过程
CREATE PROCEDURE ShowAllContain()
BEGIN
SELECT facility_type_id AS '设施类型编号', activity_id AS '活动编号' FROM Contain;
END
28. 通过身份证查询购票信息
CREATE PROCEDURE get_purchase_info_by_idcard(IN id_card VARCHAR(18)) BEGIN SELECT Visitor.ID_card_number AS '身份证号', Visitor.name AS '姓名', Purchase.purchase_time AS '订票时间', Purchase.ticket_type_id AS '订单类型编号', Purchase.order_status AS '使用状态' FROM Purchase INNER JOIN Visitor ON Purchase.ID_card_number = Visitor.ID_card_number WHERE Visitor.ID_card_number = id_card; END
29. 工作人员按照工号查询要维护的设施号
CREATE PROCEDURE QueryFacilityByStaffId(IN pStaff_id INT)
BEGIN
SELECT Management.staff_id AS '工号', Staff.name AS '姓名', Facility.status AS '设施状态', Management.facility_id AS '设施号'
FROM Management
JOIN Staff ON Management.staff_id = Staff.staff_id
JOIN Facility ON Management.facility_id = Facility.facility_type_id
WHERE Management.staff_id = pStaff_id;
END
30. 查询一定时间后的反馈内容
CREATE PROCEDURE QueryFeedbackAfterTime(IN startTime DATETIME)
BEGIN
SELECT Feedback.feedback_time AS '反馈时间', Feedback.feedback_content AS '反馈内容', Feedback.ID_card_number AS '反馈人身份证号', Visitor.name AS '反馈人名'
FROM Feedback
JOIN Visitor ON Feedback.ID_card_number = Visitor.ID_card_number
WHERE Feedback.feedback_time >= startTime;
END
31. 按照游客身份证来查询反馈内容
CREATE PROCEDURE QueryFeedbackByVisitorId(IN pVisitor_id INT)
BEGIN
SELECT Feedback.ID_card_number AS '反馈人身份证号', Visitor.name AS '反馈人姓名', Feedback.feedback_content AS '反馈内容', Feedback.feedback_time AS '反馈时间'
FROM Feedback
JOIN Visitor ON Feedback.ID_card_number = Visitor.ID_card_number
WHERE Feedback.ID_card_number = pVisitor_id;
END
32. 按照类型查看剩余票的张数
CREATE PROCEDURE QueryTicketLeftByType(IN pTicket_type_id INT)
BEGIN
SELECT ticket_type_id AS '余票类型编号', SUM(quantity) AS '剩余余票数额'
FROM Ticket
WHERE ticket_type_id = pTicket_type_id
GROUP BY ticket_type_id;
END
33. 在余票表中，把余票恢复(每种类型的剩余票数都恢复成500）
CREATE PROCEDURE RecoverTicket()
BEGIN
UPDATE Ticket SET quantity = 500;
END
34. 在活动表中，计算活动时长
CREATE PROCEDURE CalculateActivityDuration(IN pActivity_id INT)
BEGIN
SELECT activity_id AS '活动号', start_time AS '开始时间', end_time AS '结束时间', TIMEDIFF(end_time, start_time) AS '活动时长'
FROM Activity
WHERE activity_id = pActivity_id;
END
CREATE VIEW Purchase_View AS
SELECT Visitor.ID_card_number, Visitor.name, Purchase.purchase_time, Purchase.ticket_type_id
FROM Purchase
JOIN Visitor ON Purchase.ID_card_number = Visitor.ID_card_number;
INSERT INTO Activity (activity_id, start_time, end_time, activity_content)
VALUES (1, '2023-06-16 09:00:00', '2023-06-16 10:30:00', 'Morning Yoga Class');
INSERT INTO Activity (activity_id, start_time, end_time, activity_content)
VALUES (2, '2023-06-16 14:00:00', '2023-06-16 15:30:00', 'Art Workshop');
INSERT INTO Activity (activity_id, start_time, end_time, activity_content)
VALUES (3, '2023-06-16 16:30:00', '2023-06-16 18:00:00', 'Cooking Class');
INSERT INTO Activity (activity_id, start_time, end_time, activity_content)
VALUES (4, '2023-06-17 10:00:00', '2023-06-17 11:30:00', 'Fitness Training');
INSERT INTO Activity (activity_id, start_time, end_time, activity_content)
VALUES (5, '2023-06-17 14:00:00', '2023-06-17 16:00:00', 'Dance Workshop');
INSERT INTO Activity (activity_id, start_time, end_time, activity_content)
VALUES (6, '2023-06-18 09:00:00', '2023-06-18 10:30:00', 'Yoga and Meditation');
INSERT INTO Activity (activity_id, start_time, end_time, activity_content)
VALUES (7, '2023-06-18 11:00:00', '2023-06-18 12:30:00', 'Art Exhibition');
INSERT INTO Activity (activity_id, start_time, end_time, activity_content)
VALUES (8, '2023-06-19 14:00:00', '2023-06-19 15:30:00', 'Music Performance');
INSERT INTO Activity (activity_id, start_time, end_time, activity_content)
VALUES (9, '2023-06-20 16:00:00', '2023-06-20 17:30:00', 'Outdoor Adventure');
INSERT INTO Activity (activity_id, start_time, end_time, activity_content)
VALUES (10, '2023-06-21 10:00:00', '2023-06-21 12:00:00', 'Workshop on Photography');
INSERT INTO Facility (facility_type_id, last_maintenance_time, production_time, status, facility_name)
VALUES (1, '2023-06-15 10:00:00', '2023-06-15 12:00:00', 'Operational', 'Conference Room');
INSERT INTO Facility (facility_type_id, last_maintenance_time, production_time, status, facility_name)
VALUES (2, '2023-06-14 08:00:00', '2023-06-14 18:00:00', 'Under Maintenance', 'Swimming Pool');
INSERT INTO Facility (facility_type_id, last_maintenance_time, production_time, status, facility_name)
VALUES (3, '2023-06-16 14:00:00', '2023-06-16 17:00:00', 'Operational', 'Gymnasium');
INSERT INTO Facility (facility_type_id, last_maintenance_time, production_time, status, facility_name)
VALUES (4, '2023-06-17 09:00:00', '2023-06-17 10:30:00', 'Operational', 'Cafeteria');
INSERT INTO Facility (facility_type_id, last_maintenance_time, production_time, status, facility_name)
VALUES (5, '2023-06-18 13:00:00', '2023-06-18 15:00:00', 'Under Maintenance', 'Tennis Court');
INSERT INTO Facility (facility_type_id, last_maintenance_time, production_time, status, facility_name)
VALUES (6, '2023-06-19 11:00:00', '2023-06-19 12:30:00', 'Operational', 'Auditorium');
INSERT INTO Facility (facility_type_id, last_maintenance_time, production_time, status, facility_name)
VALUES (7, '2023-06-20 14:00:00', '2023-06-20 16:00:00', 'Operational', 'Outdoor Garden');
INSERT INTO Facility (facility_type_id, last_maintenance_time, production_time, status, facility_name)
VALUES (8, '2023-06-21 09:00:00', '2023-06-21 10:30:00', 'Under Maintenance', 'Game Room');
INSERT INTO Facility (facility_type_id, last_maintenance_time, production_time, status, facility_name)
VALUES (9, '2023-06-22 13:00:00', '2023-06-22 15:00:00', 'Operational', 'Spa and Wellness Center');
INSERT INTO Facility (facility_type_id, last_maintenance_time, production_time, status, facility_name)
VALUES (10, '2023-06-23 11:00:00', '2023-06-23 12:30:00', 'Operational', 'Library');
INSERT INTO Staff (staff_id, phone_number, name, position, email_address)
VALUES (1, '1234567890', 'John Doe', 'Manager', 'john.doe@example.com');
INSERT INTO Staff (staff_id, phone_number, name, position, email_address)
VALUES (2, '0987654321', 'Jane Smith', 'Assistant', 'jane.smith@example.com');
INSERT INTO Staff (staff_id, phone_number, name, position, email_address)
VALUES (3, '9876543210', 'Robert Johnson', 'Receptionist', 'robert.johnson@example.com');
INSERT INTO Staff (staff_id, phone_number, name, position, email_address)
VALUES (4, '4567890123', 'Sarah Davis', 'Trainer', 'sarah.davis@example.com');
INSERT INTO Staff (staff_id, phone_number, name, position, email_address)
VALUES (5, '0123456789', 'Michael Wilson', 'Chef', 'michael.wilson@example.com');
INSERT INTO Staff (staff_id, phone_number, name, position, email_address)
VALUES (6, '5678901234', 'Emily Thompson', 'Instructor', 'emily.thompson@example.com');
INSERT INTO Staff (staff_id, phone_number, name, position, email_address)
VALUES (7, '9012345678', 'David Brown', 'Security', 'david.brown@example.com');
INSERT INTO Staff (staff_id, phone_number, name, position, email_address)
VALUES (8, '3456789012', 'Jessica Lee', 'Housekeeping', 'jessica.lee@example.com');
INSERT INTO Staff (staff_id, phone_number, name, position, email_address)
VALUES (9, '7890123456', 'Daniel Taylor', 'Maintenance', 'daniel.taylor@example.com');
INSERT INTO Staff (staff_id, phone_number, name, position, email_address)
VALUES (10, '2345678901', 'Jennifer Harris', 'Waitstaff', 'jennifer.harris@example.com');
INSERT INTO Feedback (feedback_id, ID_card_number, feedback_content, feedback_time)
VALUES (1, '123456789012345678', 'Great experience! The activity was well organized.', '2023-06-16 11:30:00');
INSERT INTO Feedback (feedback_id, ID_card_number, feedback_content, feedback_time)
VALUES (2, '987654321098765432', 'The facility was clean and the staff was friendly.', '2023-06-16 15:00:00');
INSERT INTO Feedback (feedback_id, ID_card_number, feedback_content, feedback_time)
VALUES (3, '456789123987654321', 'I had a problem with my ticket, but it was resolved quickly.', '2023-06-16 17:45:00');
INSERT INTO Feedback (feedback_id, ID_card_number, feedback_content, feedback_time)
VALUES (4, '321654987456789012', 'The activity content could be improved.', '2023-06-17 10:30:00');
INSERT INTO Feedback (feedback_id, ID_card_number, feedback_content, feedback_time)
VALUES (5, '654789321012345678', 'The facility needs better maintenance.', '2023-06-17 14:00:00');
INSERT INTO Feedback (feedback_id, ID_card_number, feedback_content, feedback_time)
VALUES (6, '987123456567890123', 'The staff was unprofessional.', '2023-06-18 10:00:00');
INSERT INTO Feedback (feedback_id, ID_card_number, feedback_content, feedback_time)
VALUES (7, '321789654901234567', 'The activity exceeded my expectations.', '2023-06-18 12:45:00');
INSERT INTO Feedback (feedback_id, ID_card_number, feedback_content, feedback_time)
VALUES (8, '654321987345678901', 'I had a problem with my purchase, but it was resolved satisfactorily.', '2023-06-19 15:30:00');
INSERT INTO Feedback (feedback_id, ID_card_number, feedback_content, feedback_time)
VALUES (9, '987654321234567890', 'The facility has excellent amenities.', '2023-06-20 17:00:00');
INSERT INTO Feedback (feedback_id, ID_card_number, feedback_content, feedback_time)
VALUES (10, '789456321789012345', 'The activity instructor was very knowledgeable.', '2023-06-21 11:00:00');
INSERT INTO Visitor (ID_card_number, name, gender, phone_number)
VALUES ('123456789012345678', 'John Smith', 'M', '1234567890');
INSERT INTO Visitor (ID_card_number, name, gender, phone_number)
VALUES ('987654321098765432', 'Jane Doe', 'F', '0987654321');
INSERT INTO Visitor (ID_card_number, name, gender, phone_number)
VALUES ('456789123987654321', 'Robert Johnson', 'M', '9876543210');
INSERT INTO Visitor (ID_card_number, name, gender, phone_number)
VALUES ('321654987456789012', 'Sarah Davis', 'F', '4567890123');
INSERT INTO Visitor (ID_card_number, name, gender, phone_number)
VALUES ('654789321012345678', 'Michael Wilson', 'M', '0123456789');
INSERT INTO Visitor (ID_card_number, name, gender, phone_number)
VALUES ('987123456567890123', 'Emily Thompson', 'F', '5678901234');
INSERT INTO Visitor (ID_card_number, name, gender, phone_number)
VALUES ('321789654901234567', 'David Brown', 'M', '9012345678');
INSERT INTO Visitor (ID_card_number, name, gender, phone_number)
VALUES ('654321987345678901', 'Jessica Lee', 'F', '3456789012');
INSERT INTO Visitor (ID_card_number, name, gender, phone_number)
VALUES ('789456321789012345', 'Daniel Taylor', 'M', '7890123456');
INSERT INTO Visitor (ID_card_number, name, gender, phone_number)
VALUES ('987654321234567890', 'Jennifer Harris', 'F', '2345678901');
INSERT INTO Ticket (ticket_type_id, quantity)
VALUES (1, 100);
INSERT INTO Ticket (ticket_type_id, quantity)
VALUES (2, 50);
INSERT INTO Ticket (ticket_type_id, quantity)
VALUES (3, 75);
INSERT INTO Ticket (ticket_type_id, quantity)
VALUES (4, 200);
INSERT INTO Ticket (ticket_type_id, quantity)
VALUES (5, 150);
INSERT INTO Ticket (ticket_type_id, quantity)
VALUES (6, 100);
INSERT INTO Ticket (ticket_type_id, quantity)
VALUES (7, 80);
INSERT INTO Ticket (ticket_type_id, quantity)
VALUES (8, 120);
INSERT INTO Ticket (ticket_type_id, quantity)
VALUES (9, 60);
INSERT INTO Ticket (ticket_type_id, quantity)
VALUES (10, 90);
INSERT INTO Management (staff_id, facility_id)
VALUES (1, 1);
INSERT INTO Management (staff_id, facility_id)
VALUES (2, 2);
INSERT INTO Management (staff_id, facility_id)
VALUES (3, 3);
INSERT INTO Management (staff_id, facility_id)
VALUES (4, 4);
INSERT INTO Management (staff_id, facility_id)
VALUES (5, 5);
INSERT INTO Management (staff_id, facility_id)
VALUES (6, 6);
INSERT INTO Management (staff_id, facility_id)
VALUES (7, 7);
INSERT INTO Management (staff_id, facility_id)
VALUES (8, 8);
INSERT INTO Management (staff_id, facility_id)
VALUES (9, 9);
INSERT INTO Management (staff_id, facility_id)
VALUES (10, 10);
INSERT INTO Purchase (purchase_id, purchase_time, order_status, ID_card_number, ticket_type_id)
VALUES (1, '2023-06-16 10:30:00', 1, '123456789012345678', 1);
INSERT INTO Purchase (purchase_id, purchase_time, order_status, ID_card_number, ticket_type_id)
VALUES (2, '2023-06-16 15:30:00', 1, '987654321098765432', 2);
INSERT INTO Purchase (purchase_id, purchase_time, order_status, ID_card_number, ticket_type_id)
VALUES (3, '2023-06-16 17:00:00', 0, '456789123987654321', 3);
INSERT INTO Purchase (purchase_id, purchase_time, order_status, ID_card_number, ticket_type_id)
VALUES (4, '2023-06-17 11:00:00', 1, '321654987456789012', 4);
INSERT INTO Purchase (purchase_id, purchase_time, order_status, ID_card_number, ticket_type_id)
VALUES (5, '2023-06-17 14:30:00', 1, '654789321012345678', 5);
INSERT INTO Purchase (purchase_id, purchase_time, order_status, ID_card_number, ticket_type_id)
VALUES (6, '2023-06-18 09:30:00', 0, '987123456567890123', 6);
INSERT INTO Purchase (purchase_id, purchase_time, order_status, ID_card_number, ticket_type_id)
VALUES (7, '2023-06-18 12:00:00', 1, '321789654901234567', 7);
INSERT INTO Purchase (purchase_id, purchase_time, order_status, ID_card_number, ticket_type_id)
VALUES (8, '2023-06-19 14:00:00', 1, '654321987345678901', 8);
INSERT INTO Purchase (purchase_id, purchase_time, order_status, ID_card_number, ticket_type_id)
VALUES (9, '2023-06-20 16:30:00', 0, '789456321789012345', 9);
INSERT INTO Purchase (purchase_id, purchase_time, order_status, ID_card_number, ticket_type_id)
VALUES (10, '2023-06-21 10:00:00', 1, '987654321234567890', 10);
INSERT INTO Contain (facility_type_id, activity_id)
VALUES (1, 1);
INSERT INTO Contain (facility_type_id, activity_id)
VALUES (2, 2);
INSERT INTO Contain (facility_type_id, activity_id)
VALUES (3, 3);
INSERT INTO Contain (facility_type_id, activity_id)
VALUES (4, 4);
INSERT INTO Contain (facility_type_id, activity_id)
VALUES (5, 5);
INSERT INTO Contain (facility_type_id, activity_id)
VALUES (6, 6);
INSERT INTO Contain (facility_type_id, activity_id)
VALUES (7, 7);
INSERT INTO Contain (facility_type_id, activity_id)
VALUES (8, 8);
INSERT INTO Contain (facility_type_id, activity_id)
VALUES (9, 9);
INSERT INTO Contain (facility_type_id, activity_id)
VALUES (10, 10);