대대손손

테이블 (6)

고객 (Customer)

  • Customer_Id — Int — 기본 키 — NOT NULL
  • Name — String
  • Phone — String
  • Created_at (Field) — TimeStamp

묘소 (Grave)

  • Grave_Id — Int — 기본 키 — NOT NULL
  • Customer_Id — Int — 외래 키 → 고객.Customer_Id — NOT NULL
  • Longitude — Float
  • Latitude — Float
  • Accuracy — Int
  • Address — String
  • Memo — String
  • Created_at (Field) — TimeStamp

묘소_이미지 (Grave_Image)

  • Grave_Image_Id — Int — 기본 키 — NOT NULL
  • Grave_Id — Int — 외래 키 → 묘소.Grave_Id — NOT NULL
  • Customer_Id — Int — 외래 키 → 묘소.Customer_Id — NOT NULL
  • Image_Path — String
  • Longtitude — Float
  • Latitude — Float
  • Image_type — Int — 0 : 현장 이미지 1 : 항공뷰 이미지

작업_주문 (Work_Order)

  • Order_Id — Int — 기본 키 — NOT NULL
  • Worker_Id — Int — 외래 키 → 작업자.Worker_Id — NOT NULL
  • Customer_Id — Int — 외래 키 → 고객.Customer_Id — NOT NULL
  • Grave_Id — Int — 외래 키 → 묘소.Grave_Id — NOT NULL
  • Customer_Id (Customer_Id2) — Int — 외래 키 → 묘소.Customer_Id — NOT NULL
  • Before_Image_Path — String
  • After_Image_Path — String
  • Before_360_Path — String
  • After_360_Path — String
  • Curstomer_View_Time — Timestamp
  • Memo — String
  • Status — String — CANCLE START BEFORE AFTER COMPLETION
  • start_time (Field) — TimeStamp

작업자 (Worker)

  • Worker_Id — Int — 기본 키 — NOT NULL
  • Name — String

작업자_위치 (WorkerLocation)

  • Worker_Id — Int — 외래 키 → 작업자.Worker_Id — NOT NULL
  • Longitude — Float
  • Latitude (Field) — Float
  • Timestamp (Field2) — Timestamp
  • Accuracy — Int