Linguesym

Table LINGUESYM

Synopsis

Symptoms list

Structure

Name	Type	reqd.	Description
NRS	INT	N	Unique ID
SYMPE	VARCHAR(50)	N	Symptom in english
SYMPI	VARCHAR(50)	N	Symptom in Italian
SYMPN	VARCHAR(50)	N	Symptom in Dutch
SYMPD	VARCHAR(255)	N	Symptom in German
SYMPF	VARCHAR(50)	N	Symptom in French
SYMPP	VARCHAR(50)	N	Symptom in Portugese
SYMPS	VARCHAR(50)	N	Symprom in Spanish
TTYPE	FLOAT(-1,0)	N
STARTUP	INT	N
ALARM	SMALLINT	N
BITMAP	INT	N
EXPAND	SMALLINT	N
P_COSMO	SMALLINT	N
P_AFRICA	SMALLINT	N
P_ASIA	SMALLINT	N
P_AMERICA	SMALLINT	N
COST	INT	N
COMUNE_AMERICA	FLOAT(-1,0)	N
COMUNE_AFRICA	FLOAT(-1,0)	N
COMUNE_ASIA	FLOAT(-1,0)	N
COMUNE_COSMO	FLOAT(-1,0)	N
SYMPLAO	VARCHAR(255)	N
P_TRAVEL	SMALLINT	N
P_GP	SMALLINT	N
COMUNE_TRAVEL	FLOAT(-1,0)	N
COMUNE_GP	FLOAT(-1,0)	N
COSMOTEMP	SMALLINT	N
SYMPINDO	VARCHAR(50)	N	Symptom in Indonesian
SYMPE_SORTNM	VARCHAR(50)	N	Not used
SYMPI_SORTNM	VARCHAR(50)	N	Not used
SYMPN_SORTNM	VARCHAR(50)	N	Not used
SYMPD_SORTNM	VARCHAR(255)	N	Not used
SYMPF_SORTNM	VARCHAR(50)	N	Not used
SYMPP_SORTNM	VARCHAR(50)	N	Not used
SYMPS_SORTNM	VARCHAR(50)	N	Not used
SYMPE_SORTNR	INT	N
SYMPI_SORTNR	INT	N
SYMPN_SORTNR	INT	N
SYMPD_SORTNR	INT	N
SYMPF_SORTNR	INT	N
SYMPP_SORTNR	INT	N
SYMPS_SORTNR	INT	N