Database Tables "ISAM" (isamDb)

The following description shows the layout of the database tables for the component isamDb.

Each of the database tables listed here contains the number of fields with the corresponding table name, the internal field description, the field name, the data type and the field length.

Fields characterized by the "$" sign are primary keys.

For more detailed information on the database tables (e.g. attributes, references, indices etc.) go to the update program System -> Database-> Database Tables

  1. $DbAttrGroup=ClassNo=Table No.=Number=1 9999
  2. $DbAttrGroup=GroupNo=Group=Number=1 9999
  3. DbAttrGroup=Name=Name=String=(20)
  1. $DbAttrRef=ClassNo=Table No.=Number=1 9999
  2. $DbAttrRef=GroupNo=Group=Number=1 9999
  3. $DbAttrRef=PositionNo=Position=Number=1 9999
  4. DbAttrRef=AttributeNo=Attribute=Number=1 9999
  1. $DbAttribute=ClassNo=Table No.=Number=1 9999
  2. $DbAttribute=AttributeNo=Attribute=Number=1 9999
  3. DbAttribute=Name=Name=String=(20)
  4. DbAttribute=TypeName=Type Name=String=(20)
  5. DbAttribute=Len=Binary Length=Number=
  6. DbAttribute=Scale=Decimal Digits=Number=
  7. DbAttribute=Offset=Offset=Number=
  8. DbAttribute=Asclen=ASCII Length=Number=
  9. DbAttribute=SuperClassNo=Table No.=Number=1 9999
  10. DbAttribute=DefValue=Default Value=String=(20)
  11. DbAttribute=MinValue=Minimum=String=(20)
  12. DbAttribute=MaxValue=Maximum=String=(20)
  13. DbAttribute=DomainNo=Domain=Number=1 9999
  14. DbAttribute=DefaultNull=Preset with zero=Bool=(Y/N)
  15. DbAttribute=NonPersistent=No storage=Bool=(Y/N)
  16. DbAttribute=SetFunction=Set Function=String=(20)
  17. DbAttribute=GetFunction=Get Function=String=(20)
  18. DbAttribute=MixinNo=Mix Number=Number=
  1. $DbClass=ClassNo=Table No.=Number=1 9999
  2. DbClass=Name=Name=String=(20)
  3. DbClass=SuperClassNo=Super Table=Number=1 9999
  4. DbClass=Reclen=Record Length=Number=
  5. DbClass=NumFields=Count Fields=Number=
  6. DbClass=Abstract=Abstract=Bool=(Y/N)
  7. DbClass=NonPersistent=No Storage=Bool=(Y/N)
  8. DbClass=SuperPersistent=No own File=Bool=(Y/N)
  9. DbClass=Objlen=Object Length=Number=
  10. DbClass=MainRefNo=Group=Number=1 9999
  11. DbClass=Category=Category=String=(20)
  12. DbClass=Component=Component=String=(20)
  13. DbClass=TabCrc=NOTEXT=Number=
  14. DbClass=HasFile=NOTEXT=Bool=(Y/N)
  15. DbClass=ReplaceSuper=NOTEXT=Bool=(Y/N)
  16. DbClass=NameLen=NOTEXT=Number=
  17. DbClass=ReplacedByNo=Table No.=Number=1 9999
  1. $DbComponent=Name=Name=String=(20)
  2. DbComponent=OrderId=Order ID=Number=
  3. DbComponent=SystemComponent=System Component=Number=
  1. $DbDoc=TableName=Name=String=(20)
  2. $DbDoc=AttrName=Name=String=(20)
  3. $DbDoc=LineNo=NOTEXT=Number=
  4. DbDoc=Text=NOTEXT=String=(80)
  1. $DbDomain=DomainNo=Domain=Number=1 9999
  2. DbDomain=Name=Name=String=(20)
  3. DbDomain=TypeName=Type Name=String=(20)
  4. DbDomain=Len=Length=Number=
  5. DbDomain=Scale=Scale=Number=
  6. DbDomain=DefValue=Def.Value=String=(20)
  7. DbDomain=MinValue=Min.Value=String=(20)
  8. DbDomain=MaxValue=Max.Value=String=(20)
  1. $DbIndex=ClassNo=Table No.=Number=1 9999
  2. $DbIndex=GroupNo=Group=Number=1 9999
  3. DbIndex=Name=Name=String=(20)
  4. DbIndex=Unique=Unique=Bool=(Y/N)
  1. $DbKey=ClassNo=Table No.=Number=1 9999
  2. $DbKey=GroupNo=Group=Number=1 9999
  3. DbKey=Name=Name=String=(20)
  4. DbKey=Primary=Primary=Bool=(Y/N)
  1. $DbLogFile=InstallNo=Installation=Number=1 9999
  2. $DbLogFile=ProcUnitNo=Process Unit=Number=1 9999
  3. DbLogFile=CurrentLogNo=NOTEXT=Number=
  4. DbLogFile=CurrentLogPos=NOTEXT==
  5. DbLogFile=OldestLogNo=NOTEXT=Number=
  6. DbLogFile=WorkedStandalone=NOTEXT=Number=
  7. DbLogFile=BackupIsMaster=NOTEXT=Number=
  1. $DbMixin=ClassNo=Table No.=Number=1 9999
  2. $DbMixin=MixinNo=Mix Number=Number=
  3. DbMixin=Name=Name=String=(20)
  1. $DbReference=ClassNo=Table No.=Number=1 9999
  2. $DbReference=GroupNo=Group=Number=1 9999
  3. DbReference=Name=Name=String=(20)
  4. DbReference=RefClass=Reference Table=Number=1 9999
  5. DbReference=Keyname=Key Name=String=(20)
  6. DbReference=Invers=Invert=String=(20)
  1. $DbStatus=InstallNo=Installation=Number=1 9999
  2. DbStatus=CompLevel=NOTEXT=Number=1 9999
  3. DbStatus=TotalCrc=NOTEXT=Number=
  4. DbStatus=InitialDate=NOTEXT=Date=
  5. DbStatus=InitialTime=NOTEXT=Time=
  6. DbStatus=ConvertCount=NOTEXT=Number=0 99999999
  7. DbStatus=ConvertDate=NOTEXT=Date=
  8. DbStatus=ConvertTime=NOTEXT=Time=
  9. DbStatus=ZapCount=NOTEXT=Number=0 99999999
  10. DbStatus=ZapDate=NOTEXT=Date=
  11. DbStatus=ZapTime=NOTEXT=Time=
MICROS Retail Deutschland GmbH
Salzufer 8
D-10587 Berlin
Germany