E4U

Tables (5)

Diagnose (진단정보)

  • DiagnosisId (진단키) — INT — Primary key — NOT NULL
  • UserId (회원키) — INT — Foreign key → User.UserId — NOT NULL
  • UserName (이름) — VARCHAR(20)
  • Images (이미지들) — VARCHAR(100)
  • Date (날짜) — TIMESTAMP
  • ReportScore (진단점수) — INT
  • Status (진단상태) — VARCHAR(20)
  • Recommendation (관리권장사항) — TEXT
  • Condition (진단정보) — VARCHAR(100)
  • Description (진단설명) — TEXT

Image (이미지)

  • ImageId (이미지키) — INT — Primary key — NOT NULL
  • UserId (회원키) — INT — Foreign key → User.UserId — NOT NULL
  • ImagePath (이미지경로) — VARCHAR
  • UploadDate (업로드날짜) — DATETIME
  • ImageType (이미지종류) — INT

Token (토큰)

  • TokenId (토큰키) — INT — Primary key — NOT NULL
  • UserId (회원키) — INT — Foreign key → User.UserId — NOT NULL
  • AccessToken (어세스토큰) — VARCHAR(50)
  • RefreshToken (리프레쉬토큰) — VARCHAR(50)

User (사용자)

  • UserId (회원키) — INT — Primary key — NOT NULL
  • Email (이메일) — VARCHAR(50)
  • Password (비밀번호) — VARCHAR(50)
  • Name (이름) — VARCHAR(20)
  • Age (나이) — INT
  • Gender (성별) — VARCHAR(10)

UserInfo (사용자정보)

  • UserInfoKey (사용자정보키) — INT — Primary key — NOT NULL
  • UserId (회원키) — INT — Foreign key → User.UserId — NOT NULL
  • LastDiagnoseDate (마지막진단일) — DATETIME
  • LastDiagnoseScore (마지막진단점수) — INT
  • LastDiagnoseStatus (마지막진단상태) — VARCHAR(20)
  • DiagnoseNum (진단횟수) — INT