TABLE (9 in 1 files)

Filename Line # Column # Match Text
./data/namespace/hotel.schema 00001 00005
checkout [TABLE] @1:5
   reservation-id [FIELD_INT] @5:5
      INITIAL [KW_INIT] @7:3
         0 [NUM_LITERAL] @7:11
      MAX-WIDTH [KW_MAX_WID] @10:3
         4 [NUM_LITERAL] @10:13
   room-charges [FIELD_DEC] @14:5
      INITIAL [KW_INIT] @16:3
         0 [NUM_LITERAL] @16:11
      MAX-WIDTH [KW_MAX_WID] @19:3
         17 [NUM_LITERAL] @19:13
   sales-tax [FIELD_DEC] @24:5
      INITIAL [KW_INIT] @26:3
         0 [NUM_LITERAL] @26:11
      MAX-WIDTH [KW_MAX_WID] @29:3
         17 [NUM_LITERAL] @29:13
   total [FIELD_DEC] @34:5
      INITIAL [KW_INIT] @36:3
         0 [NUM_LITERAL] @36:11
      MAX-WIDTH [KW_MAX_WID] @39:3
         17 [NUM_LITERAL] @39:13
   state [FIELD_CHAR] @44:5
      INITIAL [KW_INIT] @46:3
         "" [STRING] @46:11
      MAX-WIDTH [KW_MAX_WID] @49:3
         2 [NUM_LITERAL] @49:13
   idx-r-id [INDEX] @53:5
      reservation-id [INDEX_FIELD] @57:3
./data/namespace/hotel.schema 00059 00005
checkout-rooms [TABLE] @59:5
   reservation-id [FIELD_INT] @63:5
      INITIAL [KW_INIT] @65:3
         0 [NUM_LITERAL] @65:11
      MAX-WIDTH [KW_MAX_WID] @68:3
         4 [NUM_LITERAL] @68:13
   guest-ids [FIELD_INT] @72:5
      INITIAL [KW_INIT] @74:3
         0 [NUM_LITERAL] @74:11
      MAX-WIDTH [KW_MAX_WID] @77:3
         64 [NUM_LITERAL] @77:13
   minibar-charges [FIELD_DEC] @82:5
      INITIAL [KW_INIT] @84:3
         0 [NUM_LITERAL] @84:11
      MAX-WIDTH [KW_MAX_WID] @87:3
         17 [NUM_LITERAL] @87:13
   laundry-charges [FIELD_DEC] @92:5
      INITIAL [KW_INIT] @94:3
         0 [NUM_LITERAL] @94:11
      MAX-WIDTH [KW_MAX_WID] @97:3
         17 [NUM_LITERAL] @97:13
   room-charges [FIELD_DEC] @102:5
      INITIAL [KW_INIT] @104:3
         0 [NUM_LITERAL] @104:11
      MAX-WIDTH [KW_MAX_WID] @107:3
         17 [NUM_LITERAL] @107:13
   room-number [FIELD_INT] @112:5
      INITIAL [KW_INIT] @114:3
         0 [NUM_LITERAL] @114:11
      MAX-WIDTH [KW_MAX_WID] @117:3
         4 [NUM_LITERAL] @117:13
   idx-rc-room [INDEX] @122:5
      room-number [INDEX_FIELD] @125:3
