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