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