SC_test
Tables (9)
DailySymtom
- dailySymtomId — int — Primary key — NOT NULL
- userId — int — Foreign key → User.userId — NOT NULL
- symtomDate — dateTime
DiseaseType
- diseaseId — int — Primary key — NOT NULL
- diseaseName — varchar(100)
- gotSick — boolean
- userId — int — Foreign key → User.userId — NOT NULL
ExerciseTime
- exerciseTimeId — int — Primary key — NOT NULL
- userId — int — Foreign key → User.userId — NOT NULL
- exerciseTime — varchar(100)
ExerciseVideo
- videoId — int — Primary key — NOT NULL
- videoName — varchar(100)
- thumbUrl — varchar(100)
- videoUrl — varchar(100)
- isWatched — boolean
- userId — int — Foreign key → User.userId — NOT NULL
HospitalList
- hospitalId — int — Primary key — NOT NULL
- hospitalName — varchar(100)
- doctorName — varchar(100)
- hospitalPhone — varchar(100)
- hospitalLoc — varchar(100)
- medicalId — int — Foreign key → MedicalHistory.medicalId — NOT NULL
- userId — int — Foreign key → MedicalHistory.userId — NOT NULL
MealTime
- mealTimeId — int — Primary key — NOT NULL
- userId — int — Foreign key → User.userId — NOT NULL
- mealTime — varchqr(100)
MedicalHistory
- medicalId — int — Primary key — NOT NULL
- userId — int — Foreign key → User.userId — NOT NULL
- medicalDate — dateTime
- isMedicalDone — VARCHAR(255)
SymtomType
- symtomTypeId — int — Primary key — NOT NULL
- symtomName — varchar(100)
- isChecked — boolean
- dailySymtomId — int — Foreign key → DailySymtom.dailySymtomId — NOT NULL
- userId — int — Foreign key → DailySymtom.userId — NOT NULL
User
- userId — int — Primary key — NOT NULL
- userName — varchar(100)
- userBirth — dateTime
- userGender — int
- userPhone — varchar(100)
- guardPhone — varchar(100)
- userPassword — varchar(100)
- userType — varchar(100)
- mealAlarmCnt — int
- exerciseAlarmCnt — VARCHAR(255)