Mimer SQL User's Manual TOC PREV NEXT INDEX

Mimer Developer Site

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
Mimer SQL User's Manual TOC PREV NEXT INDEX