./data/namespace/hotel.schema 00127 00005
guest [TABLE] @127:5
   guest-id [FIELD_INT] @131:5
      INITIAL [KW_INIT] @133:3
         0 [NUM_LITERAL] @133:11
      MAX-WIDTH [KW_MAX_WID] @136:3
         4 [NUM_LITERAL] @136:13
   first-name [FIELD_CHAR] @140:5
      INITIAL [KW_INIT] @142:3
         "" [STRING] @142:11
      MAX-WIDTH [KW_MAX_WID] @145:3
         50 [NUM_LITERAL] @145:13
   last-name [FIELD_CHAR] @149:5
      INITIAL [KW_INIT] @151:3
         "" [STRING] @151:11
      MAX-WIDTH [KW_MAX_WID] @154:3
         50 [NUM_LITERAL] @154:13
   id-type [FIELD_INT] @158:5
      INITIAL [KW_INIT] @160:3
         0 [NUM_LITERAL] @160:11
      MAX-WIDTH [KW_MAX_WID] @163:3
         4 [NUM_LITERAL] @163:13
   id-number [FIELD_CHAR] @167:5
      INITIAL [KW_INIT] @169:3
         "" [STRING] @169:11
      MAX-WIDTH [KW_MAX_WID] @172:3
         40 [NUM_LITERAL] @172:13
   date-of-birth [FIELD_DATE] @176:5
      INITIAL [KW_INIT] @178:3
         ? [UNKNOWN_VAL] @178:11
      MAX-WIDTH [KW_MAX_WID] @181:3
         4 [NUM_LITERAL] @181:13
   phone-number [FIELD_CHAR] @185:5
      INITIAL [KW_INIT] @187:3
         "" [STRING] @187:11
      MAX-WIDTH [KW_MAX_WID] @190:3
         30 [NUM_LITERAL] @190:13
   country [FIELD_CHAR] @194:5
      INITIAL [KW_INIT] @196:3
         "" [STRING] @196:11
      MAX-WIDTH [KW_MAX_WID] @199:3
         50 [NUM_LITERAL] @199:13
   city [FIELD_CHAR] @203:5
      INITIAL [KW_INIT] @205:3
         "" [STRING] @205:11
      MAX-WIDTH [KW_MAX_WID] @208:3
         50 [NUM_LITERAL] @208:13
   street-2 [FIELD_CHAR] @212:5
      INITIAL [KW_INIT] @214:3
         "" [STRING] @214:11
      MAX-WIDTH [KW_MAX_WID] @217:3
         50 [NUM_LITERAL] @217:13
   street-1 [FIELD_CHAR] @221:5
      INITIAL [KW_INIT] @223:3
         "" [STRING] @223:11
      MAX-WIDTH [KW_MAX_WID] @226:3
         80 [NUM_LITERAL] @226:13
   state [FIELD_CHAR] @230:5
      INITIAL [KW_INIT] @232:3
         "" [STRING] @232:11
      MAX-WIDTH [KW_MAX_WID] @235:3
         50 [NUM_LITERAL] @235:13
   zip [FIELD_CHAR] @239:5
      INITIAL [KW_INIT] @241:3
         "" [STRING] @241:11
      MAX-WIDTH [KW_MAX_WID] @244:3
         20 [NUM_LITERAL] @244:13
   idx-g-id [INDEX] @248:5
      guest-id [INDEX_FIELD] @252:3
./data/namespace/hotel.schema 00254 00005
rate [TABLE] @254:5
   type-of-room [FIELD_INT] @258:5
      INITIAL [KW_INIT] @260:3
         0 [NUM_LITERAL] @260:11
      MAX-WIDTH [KW_MAX_WID] @263:3
         4 [NUM_LITERAL] @263:13
   floor [FIELD_INT] @268:5
      INITIAL [KW_INIT] @270:3
         0 [NUM_LITERAL] @270:11
      MAX-WIDTH [KW_MAX_WID] @273:3
         4 [NUM_LITERAL] @273:13
   rate [FIELD_DEC] @278:5
      INITIAL [KW_INIT] @280:3
         0 [NUM_LITERAL] @280:11
      MAX-WIDTH [KW_MAX_WID] @283:3
         17 [NUM_LITERAL] @283:13
   start-date [FIELD_DATE] @289:5
      INITIAL [KW_INIT] @291:3
         ? [UNKNOWN_VAL] @291:11
      MAX-WIDTH [KW_MAX_WID] @294:3
         4 [NUM_LITERAL] @294:13
   end-date [FIELD_DATE] @298:5
      INITIAL [KW_INIT] @300:3
         ? [UNKNOWN_VAL] @300:11
      MAX-WIDTH [KW_MAX_WID] @303:3
         4 [NUM_LITERAL] @303:13
   idx-rate-s-date [INDEX] @307:5
      start-date [INDEX_FIELD] @310:3
   idx-rate-e-date [INDEX] @312:5
      end-date [INDEX_FIELD] @314:3
