Table rates_grid

rateID	RMS_rateID	RMS_roomtypeID	RMS_propertyID	rate_descriptions	Datesell	DailyRate	Baserate	active_status	RoomAvailable
1	23	109	12		2024-06-17 00:00:00	210	350	1	4
2	23	109	12		2024-06-18 00:00:00	210	350	1	4
3	23	109	12		2024-06-19 00:00:00	210	350	1	4
4	23	109	12		2024-06-20 00:00:00	210	350	1	4
5	23	19	4		2024-06-17 00:00:00	3386243		1	4
6	23	19	4		2024-06-18 00:00:00	3386243	5643739	1	4
7	23	109	12		2024-06-21 00:00:00	210	350	1	4
8	23	19	4		2024-06-19 00:00:00	3386243	5643739	1	4
9	23	109	12		2024-06-22 00:00:00	222	371	1	4
10	23	19	4		2024-06-20 00:00:00	3386243	5643739	1	4
11	23	19	4		2024-06-21 00:00:00	3597884	5996473	1	4
12	23	109	12		2024-06-23 00:00:00	210	350	1	4
13	23	19	4		2024-06-22 00:00:00	3597884	5996473	1	4
14	23	109	12		2024-06-24 00:00:00	210	350	1	4
15	23	19	4		2024-06-23 00:00:00	3386243	5643739	1	4
16	23	109	12		2024-06-25 00:00:00	210	350	1	4
17	23	19	4		2024-06-24 00:00:00	3386243	5643739	1	4
18	23	109	12		2024-06-26 00:00:00	210	350	1	4
19	23	19	4		2024-06-25 00:00:00	3386243	5643739	1	4
20	23	109	12		2024-06-27 00:00:00	210	350	1	4

20

Table Room Types

roomtypeID	RMS_roomtypeID	RMS_categoryID	RMS_propertyID	short_description	long_description	ranking	std_adults	max_adults	max_pax	active_status
1	53	53	8	RV SUP TWN VHA	Superior River View Twin	1	2	3	4	1
2	54	54	8	RV SUP DBL VHA	Superior River View Double	1	2	3	4	1
3	55	55	8	GV SUP TWN VHA	Superior Garden View Twin	1	2	3	4	1
4	56	56	8	GV SUP DBL VHA	Superior Garden View Double	1	2	3	4	1
5	57	57	8	DLX TWN VHA	Deluxe Twin	2	2	3	4	1
6	58	58	8	DLX DBL VHA	Deluxe Double	2	2	3	4	1
7	59	59	8	J SUITE TWN VHA	Junior Suite Twin	3	2	3	4	1
8	60	60	8	J SUITE DBL VHA	Junior Suite Double	3	2	3	4	1
9	61	61	8	SUITE VHA	Suite	4	2	3	4	1
10	75	75	9	SUP DBL VCT	Superior Double	1	2	3	4	1
11	76	76	9	SUP TWN VCT	Superior Twin	1	2	3	4	1
12	77	77	9	DLX DBL VCT	Deluxe Double	2	2	3	4	1
13	78	78	9	DLX TWN VCT	Deluxe Twin	2	2	3	4	1
14	79	79	9	SUITE DBL VCT	Suite Double	4	2	3	4	1
15	80	80	9	SUITE TWN VCT	Suite Twin	4	2	3	4	1
16	119	119	9	DLX DBL 2ND VCT	Deluxe Double with balcony & pool view	3	2	3	4	1
17	120	120	9	DLX TWN 2ND VCT	Deluxe Twin with balcony & pool view	3	2	3	4	1
18	3	3	3	SUP DBL VCD	Superior Double	1	2	3	4	1
19	23	23	3	SUP TWN VCD	Superior Twin	1	2	3	4	1
20	24	24	3	DLX RV DBL VCD	Deluxe River View Double	3	2	3	4	1
21	25	25	3	DLX RV TWN VCD	Deluxe River View Twin	3	2	3	4	1
22	26	26	3	SUITE VCD	Junior Suite	4	2	3	4	1
23	121	121	3	DLX GV DBL VCD	Deluxe Garden View Double	2	2	3	4	1
24	122	122	3	DLX GV TWN VCD	Deluxe Garden View Twin	2	2	3	4	1
25	4	4	4	SUP DBL VNS	Superior Double	1	2	2	4	1
26	15	15	4	SUP TWN VNS	Superior Twin	1	2	2	4	1
27	16	16	4	DLX PD DBL VNS	Deluxe Double Paddy	3	2	3	4	1
28	17	17	4	DLX PD TWN VNS	Deluxe Twin Paddy	3	2	3	4	1
29	18	18	4	FML DBL VNS	Family Double	4	3	4	4	1
30	19	19	4	FML TWN VNS	Family Twin	4	3	4	4	1
31	123	123	4	DLX GD DBL VNS	Deluxe Double Garden	2	2	3	4	1
32	124	124	4	DLX GD TWN VNS	Deluxe Twin Garden	2	2	3	4	1
33	105	105	12	SUD VXT	Palace Double	1	2	3	4	1
34	106	106	12	SUT VXT	Palace Twin	1	2	3	4	1
35	107	107	12	VIS VXT	Victoria Suite	2	2	3	4	1
36	108	108	12	XTV VXT	Xiengthong Villa	2	2	3	4	1
37	109	109	12	MKS VXT	Mekong Suite	2	2	3	4	1

