응급실 위치정보 제공

테이블 (3)

사용자 (Untitled2)

  • EmpSeq (Key) — Int — 기본 키 — NOT NULL
  • EmpID (Field) — VarChar
  • EmpName (Field2) — VarChar
  • ResRegiNo (Field3) — Char
  • Sex (Field4) — Char
  • Height (Field5) — Decimal
  • Weight (Field6) — Decimal
  • Smoke (Field8) — Char
  • DrinkCapa (Field9) — Int
  • Infirmity (Field7) — Varchar

응급상황 현황 (Untitled)

  • EmerSeq (Key) — Int — 기본 키 — NOT NULL
  • EmpSeq (Key2) — Int — 외래 키 → 사용자.EmpSeq — NOT NULL
  • EmerRoomSeq (Key3) — Int — 외래 키 → 응급실 위치정보.ERSeq — NOT NULL
  • EmerName (Field) — Varhcar
  • EmerLimit (Field4) — Char
  • OccurPlace (Field6) — Varchar
  • SituStartTime (Field2) — DateTime
  • SituEndTime (Field3) — DateTime
  • UserName (Field7) — Varchar

응급실 위치정보 (Untitled3)

  • ERSeq (Key) — Int — 기본 키 — NOT NULL
  • Bno — Int
  • AgencyName (Title) — Varchar
  • RecuperationNo (Content) — Int
  • AgencyClass (Writer) — Varchar
  • Zipcode (Viewcnt) — Int
  • Address (Field7) — Varchar
  • Cal (Field8) — Varchar
  • Nitcal (Field9) — Varchar
  • Nit (Field10) — Varchar
  • Longitude (Field11) — Double
  • Latitude (Field12) — Double
  • Bed (Field13) — Int