Database tables
The legacy program uses a KABISA_VII database and a IMAGES_VII database.
All Legacy tables in database KABISA_VII
- ASSOCDATA assoc data for 1 continent, filled from ASSOCDATA2 (7223 records)
- ASSOCDATA2 associated data for all continents, used only in setup (7223 records)
- ASSOCIMAGES Assoc Image data. Not used in code. (258 records)
- CLINICALIMAGE Clinical image data (172 records)
- [CONVMONEYTABLE] Currency exchange rate. not used in code
- DIAG Diagnosis, probability of occurrence
- [DIAGNOSID] Temporary table.
- [EVALDATA] not used in code. (37 records)
- EXCLUDES table used for excluding records (see also table SINTOMIS) (201 records)
- EXPANDS Table for selection of SYM (377 records)
- EXPIMAGE images for expands (3 records)
- IMAGEEXERCIZE Not used in code (23 records)
- IMPLIES sintomis
- IMPUTDATABV Score ? (3 records, based on category)
- [INPUTESAME] Not used in code.
- [LAST10] not used in code
- LINGUEDIAG Diagnose strings, used to feed [DIAG] (347 records)
- LINGUESTRING Strings (447 records), used to feed sstring
- LINGUESYM Symptom strings (503 records)
- MAYCAUSE Symptoms that may cause a disease (112 records)
- MENWOMCHILD ? (42 records)
- [MODIFICATION_LOG] Empty, not used
- [MONEY] Empty, not used
- [MYDIAGS] Temp table
- [MYPOWER] Not used in code
- [MYPROB] Temp table
- [MYSELECTED2] Temp table
- [MYSINTOMIS] Temp table
- [NEGATIVPATH] Paths
- PARAMTABLE Parameter table (12 records). Only used during setup ?
- [PASWORD] Not used in code.
- PATHIMM Paths ?
- PC_PE_BMP Bitmaps with pairs of colors (25 records)
- [POTERIREPLEX] Temp table, filled from [SYM], [DIAG] and [ASSOCDATA]
- [POWERTABLE] Temp table, filled with data from SINTOMIS
- PROBABILITA Probabilities (298 records)
- RANDOMSTOOLNP Paths (9 records)
- [RELATED] Not used in code
- RXDIFFERENT Paths (48 records)
- [SINTOMIS] Temp table
- [SINTOMIS2] Temp table
- SSTRING Strings to be displayed in program. (453 records)
- [SYM] Filled from [LINGUESYM]
- [SYNODU] Synonyms in Dutch (520 records)
- SYNOEN Synonyms in English (552 records)
- [SYNOFR] Synonyms in French (505 records)
- [SYNOGE] Synonyms in German (479 records)
- [SYNOINDO] Synonyms in Indonesian (432 records)
- [SYNOIT] Synonyms in Italian (467 records)
- [SYNOLAO] Zero records
- [SYNOPO] Synonyms in Portugese (438 records)
- [SYNOSP] Synonyms in Spanish (473 records)
- [SYNO_ID] Temp table
- [SYNO_ID2] Temp table
- [SYNO_ORG] Temp table
- [SYNO_WORK] Temp table
All really used Legacy tables in KABISA_VII
- [ASSOCDATA2] associated data for all continents, used only in setup (7223 records)
- [CLINICALIMAGE] Clinical image data (172 records)
- [DIAG] Diagnosis, probability of occurrence
- [EXCLUDES] table used for excluding records (see also table SINTOMIS) (201 records)
- [EXPANDS] Table for selection of SYM (377 records)
- [EXPIMAGE] images for expands (3 records)
- [IMPLIES] 'Implies' relationship between symptoms.
- [IMPUTDATABV] Score ? (3 records, based on category)
- [LINGUESYM] Symptom strings
- [MAYCAUSE] Symptoms that may cause a disease (112 records)
- [MENWOMCHILD] Image Paths depending on gender (42 records)
- [NEGATIVPATH] Image Paths
- [PARAMTABLE] Parameter table (12 records). Only used during setup ?
- [PATHIMM] Image Paths ?
- [PC_PE_BMP] Bitmaps with pairs of colors (25 records)
- [PROBABILITA] Probabilities (298 records)
- [RANDOMSTOOLNP] Image Paths (9 records)
- [RXDIFFERENT] Image Paths (48 records)
- [SSTRING] Strings to be displayed in program. (453 records)
- [SYM] Filled from [LINGUESYM]
- [SYNO*] Synonyms