./data/namespace/hotel.schema 00316 00005
reservation [TABLE] @316:5
   reservation-id [FIELD_INT] @320:5
      INITIAL [KW_INIT] @322:3
         0 [NUM_LITERAL] @322:11
      MAX-WIDTH [KW_MAX_WID] @325:3
         4 [NUM_LITERAL] @325:13
   discount [FIELD_DEC] @330:5
      INITIAL [KW_INIT] @332:3
         0 [NUM_LITERAL] @332:11
      MAX-WIDTH [KW_MAX_WID] @335:3
         17 [NUM_LITERAL] @335:13
   date [FIELD_DATE] @340:5
      INITIAL [KW_INIT] @342:3
         ? [UNKNOWN_VAL] @342:11
      MAX-WIDTH [KW_MAX_WID] @345:3
         4 [NUM_LITERAL] @345:13
   checkin [FIELD_DATE] @349:5
      INITIAL [KW_INIT] @351:3
         ? [UNKNOWN_VAL] @351:11
      MAX-WIDTH [KW_MAX_WID] @354:3
         4 [NUM_LITERAL] @354:13
   checkout [FIELD_DATE] @358:5
      INITIAL [KW_INIT] @360:3
         ? [UNKNOWN_VAL] @360:11
      MAX-WIDTH [KW_MAX_WID] @363:3
         4 [NUM_LITERAL] @363:13
   guest-id [FIELD_INT] @367:5
      INITIAL [KW_INIT] @369:3
         0 [NUM_LITERAL] @369:11
      MAX-WIDTH [KW_MAX_WID] @372:3
         4 [NUM_LITERAL] @372:13
   details [FIELD_CHAR] @376:5
      INITIAL [KW_INIT] @378:3
         "" [STRING] @378:11
      MAX-WIDTH [KW_MAX_WID] @381:3
         200 [NUM_LITERAL] @381:13
   state [FIELD_CHAR] @385:5
      INITIAL [KW_INIT] @387:3
         "" [STRING] @387:11
      MAX-WIDTH [KW_MAX_WID] @390:3
         2 [NUM_LITERAL] @390:13
   idx-r-id [INDEX] @394:5
      reservation-id [INDEX_FIELD] @398:3
   idx-r-checkin [INDEX] @400:5
      checkin [INDEX_FIELD] @402:3
./data/namespace/hotel.schema 00404 00005
reservation-rooms [TABLE] @404:5
   reservation-id [FIELD_INT] @408:5
      INITIAL [KW_INIT] @410:3
         0 [NUM_LITERAL] @410:11
      MAX-WIDTH [KW_MAX_WID] @413:3
         4 [NUM_LITERAL] @413:13
   type-of-room [FIELD_INT] @417:5
      INITIAL [KW_INIT] @419:3
         0 [NUM_LITERAL] @419:11
      MAX-WIDTH [KW_MAX_WID] @422:3
         4 [NUM_LITERAL] @422:13
   rooms [FIELD_INT] @427:5
      INITIAL [KW_INIT] @429:3
         0 [NUM_LITERAL] @429:11
      MAX-WIDTH [KW_MAX_WID] @432:3
         4 [NUM_LITERAL] @432:13
./data/namespace/hotel.schema 00436 00005
room [TABLE] @436:5
   type-of-room [FIELD_INT] @440:5
      INITIAL [KW_INIT] @442:3
         0 [NUM_LITERAL] @442:11
      MAX-WIDTH [KW_MAX_WID] @445:3
         4 [NUM_LITERAL] @445:13
   room-number [FIELD_INT] @450:5
      INITIAL [KW_INIT] @452:3
         0 [NUM_LITERAL] @452:11
      MAX-WIDTH [KW_MAX_WID] @455:3
         4 [NUM_LITERAL] @455:13
   floor [FIELD_INT] @460:5
      INITIAL [KW_INIT] @462:3
         0 [NUM_LITERAL] @462:11
      MAX-WIDTH [KW_MAX_WID] @465:3
         4 [NUM_LITERAL] @465:13
   idx-r-no [INDEX] @470:5
      room-number [INDEX_FIELD] @474:3
./data/namespace/hotel.schema 00476 00005
room-state [TABLE] @476:5
   room-number [FIELD_INT] @480:5
      INITIAL [KW_INIT] @482:3
         0 [NUM_LITERAL] @482:11
      MAX-WIDTH [KW_MAX_WID] @485:3
         4 [NUM_LITERAL] @485:13
   state [FIELD_LOGICAL] @490:5
      INITIAL [KW_INIT] @492:3
         no [BOOL_FALSE] @492:11
      MAX-WIDTH [KW_MAX_WID] @495:3
         1 [NUM_LITERAL] @495:13
   start-date [FIELD_DATE] @499:5
      INITIAL [KW_INIT] @501:3
         ? [UNKNOWN_VAL] @501:11
      MAX-WIDTH [KW_MAX_WID] @504:3
         4 [NUM_LITERAL] @504:13
