hospital

Tables (6)

bodyparts (Untitled)

  • BodyId (Key) — Primary key — NOT NULL
  • UserID (key) — int — Foreign key → user.UserID — NOT NULL
  • 부위이름 (Field)

hospital (Untitled3)

  • HospitalID (Key) — Primary key — NOT NULL
  • 병원종류 (Field)
  • 병원확률 (Field2)

hospitalname (Untitled5)

  • HospitalNameID (Key) — Primary key — NOT NULL
  • HospitalID (Key2) — Foreign key → hospital.HospitalID — NOT NULL
  • 병원이름 (Field)
  • 병원주소 (Field2)
  • 병원종류 (Field3)

selection (Untitled4)

  • selections (Key) — Primary key — NOT NULL
  • BodyId (Key2) — Foreign key → bodyparts.BodyId — NOT NULL
  • UserID (key) — int — Foreign key → bodyparts.UserID — NOT NULL
  • HospitalID (Key3) — Foreign key → hospital.HospitalID — NOT NULL
  • 몸선택횟수 (Field)

symptom (Untitled2)

  • symptom (Key) — Primary key — NOT NULL
  • BodyId (Key2) — Foreign key → bodyparts.BodyId — NOT NULL
  • UserID (key) — int — Foreign key → bodyparts.UserID — NOT NULL
  • 증상 (Field)

user

  • UserID (key) — int — Primary key — NOT NULL
  • 성별 (Field)
  • 나이 (Field2)