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)