./data/namespace/hotel.schema 07755 00005
_user [TABLE] @7755:5
    [PROPERTIES] @7756:3
      FROZEN [FROZEN] @7757:3
      HIDDEN [HIDDEN] @7758:3
   _userid [FIELD_CHAR] @7760:5
      INITIAL [KW_INIT] @7762:3
         "?" [STRING] @7762:11
      MAX-WIDTH [KW_MAX_WID] @7764:3
         32 [NUM_LITERAL] @7764:13
   _password [FIELD_CHAR] @7768:5
      INITIAL [KW_INIT] @7770:3
         "?" [STRING] @7770:11
      MAX-WIDTH [KW_MAX_WID] @7772:3
         32 [NUM_LITERAL] @7772:13
   _user-name [FIELD_CHAR] @7776:5
      INITIAL [KW_INIT] @7778:3
         "" [STRING] @7778:11
      MAX-WIDTH [KW_MAX_WID] @7780:3
         80 [NUM_LITERAL] @7780:13
   _u-misc1 [FIELD_INT] @7783:5
      INITIAL [KW_INIT] @7785:3
         ? [UNKNOWN_VAL] @7785:11
      MAX-WIDTH [KW_MAX_WID] @7786:3
         96 [NUM_LITERAL] @7786:13
   _u-misc2 [FIELD_CHAR] @7790:5
      INITIAL [KW_INIT] @7792:3
         "?" [STRING] @7792:11
      MAX-WIDTH [KW_MAX_WID] @7793:3
         144 [NUM_LITERAL] @7793:13
   _user-misc [FIELD_CHAR] @7797:5
      INITIAL [KW_INIT] @7799:3
         "?" [STRING] @7799:11
      MAX-WIDTH [KW_MAX_WID] @7801:3
         20 [NUM_LITERAL] @7801:13
   _user_number [FIELD_INT] @7805:5
      INITIAL [KW_INIT] @7807:3
         ? [UNKNOWN_VAL] @7807:11
      MAX-WIDTH [KW_MAX_WID] @7809:3
         4 [NUM_LITERAL] @7809:13
   _group_number [FIELD_INT] @7812:5
      INITIAL [KW_INIT] @7814:3
         ? [UNKNOWN_VAL] @7814:11
      MAX-WIDTH [KW_MAX_WID] @7816:3
         4 [NUM_LITERAL] @7816:13
   _given_name [FIELD_CHAR] @7819:5
      INITIAL [KW_INIT] @7821:3
         "?" [STRING] @7821:11
      MAX-WIDTH [KW_MAX_WID] @7823:3
         25 [NUM_LITERAL] @7823:13
   _middle_initial [FIELD_CHAR] @7826:5
      INITIAL [KW_INIT] @7828:3
         "?" [STRING] @7828:11
      MAX-WIDTH [KW_MAX_WID] @7830:3
         1 [NUM_LITERAL] @7830:13
   _surname [FIELD_CHAR] @7833:5
      INITIAL [KW_INIT] @7835:3
         "?" [STRING] @7835:11
      MAX-WIDTH [KW_MAX_WID] @7837:3
         25 [NUM_LITERAL] @7837:13
   _telephone [FIELD_CHAR] @7840:5
      INITIAL [KW_INIT] @7842:3
         "?" [STRING] @7842:11
      MAX-WIDTH [KW_MAX_WID] @7844:3
         20 [NUM_LITERAL] @7844:13
   _email [FIELD_CHAR] @7847:5
      INITIAL [KW_INIT] @7849:3
         "?" [STRING] @7849:11
      MAX-WIDTH [KW_MAX_WID] @7851:3
         50 [NUM_LITERAL] @7851:13
   _description [FIELD_CHAR] @7854:5
      INITIAL [KW_INIT] @7856:3
         "?" [STRING] @7856:11
      MAX-WIDTH [KW_MAX_WID] @7858:3
         64 [NUM_LITERAL] @7858:13
   _disabled [FIELD_LOGICAL] @7861:5
      INITIAL [KW_INIT] @7863:3
         ? [UNKNOWN_VAL] @7863:11
      MAX-WIDTH [KW_MAX_WID] @7865:3
         1 [NUM_LITERAL] @7865:13
   _create_date [FIELD_DATETIME_TZ] @7868:5
      INITIAL [KW_INIT] @7870:3
         ? [UNKNOWN_VAL] @7870:11
      MAX-WIDTH [KW_MAX_WID] @7872:3
         12 [NUM_LITERAL] @7872:13
   _account_expires [FIELD_DATETIME_TZ] @7875:5
      INITIAL [KW_INIT] @7877:3
         ? [UNKNOWN_VAL] @7877:11
      MAX-WIDTH [KW_MAX_WID] @7879:3
         12 [NUM_LITERAL] @7879:13
   _pwd_expires [FIELD_DATETIME_TZ] @7882:5
      INITIAL [KW_INIT] @7884:3
         ? [UNKNOWN_VAL] @7884:11
      MAX-WIDTH [KW_MAX_WID] @7886:3
         12 [NUM_LITERAL] @7886:13
   _pwd_duration [FIELD_INT] @7889:5
      INITIAL [KW_INIT] @7891:3
         ? [UNKNOWN_VAL] @7891:11
      MAX-WIDTH [KW_MAX_WID] @7893:3
         4 [NUM_LITERAL] @7893:13
   _last_login [FIELD_DATETIME_TZ] @7896:5
      INITIAL [KW_INIT] @7898:3
         ? [UNKNOWN_VAL] @7898:11
      MAX-WIDTH [KW_MAX_WID] @7900:3
         12 [NUM_LITERAL] @7900:13
   _logins [FIELD_INT] @7903:5
      INITIAL [KW_INIT] @7905:3
         ? [UNKNOWN_VAL] @7905:11
      MAX-WIDTH [KW_MAX_WID] @7907:3
         4 [NUM_LITERAL] @7907:13
   _max_logins [FIELD_INT] @7910:5
      INITIAL [KW_INIT] @7912:3
         ? [UNKNOWN_VAL] @7912:11
      MAX-WIDTH [KW_MAX_WID] @7914:3
         4 [NUM_LITERAL] @7914:13
   _max_tries [FIELD_INT] @7917:5
      INITIAL [KW_INIT] @7919:3
         ? [UNKNOWN_VAL] @7919:11
      MAX-WIDTH [KW_MAX_WID] @7921:3
         4 [NUM_LITERAL] @7921:13
   _login_failures [FIELD_INT] @7924:5
      INITIAL [KW_INIT] @7926:3
         ? [UNKNOWN_VAL] @7926:11
      MAX-WIDTH [KW_MAX_WID] @7928:3
         4 [NUM_LITERAL] @7928:13
   _spare1 [FIELD_INT] @7931:5
      INITIAL [KW_INIT] @7933:3
         ? [UNKNOWN_VAL] @7933:11
      MAX-WIDTH [KW_MAX_WID] @7935:3
         4 [NUM_LITERAL] @7935:13
   _spare2 [FIELD_INT] @7938:5
      INITIAL [KW_INIT] @7940:3
         ? [UNKNOWN_VAL] @7940:11
      MAX-WIDTH [KW_MAX_WID] @7942:3
         4 [NUM_LITERAL] @7942:13
   _spare3 [FIELD_CHAR] @7945:5
      INITIAL [KW_INIT] @7947:3
         "?" [STRING] @7947:11
      MAX-WIDTH [KW_MAX_WID] @7949:3
         1 [NUM_LITERAL] @7949:13
   _spare4 [FIELD_CHAR] @7952:5
      INITIAL [KW_INIT] @7954:3
         "?" [STRING] @7954:11
      MAX-WIDTH [KW_MAX_WID] @7956:3
         1 [NUM_LITERAL] @7956:13
   _userid [INDEX] @7959:5
      _Userid [INDEX_FIELD] @7963:3

Conditions matched: [ parent.type == prog.database and evalLib("record_types_rel", this) ]


Please see the Source File Index for the list of report inputs. Generated at 03/31/2017 21:16:16 EEST.