공사장

테이블 (5)

community (Untitled4)

  • community (Key) — 기본 키 — NOT NULL
  • manager (Key2) — 외래 키 → manager.manager — NOT NULL
  • worker (Key4) — 외래 키 → worker.worker — NOT NULL
  • danger (Key3) — 외래 키 → danger(ai model).danger — NOT NULL
  • title (Field)
  • content (Field2)
  • create_at (Field3)
  • image (Field4)
  • work-zone (Field5)

danger(ai model) (Untitled5)

  • danger (Key) — 기본 키 — NOT NULL
  • 유형ID (Field)
  • 객체ID (Field2)
  • 객체유형ID (Field3)
  • 상황ID (Field4)
  • 건설현장환경ID (Field5)

first aid (Untitled3)

  • first aid (Key) — 기본 키 — NOT NULL
  • manager (Key2) — 외래 키 → manager.manager — NOT NULL
  • worker (Key3) — 외래 키 → worker.worker — NOT NULL
  • img (Field)
  • text (Field2)

manager (Untitled)

  • manager (Key) — 기본 키 — NOT NULL
  • name (Field)
  • age (Field2)
  • sex (Field3)
  • phone-number (Field4)

worker (Untitled2)

  • worker (Key) — 기본 키 — NOT NULL
  • manager (Key2) — 외래 키 → manager.manager — NOT NULL
  • name (Field)
  • phone-number (Field2)