Technical Reference
for
Version 4.01

Copyright (C) 1990, 1997 Fumio Kawamata

May 10, 1997
1. Before compilation
The program package contains complete soruce code. You can recompile them and create your own executable file. However, you must do following before you compile them.


  1. Install the Borland Database Engine.
  2. Set BDE aliases.
2. Location of the tables
3. Table structures
* marks at the Field Name items mean the Primary Index Fields

  1. UNIT.DB

    Field definition

    Field NameTypeSizeRequiredRemarks
    UNIT_ID*String8TrueUnit ID
    TITLEString64FalseUnit title

  2. LOCATION.DB

    Field definition

    Field NameTypeSizeRequiredRemarks
    UNIT_ID*String8TrueUnit ID
    SLOT_ID*String3TrueSlot ID in the Unit
    DISC_IDString16TrueDisc ID

  3. DISC.DB

    Field definition

    Field NameTypeSizeRequiredRemarks
    DISC_ID*String16TrueDisc ID
    TITLEString64FalseDisc title
    TITLE2String32FalseDisc subtitle
    PRODUCTIONString16FalseProduction name
    CATEGORYString32FalseCategory of the disc
    INDEXString32FalseString for sorting
    TRACKSShort Integer(2)TrueTotal number of tracks. 0 for the default value.
    FRAMESLong Integer(4)TrueTotal number of frames. 0 for the default value.

    Secondary index definition

    Index NameIndex Field Name
    USERS_INDEXCATEGORY, INDEX, DISC_ID

  4. MUSIC.DB

    Field definition

    Field NameTypeSizeRequiredRemarks
    DISC_ID*String16TrueDisc ID
    TRACK1*Short Integer(2)FalseStart track number
    TRACK2*Short Integer(2)FalseEnd track number
    TITLEString64FalseDisc title
    PLAYERString32FalsePlayer name
    VERSIFIERString32FalseVersifier name
    COMPOSERString32FalseComposer name
    ARRANGERString32FalseArranger name
    FRAMESLong Integer(4)TruePlaying time in frames. 0 for the default value.
    VOLUMEShort Integer(2)TrueVolume. 0 for the default value.

  5. KEYWORD.DB

    Field definition

    Field NameTypeSizeRequiredRemarks
    KEYWORD*String16TrueKeyword

  6. TASTE.DB

    Field definition

    Field NameTypeSizeRequiredRemarks
    DISC_ID* String 16 True Disc ID
    TRACK1* Short Integer (2) True Start track number
    TRACK2* Short Integer (2) True End track number
    KEYWORD String 128 False Keyword
    TASTE Short Integer (2) True Taste of the music1(hate) to 5(favourit)
    COUNTER Long Integer (4) True Playing times
    MEMO Memo - False Memo

  7. PROG.DB

    Field definition

    Field NameTypeSizeRequiredRemarks
    NO*Short Integer(2)TrueProgram number
    UNIT_ID*String8TrueUnitID
    SLOT_ID*String3TrueSlot ID
    DISC_ID*String16TrueDisc ID
    TRACK1*Short Integer(2)TrueStart track number
    TRACK2*Short Integer(2)TrueEnd track number

4. Others

Development environment
The first model of the IBM's PS/V Vision(It is so slow.)