00001 ADD TABLE "checkout" 00002 AREA "Schema Area" 00003 DUMP-NAME "checkout" 00004 00005 ADD FIELD "reservation-id" OF "checkout" AS integer 00006 FORMAT ">,>>>,>>9" 00007 INITIAL "0" 00008 LABEL "Reservation Number" 00009 POSITION 2 00010 MAX-WIDTH 4 00011 COLUMN-LABEL "Reservation Number" 00012 ORDER 10 00013 00014 ADD FIELD "room-charges" OF "checkout" AS decimal 00015 FORMAT "$>>,>>9.99" 00016 INITIAL "0" 00017 LABEL "Room Charges" 00018 POSITION 3 00019 MAX-WIDTH 17 00020 COLUMN-LABEL "Room Charges" 00021 DECIMALS 2 00022 ORDER 20 00023 00024 ADD FIELD "sales-tax" OF "checkout" AS decimal 00025 FORMAT "$>>>,>>9.99" 00026 INITIAL "0" 00027 LABEL "Sales Tax" 00028 POSITION 4 00029 MAX-WIDTH 17 00030 COLUMN-LABEL "Sales Tax" 00031 DECIMALS 2 00032 ORDER 30 00033 00034 ADD FIELD "total" OF "checkout" AS decimal 00035 FORMAT "$>>>,>>9.99" 00036 INITIAL "0" 00037 LABEL "Total" 00038 POSITION 5 00039 MAX-WIDTH 17 00040 COLUMN-LABEL "Total" 00041 DECIMALS 2 00042 ORDER 40 00043 00044 ADD FIELD "state" OF "checkout" AS character 00045 FORMAT "x(1)" 00046 INITIAL "" 00047 LABEL "State" 00048 POSITION 6 00049 MAX-WIDTH 2 00050 COLUMN-LABEL "State" 00051 ORDER 50 00052 00053 ADD INDEX "idx-r-id" ON "checkout" 00054 AREA "Schema Area" 00055 UNIQUE 00056 PRIMARY 00057 INDEX-FIELD "reservation-id" ASCENDING 00058 00059 ADD TABLE "checkout-rooms" 00060 AREA "Schema Area" 00061 DUMP-NAME "checkout-rooms" 00062 00063 ADD FIELD "reservation-id" OF "checkout-rooms" AS integer 00064 FORMAT ">,>>>,>>9" 00065 INITIAL "0" 00066 LABEL "ID" 00067 POSITION 2 00068 MAX-WIDTH 4 00069 COLUMN-LABEL "ID" 00070 ORDER 10 00071 00072 ADD FIELD "guest-ids" OF "checkout-rooms" AS integer 00073 FORMAT ">>>,>>9" 00074 INITIAL "0" 00075 LABEL "Guests" 00076 POSITION 3 00077 MAX-WIDTH 64 00078 COLUMN-LABEL "Guests" 00079 EXTENT 4 00080 ORDER 20 00081 00082 ADD FIELD "minibar-charges" OF "checkout-rooms" AS decimal 00083 FORMAT "$>>,>>9.99" 00084 INITIAL "0" 00085 LABEL "Minibar Charges" 00086 POSITION 4 00087 MAX-WIDTH 17 00088 COLUMN-LABEL "Minibar Charges" 00089 DECIMALS 2 00090 ORDER 30 00091 00092 ADD FIELD "laundry-charges" OF "checkout-rooms" AS decimal 00093 FORMAT "$>,>>9.99" 00094 INITIAL "0" 00095 LABEL "Laundry Charges" 00096 POSITION 5 00097 MAX-WIDTH 17 00098 COLUMN-LABEL "Laundry Charges" 00099 DECIMALS 2 00100 ORDER 40 00101 00102 ADD FIELD "room-charges" OF "checkout-rooms" AS decimal 00103 FORMAT "$>>,>>9.99" 00104 INITIAL "0" 00105 LABEL "Room Charges" 00106 POSITION 6 00107 MAX-WIDTH 17 00108 COLUMN-LABEL "Room Charges" 00109 DECIMALS 2 00110 ORDER 50 00111 00112 ADD FIELD "room-number" OF "checkout-rooms" AS integer 00113 FORMAT ">>9" 00114 INITIAL "0" 00115 LABEL "Room Number" 00116 POSITION 7 00117 MAX-WIDTH 4 00118 COLUMN-LABEL "Room Number" 00119 ORDER 60 00120 MANDATORY 00121 00122 ADD INDEX "idx-rc-room" ON "checkout-rooms" 00123 AREA "Schema Area" 00124 PRIMARY 00125 INDEX-FIELD "room-number" ASCENDING 00126 00127 ADD TABLE "guest" 00128 AREA "Schema Area" 00129 DUMP-NAME "guest" 00130 00131 ADD FIELD "guest-id" OF "guest" AS integer 00132 FORMAT ">,>>>,>>9" 00133 INITIAL "0" 00134 LABEL "Guest ID" 00135 POSITION 2 00136 MAX-WIDTH 4 00137 COLUMN-LABEL "Guest ID" 00138 ORDER 10 00139 00140 ADD FIELD "first-name" OF "guest" AS character 00141 FORMAT "x(25)" 00142 INITIAL "" 00143 LABEL "First Name" 00144 POSITION 3 00145 MAX-WIDTH 50 00146 COLUMN-LABEL "First Name" 00147 ORDER 20 00148 00149 ADD FIELD "last-name" OF "guest" AS character 00150 FORMAT "x(25)" 00151 INITIAL "" 00152 LABEL "Last Name" 00153 POSITION 4 00154 MAX-WIDTH 50 00155 COLUMN-LABEL "Last Name" 00156 ORDER 30 00157 00158 ADD FIELD "id-type" OF "guest" AS integer 00159 FORMAT "9" 00160 INITIAL "0" 00161 LABEL "ID Type" 00162 POSITION 5 00163 MAX-WIDTH 4 00164 COLUMN-LABEL "ID Type" 00165 ORDER 40 00166 00167 ADD FIELD "id-number" OF "guest" AS character 00168 FORMAT "x(20)" 00169 INITIAL "" 00170 LABEL "ID Number" 00171 POSITION 6 00172 MAX-WIDTH 40 00173 COLUMN-LABEL "ID Number" 00174 ORDER 50 00175 00176 ADD FIELD "date-of-birth" OF "guest" AS date 00177 FORMAT "99/99/99" 00178 INITIAL ? 00179 LABEL "Date of Birth" 00180 POSITION 7 00181 MAX-WIDTH 4 00182 COLUMN-LABEL "Date of Birth" 00183 ORDER 60 00184 00185 ADD FIELD "phone-number" OF "guest" AS character 00186 FORMAT "(999)999-9999" 00187 INITIAL "" 00188 LABEL "Phone #" 00189 POSITION 8 00190 MAX-WIDTH 30 00191 COLUMN-LABEL "Phone #" 00192 ORDER 70 00193 00194 ADD FIELD "country" OF "guest" AS character 00195 FORMAT "x(25)" 00196 INITIAL "" 00197 LABEL "Country" 00198 POSITION 9 00199 MAX-WIDTH 50 00200 COLUMN-LABEL "Country" 00201 ORDER 80 00202 00203 ADD FIELD "city" OF "guest" AS character 00204 FORMAT "x(25)" 00205 INITIAL "" 00206 LABEL "City" 00207 POSITION 10 00208 MAX-WIDTH 50 00209 COLUMN-LABEL "City" 00210 ORDER 90 00211 00212 ADD FIELD "street-2" OF "guest" AS character 00213 FORMAT "x(25)" 00214 INITIAL "" 00215 LABEL "Street 2" 00216 POSITION 11 00217 MAX-WIDTH 50 00218 COLUMN-LABEL "Street 2" 00219 ORDER 100 00220 00221 ADD FIELD "street-1" OF "guest" AS character 00222 FORMAT "x(25)" 00223 INITIAL "" 00224 LABEL "Street 1" 00225 POSITION 12 00226 MAX-WIDTH 80 00227 COLUMN-LABEL "Street 2" 00228 ORDER 110 00229 00230 ADD FIELD "state" OF "guest" AS character 00231 FORMAT "x(25)" 00232 INITIAL "" 00233 LABEL "State/Province" 00234 POSITION 13 00235 MAX-WIDTH 50 00236 COLUMN-LABEL "State/Province" 00237 ORDER 120 00238 00239 ADD FIELD "zip" OF "guest" AS character 00240 FORMAT "x(10)" 00241 INITIAL "" 00242 LABEL "Postal Code" 00243 POSITION 14 00244 MAX-WIDTH 20 00245 COLUMN-LABEL "Postal Code" 00246 ORDER 130 00247 00248 ADD INDEX "idx-g-id" ON "guest" 00249 AREA "Schema Area" 00250 UNIQUE 00251 PRIMARY 00252 INDEX-FIELD "guest-id" ASCENDING 00253 00254 ADD TABLE "rate" 00255 AREA "Schema Area" 00256 DUMP-NAME "rate" 00257 00258 ADD FIELD "type-of-room" OF "rate" AS integer 00259 FORMAT ">>9" 00260 INITIAL "0" 00261 LABEL "Type of Room" 00262 POSITION 2 00263 MAX-WIDTH 4 00264 COLUMN-LABEL "Type of Room" 00265 ORDER 10 00266 MANDATORY 00267 00268 ADD FIELD "floor" OF "rate" AS integer 00269 FORMAT ">>9" 00270 INITIAL "0" 00271 LABEL "Floor" 00272 POSITION 3 00273 MAX-WIDTH 4 00274 COLUMN-LABEL "Floor" 00275 ORDER 20 00276 MANDATORY 00277 00278 ADD FIELD "rate" OF "rate" AS decimal 00279 FORMAT "->>,>>9.99" 00280 INITIAL "0" 00281 LABEL "Rate" 00282 POSITION 4 00283 MAX-WIDTH 17 00284 COLUMN-LABEL "Rate" 00285 DECIMALS 2 00286 ORDER 30 00287 MANDATORY 00288 00289 ADD FIELD "start-date" OF "rate" AS date 00290 FORMAT "99/99/99" 00291 INITIAL ? 00292 LABEL "From Date" 00293 POSITION 5 00294 MAX-WIDTH 4 00295 COLUMN-LABEL "From Date" 00296 ORDER 40 00297 00298 ADD FIELD "end-date" OF "rate" AS date 00299 FORMAT "99/99/99" 00300 INITIAL ? 00301 LABEL "To Date" 00302 POSITION 6 00303 MAX-WIDTH 4 00304 COLUMN-LABEL "To Date" 00305 ORDER 50 00306 00307 ADD INDEX "idx-rate-s-date" ON "rate" 00308 AREA "Schema Area" 00309 PRIMARY 00310 INDEX-FIELD "start-date" ASCENDING 00311 00312 ADD INDEX "idx-rate-e-date" ON "rate" 00313 AREA "Schema Area" 00314 INDEX-FIELD "end-date" ASCENDING 00315 00316 ADD TABLE "reservation" 00317 AREA "Schema Area" 00318 DUMP-NAME "reservation" 00319 00320 ADD FIELD "reservation-id" OF "reservation" AS integer 00321 FORMAT ">,>>>,>>9" 00322 INITIAL "0" 00323 LABEL "Reservation Number" 00324 POSITION 2 00325 MAX-WIDTH 4 00326 COLUMN-LABEL "Reservation Number" 00327 ORDER 10 00328 MANDATORY 00329 00330 ADD FIELD "discount" OF "reservation" AS decimal 00331 FORMAT ">>9.99%" 00332 INITIAL "0" 00333 LABEL "Discount %" 00334 POSITION 3 00335 MAX-WIDTH 17 00336 COLUMN-LABEL "Discount %" 00337 DECIMALS 2 00338 ORDER 20 00339 00340 ADD FIELD "date" OF "reservation" AS date 00341 FORMAT "99/99/99" 00342 INITIAL ? 00343 LABEL "Date" 00344 POSITION 4 00345 MAX-WIDTH 4 00346 COLUMN-LABEL "Date" 00347 ORDER 30 00348 00349 ADD FIELD "checkin" OF "reservation" AS date 00350 FORMAT "99/99/99" 00351 INITIAL ? 00352 LABEL "Checkin" 00353 POSITION 5 00354 MAX-WIDTH 4 00355 COLUMN-LABEL "Checkin" 00356 ORDER 40 00357 00358 ADD FIELD "checkout" OF "reservation" AS date 00359 FORMAT "99/99/99" 00360 INITIAL ? 00361 LABEL "Checkout" 00362 POSITION 6 00363 MAX-WIDTH 4 00364 COLUMN-LABEL "Checkout" 00365 ORDER 50 00366 00367 ADD FIELD "guest-id" OF "reservation" AS integer 00368 FORMAT ">,>>>,>>9" 00369 INITIAL "0" 00370 LABEL "Guest ID" 00371 POSITION 7 00372 MAX-WIDTH 4 00373 COLUMN-LABEL "Guest ID" 00374 ORDER 60 00375 00376 ADD FIELD "details" OF "reservation" AS character 00377 FORMAT "x(100)" 00378 INITIAL "" 00379 LABEL "Details" 00380 POSITION 8 00381 MAX-WIDTH 200 00382 COLUMN-LABEL "Details" 00383 ORDER 70 00384 00385 ADD FIELD "state" OF "reservation" AS character 00386 FORMAT "x(1)" 00387 INITIAL "" 00388 LABEL "State" 00389 POSITION 9 00390 MAX-WIDTH 2 00391 COLUMN-LABEL "State" 00392 ORDER 80 00393 00394 ADD INDEX "idx-r-id" ON "reservation" 00395 AREA "Schema Area" 00396 UNIQUE 00397 PRIMARY 00398 INDEX-FIELD "reservation-id" ASCENDING 00399 00400 ADD INDEX "idx-r-checkin" ON "reservation" 00401 AREA "Schema Area" 00402 INDEX-FIELD "checkin" ASCENDING 00403 00404 ADD TABLE "reservation-rooms" 00405 AREA "Schema Area" 00406 DUMP-NAME "reservation-rooms" 00407 00408 ADD FIELD "reservation-id" OF "reservation-rooms" AS integer 00409 FORMAT ">,>>>,>>9" 00410 INITIAL "0" 00411 LABEL "ID" 00412 POSITION 2 00413 MAX-WIDTH 4 00414 COLUMN-LABEL "ID" 00415 ORDER 10 00416 00417 ADD FIELD "type-of-room" OF "reservation-rooms" AS integer 00418 FORMAT ">>9" 00419 INITIAL "0" 00420 LABEL "Type of Room" 00421 POSITION 3 00422 MAX-WIDTH 4 00423 COLUMN-LABEL "Type of Room" 00424 ORDER 20 00425 MANDATORY 00426 00427 ADD FIELD "rooms" OF "reservation-rooms" AS integer 00428 FORMAT ">>9" 00429 INITIAL "0" 00430 LABEL "No. of Rooms" 00431 POSITION 4 00432 MAX-WIDTH 4 00433 COLUMN-LABEL "No. of Rooms" 00434 ORDER 30 00435 00436 ADD TABLE "room" 00437 AREA "Schema Area" 00438 DUMP-NAME "room" 00439 00440 ADD FIELD "type-of-room" OF "room" AS integer 00441 FORMAT ">>9" 00442 INITIAL "0" 00443 LABEL "Type of Room" 00444 POSITION 2 00445 MAX-WIDTH 4 00446 COLUMN-LABEL "Type of Room" 00447 ORDER 10 00448 MANDATORY 00449 00450 ADD FIELD "room-number" OF "room" AS integer 00451 FORMAT ">>9" 00452 INITIAL "0" 00453 LABEL "Room Number" 00454 POSITION 3 00455 MAX-WIDTH 4 00456 COLUMN-LABEL "Room Number" 00457 ORDER 20 00458 MANDATORY 00459 00460 ADD FIELD "floor" OF "room" AS integer 00461 FORMAT ">>9" 00462 INITIAL "0" 00463 LABEL "Floor" 00464 POSITION 4 00465 MAX-WIDTH 4 00466 COLUMN-LABEL "Floor" 00467 ORDER 30 00468 MANDATORY 00469 00470 ADD INDEX "idx-r-no" ON "room" 00471 AREA "Schema Area" 00472 UNIQUE 00473 PRIMARY 00474 INDEX-FIELD "room-number" ASCENDING 00475 00476 ADD TABLE "room-state" 00477 AREA "Schema Area" 00478 DUMP-NAME "room-state" 00479 00480 ADD FIELD "room-number" OF "room-state" AS integer 00481 FORMAT ">>9" 00482 INITIAL "0" 00483 LABEL "Room Number" 00484 POSITION 2 00485 MAX-WIDTH 4 00486 COLUMN-LABEL "Room Number" 00487 ORDER 10 00488 MANDATORY 00489 00490 ADD FIELD "state" OF "room-state" AS logical 00491 FORMAT "Active/Inactive" 00492 INITIAL "no" 00493 LABEL "Room State" 00494 POSITION 3 00495 MAX-WIDTH 1 00496 ORDER 20 00497 MANDATORY 00498 00499 ADD FIELD "start-date" OF "room-state" AS date 00500 FORMAT "99/99/99" 00501 INITIAL ? 00502 LABEL "Date" 00503 POSITION 4 00504 MAX-WIDTH 4 00505 COLUMN-LABEL "Date" 00506 ORDER 30 00507 00508 . 00509 PSC 00510 cpstream=ISO8859-15 00511 . 00512 0000009337