37

Table rates

RMS_rateID	RMS_roomtypeID	RMS_categoryID	RMS_propertyID	ranking	rate_name
15	53	53	8	1	Book Early & Save
15	54	54	8	1	Book Early & Save
15	55	55	8	1	Book Early & Save
15	56	56	8	1	Book Early & Save
15	57	57	8	2	Book Early & Save
15	58	58	8	2	Book Early & Save
15	59	59	8	3	Book Early & Save
15	60	60	8	3	Book Early & Save
15	61	61	8	4	Book Early & Save
15	75	75	9	1	Book Early & Save
15	76	76	9	1	Book Early & Save
15	77	77	9	2	Book Early & Save
15	78	78	9	2	Book Early & Save
15	79	79	9	4	Book Early & Save
15	80	80	9	4	Book Early & Save
15	119	119	9	3	Book Early & Save
15	120	120	9	3	Book Early & Save
15	3	3	3	1	Book Early & Save
15	23	23	3	1	Book Early & Save
15	24	24	3	3	Book Early & Save
15	25	25	3	3	Book Early & Save
15	26	26	3	4	Book Early & Save
15	121	121	3	2	Book Early & Save
15	122	122	3	2	Book Early & Save
15	4	4	4	1	Book Early & Save
15	15	15	4	1	Book Early & Save
15	16	16	4	3	Book Early & Save
15	17	17	4	3	Book Early & Save
15	18	18	4	4	Book Early & Save
15	19	19	4	4	Book Early & Save
15	123	123	4	2	Book Early & Save
15	124	124	4	2	Book Early & Save
15	105	105	12	1	Book Early & Save
15	106	106	12	1	Book Early & Save
15	107	107	12	2	Book Early & Save
15	108	108	12	2	Book Early & Save
15	109	109	12	2	Book Early & Save
23	53	53	8	1	Special Deal
23	54	54	8	1	Special Deal
23	55	55	8	1	Special Deal
23	56	56	8	1	Special Deal
23	57	57	8	2	Special Deal
23	58	58	8	2	Special Deal
23	59	59	8	3	Special Deal
23	60	60	8	3	Special Deal
23	61	61	8	4	Special Deal
23	75	75	9	1	Special Deal
23	76	76	9	1	Special Deal
23	77	77	9	2	Special Deal
23	78	78	9	2	Special Deal
23	79	79	9	4	Special Deal
23	80	80	9	4	Special Deal
23	119	119	9	3	Special Deal
23	120	120	9	3	Special Deal
23	3	3	3	1	Special Deal
23	23	23	3	1	Special Deal
23	24	24	3	3	Special Deal
23	25	25	3	3	Special Deal
23	26	26	3	4	Special Deal
23	121	121	3	2	Special Deal
23	122	122	3	2	Special Deal
23	4	4	4	1	Special Deal
23	15	15	4	1	Special Deal
23	16	16	4	3	Special Deal
23	17	17	4	3	Special Deal
23	18	18	4	4	Special Deal
23	19	19	4	4	Special Deal
23	123	123	4	2	Special Deal
23	124	124	4	2	Special Deal
23	105	105	12	1	Special Deal
23	106	106	12	1	Special Deal
23	107	107	12	2	Special Deal
23	108	108	12	2	Special Deal
23	109	109	12	2	Special Deal
1106	53	53	8	1	Flexible Rate
1106	54	54	8	1	Flexible Rate
1106	55	55	8	1	Flexible Rate
1106	56	56	8	1	Flexible Rate
1106	57	57	8	2	Flexible Rate
1106	58	58	8	2	Flexible Rate
1106	59	59	8	3	Flexible Rate
1106	60	60	8	3	Flexible Rate
1106	61	61	8	4	Flexible Rate
1106	75	75	9	1	Flexible Rate
1106	76	76	9	1	Flexible Rate
1106	77	77	9	2	Flexible Rate
1106	78	78	9	2	Flexible Rate
1106	79	79	9	4	Flexible Rate
1106	80	80	9	4	Flexible Rate
1106	119	119	9	3	Flexible Rate
1106	120	120	9	3	Flexible Rate
1106	3	3	3	1	Flexible Rate
1106	23	23	3	1	Flexible Rate
1106	24	24	3	3	Flexible Rate
1106	25	25	3	3	Flexible Rate
1106	26	26	3	4	Flexible Rate
1106	121	121	3	2	Flexible Rate
1106	122	122	3	2	Flexible Rate
1106	4	4	4	1	Flexible Rate
1106	15	15	4	1	Flexible Rate
1106	16	16	4	3	Flexible Rate
1106	17	17	4	3	Flexible Rate
1106	18	18	4	4	Flexible Rate
1106	19	19	4	4	Flexible Rate
1106	123	123	4	2	Flexible Rate
1106	124	124	4	2	Flexible Rate
1106	105	105	12	1	Flexible Rate
1106	106	106	12	1	Flexible Rate
1106	107	107	12	2	Flexible Rate
1106	108	108	12	2	Flexible Rate
1106	109	109	12	2	Flexible Rate
1115	53	53	8	1	Stay 6 Pay 5
1115	54	54	8	1	Stay 6 Pay 5
1115	55	55	8	1	Stay 6 Pay 5
1115	56	56	8	1	Stay 6 Pay 5
1115	57	57	8	2	Stay 6 Pay 5
1115	58	58	8	2	Stay 6 Pay 5
1115	59	59	8	3	Stay 6 Pay 5
1115	60	60	8	3	Stay 6 Pay 5
1115	61	61	8	4	Stay 6 Pay 5
1115	75	75	9	1	Stay 6 Pay 5
1115	76	76	9	1	Stay 6 Pay 5
1115	77	77	9	2	Stay 6 Pay 5
1115	78	78	9	2	Stay 6 Pay 5
1115	79	79	9	4	Stay 6 Pay 5
1115	80	80	9	4	Stay 6 Pay 5
1115	119	119	9	3	Stay 6 Pay 5
1115	120	120	9	3	Stay 6 Pay 5
1115	3	3	3	1	Stay 6 Pay 5
1115	23	23	3	1	Stay 6 Pay 5
1115	24	24	3	3	Stay 6 Pay 5
1115	25	25	3	3	Stay 6 Pay 5
1115	26	26	3	4	Stay 6 Pay 5
1115	121	121	3	2	Stay 6 Pay 5
1115	122	122	3	2	Stay 6 Pay 5
1115	4	4	4	1	Stay 6 Pay 5
1115	15	15	4	1	Stay 6 Pay 5
1115	16	16	4	3	Stay 6 Pay 5
1115	17	17	4	3	Stay 6 Pay 5
1115	18	18	4	4	Stay 6 Pay 5
1115	19	19	4	4	Stay 6 Pay 5
1115	123	123	4	2	Stay 6 Pay 5
1115	124	124	4	2	Stay 6 Pay 5
1115	105	105	12	1	Stay 6 Pay 5
1115	106	106	12	1	Stay 6 Pay 5
1115	107	107	12	2	Stay 6 Pay 5
1115	108	108	12	2	Stay 6 Pay 5
1115	109	109	12	2	Stay 6 Pay 5
17	53	53	8	1	Base rate
17	54	54	8	1	Base rate
17	55	55	8	1	Base rate
17	56	56	8	1	Base rate
17	57	57	8	2	Base rate
17	58	58	8	2	Base rate
17	59	59	8	3	Base rate
17	60	60	8	3	Base rate
17	61	61	8	4	Base rate
17	75	75	9	1	Base rate
17	76	76	9	1	Base rate
17	77	77	9	2	Base rate
17	78	78	9	2	Base rate
17	79	79	9	4	Base rate
17	80	80	9	4	Base rate
17	119	119	9	3	Base rate
17	120	120	9	3	Base rate
17	3	3	3	1	Base rate
17	23	23	3	1	Base rate
17	24	24	3	3	Base rate
17	25	25	3	3	Base rate
17	26	26	3	4	Base rate
17	121	121	3	2	Base rate
17	122	122	3	2	Base rate
17	4	4	4	1	Base rate
17	15	15	4	1	Base rate
17	16	16	4	3	Base rate
17	17	17	4	3	Base rate
17	18	18	4	4	Base rate
17	19	19	4	4	Base rate
17	123	123	4	2	Base rate
17	124	124	4	2	Base rate
17	105	105	12	1	Base rate
17	106	106	12	1	Base rate
17	107	107	12	2	Base rate
17	108	108	12	2	Base rate
17	109	109	12	2	Base rate

185

Table hotels

hotelID	hotel_code	hotel_name	active_status	RMS_propertyID	RMS_clientID
1	VHA	Victoria Hoi An Beach Resort & Spa	1	8	16577
2	VCT	Victoria Can Tho Resort	1	9	16808
3	VCD	Victoria Chau Doc Hotel	1	3	16129
4	VNS	Victoria Nui Sam Lodge	1	4	16130
5	VXP	Victoria Xiengthong Palace	1	12	17232

5