www.mimer.com/developer

Table Contents

---

This section illustrates the contents of the tables in the example database.

Note: Only partial data is shown for some tables.

Hotel Table

HOTELCODE	NAME	CITY
LAP	LAPONIA	STOCKHOLM
SKY	SKYLINE	UPPSALA
STG	ST. GEORGE	STOCKHOLM
WIN	Winston	London
WIND	WINSTON	COPENHAGEN
WINS	WINSTON	GOTHENBURG

ROOMSTATUS Table

STATUS
UNKNOWN
FREE
KEY OUT
MAINT

ROOMTYPES Table

ROOMTYPE	DESCRIPTION
NSDBLB	NO SMOKING - DOUBLE WITH BATH
NSDBLS	NO SMOKING - DOUBLE WITH SHOWER
NSSGLB	NO SMOKING - SINGLE WITH BATH
NSSGLS	NO SMOKING - SINGLE WITH SHOWER
SDBLB	SMOKING - DOUBLE WITH BATH
SDBLS	SMOKING - DOUBLE WITH SHOWER
SSGLB	SMOKING - SINGLE WITH BATH
SSGLS	SMOKING - SINGLE WITH SHOWER

ROOMS Table

ROOMNO	HOTELCODE	ROOMTYPE	STATUS
LAP110	LAP	SSGLS	FREE
LAP211	LAP	NSDBLB	UNKNOWN
LAP309	LAP	NSSGLS	UNKNOWN
...	...	...
SKY117	SKY	NSSGLS	UNKNOWN
SKY121	SKY	NSDBLS	MAINT
...	...	...
SKY111	SKY	SSGLB	KEY OUT
SKY114	SKY	SSGLB	UNKNOWN
...	...	...
WIND308	WIND	NSSGLB	UNKNOWN
WIND524	WIND	SDBLB	UNKNOWN
...	...	...
WINS108	WINS	NSDBLB	FREE
WINS109	WINS	NSSGLB	UNKNOWN
WINS116	WINS	NSDBLB	UNKNOWN

ROOM_PRICES Table

HOTELCODE	ROOMTYPE	FROM_DATE	FROM_DATE	PRICE
LAP	NSSGLS	1997-11-15	1998-03-10	640
LAP	NSSGLS	1997-08-08	1997-11-14	680
...	...	...	...	...
SKY	NSSGLS	1997-08-08	1997-11-14	750
...	...	...	...	...
STG	NSSGLS	1997-11-15	1998-03-10	640
STG	NSSGLS	1997-08-08	1997-11-14	680

CHARGES Table

CHARGE_CODE	DESCRIPTION	CHARGE_PRICE
100	LODGING	100
120	TELEPHONE	40
170	CAR PARK	70
200	RESTAURANT	250
210	MINIBAR	70
230	BAR	200
270	ROOM SERVICE	95
330	LAUNDRY	120
720	EXTRA BED	370
700	ROOM	-
900	MISCELLANEOUS	30

BOOK_GUEST Table

RESERVATION	BOOKING_DATE	HOTELCODE	ROOMTYPE	COMPANY
1348	1997-06-10	LAP	NSSGLB	MIMER IT AB
1349	1997-06-10	LAP	NSSGLS	MIMER AB
1350	1997-06-11	SKY	SDBLB	SALLY WEBERT
1351	1997-06-11	SKY	NSDBLB	SALLY WEBERT
1352	1997-06-11	WINS	NSDBLB	MARK FRANCIS
...	...	...	...	...
...	...	...	...	...

TELEPHONE	RESERVED_FNAME	RESERVED_LNAME	ARRIVE	DEPART
018-185210	STEN	JOHANSEN	1997-08-20	1997-08-22
018-185210	MATS	LINDBLOM	1997-06-30	1997-07-01
0760-57609	SALLY	WEBERT	1997-08-21	1997-08-24
0760-57609	JOHN	ALBERTSON	1997-06-11	1997-06-15
08-320668	MARK	FRANCIS	1997-06-19	1997-06-20
...	...	...	...	...
...	...	...	...	...

GUEST_FNAME	GUEST_LNAME	ADDRESS
STEN	JOHANSEN	MIMERGATAN 4, UPPSALA
STEFAN	HANSEN	IDUNGATAN 24, UPPSALA
SALLY	WEBERT	KRONPARKEN 44, JOKKMOKK
ANNA	ALBERTSON	32 SPRING DRIVE, DENVER, USA
MARK	FRANCIS	VIMPELGATAN 7, SKARA
...	...	...
...	...	...

CHECKIN	CHECKOUT	ROOMNO	PAYMENT
1997-08-20	1997-08-22	STG009	EUROCARD
1997-06-30	1997-07-01	LAP206	EUROCARD
1997-08-21	1997-08-22	SKY212	CASH
1997-06-11	1997-06-15	SKY125	AM.EXPR
1997-06-19	1997-06-20	WINS103	EUROCARD
...	...	...	...
...	...	...	...

BILL Table

RESERVATION	ON_DATE	CHARGE_CODE	COST
1347	1997-08-21 13:38:19	100	100
1347	1997-08-21 13:38:19	120	40
...	...	...	...
1347	1997-08-21 13:38:19	120	40
...	...	...	...
1348	1997-08-21 13:38:19	230	200
...	...	...	...
1349	1997-06-30 13:38:19	170	70
1349	1997-06-30 13:38:19	900	30
...	...	...	...
1350	1997-08-21 13:38:19	100	100
...	...	...	...
1350	1997-08-21 13:38:19	230	200
1350	1997-08-21 13:38:19	330	120
1350	1997-08-21 13:38:19	100	100
1350	1997-08-21 13:38:19	120	40
1350	1997-08-21 13:38:19	270	95
...	...	...	...

WAKE_UP Table

ROOMNO	WAKE_DATE	WAKE_TIME
LAP112	1997-08-22	06:00:00
LAP112	1997-08-23	07:00:00
LAP201	1997-08-23	06:45:00
LAP205	1997-08-22	08:00:00
SKY101	1997-08-22	09:00:00
SKY110	1997-08-22	07:30:00
SKY111	1997-08-22	06:00:00
SKY124	1997-08-22	06:15:00
SKY124	1997-08-23	06:15:00
SKY124	1997-08-24	06:15:00
SKY201	1997-08-22	10:00:00
SKY212	1997-08-22	04:30:00
STG009	1997-08-22	06:00:00
STG117	1997-08-22	07:00:00
STG142	1997-08-22	08:30:00
WIND401	1997-08-23	06:00:00
WIND402	1997-08-22	06:20:00
WIND514	1997-08-22	07:00:00
WINS119	1997-08-22	08:00:00
WINS120	1997-08-22	07:30:00
WINS121	1997-08-22	06:20:00

EXCHANGE_RATE Table

CURRENCY	RATE
DEM	0.2230
DKK	0.8495
FIM	0.6560
FRF	0.7420
GBP	0.0810
ITL	206.82
JPY	16.38
NOK	0.8815
SEK	1.000
USD	0.1330

Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se