Walk101

Tables (4)

PatientInfo (patient_info)

  • Key (Id) — int — Primary key — NOT NULL
  • id (userId) — int — Foreign key → user.id — NOT NULL
  • Field (age) — int
  • Field (height) — int
  • Field (gender) — varchar
  • Field (description) — varchar
  • Field (createdAt) — datetime
  • Field (weight) — int

Untitled (image)

  • Key (Id) — int — Primary key — NOT NULL
  • Key (patientId) — int — Foreign key → PatientInfo.Key — NOT NULL
  • Field (categoryName) — varchar
  • Field (categoryImage) — varchar
  • Field (resultImage) — varchar
  • Field (patient) — PatientInfo
  • Field (originalPath) — varchar
  • Field (watermarkedPath) — varchar
  • Field (result) — Result

result

  • Key (Id) — int — Primary key — NOT NULL
  • Field (report) — varchar
  • Field (createdAt) — datetime
  • Key (imageId) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (bmi) — float
  • Field (image) — Image

user

  • id (Id) — int — Primary key — NOT NULL
  • Field (userName) — varchar
  • 비밀번호 (userPassword) — varchar
  • 이메일 (userEmail) — varchar
  • Field (createdAt) — datetime
  • Field (tokenVersion) — Int
  • Field (refreshTokenHash) — varchar