대대손손
테이블 (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