SƠ ĐỒ QUAN HỆ CƠ SỞ DỮ LIỆU CỤC BỘ (LOCAL SQLITE ER DIAGRAM)

EVN PMIS FIELD MOBILE V1.0

Offline-First Architecture

table_chart local_pmis_record

Hồ sơ khảo sát

PK record_id

TEXT (UUID)

REF pmis_asset_id

TEXT

* station_code

TEXT NOT NULL

* device_type

TEXT (MBA,MC,TI,TU)

📍 gps_lat, gps_long

REAL NOT NULL

± gps_accuracy

REAL (meters)

JSON ocr_plate_data

TEXT (9 Fields)

ocr_confidence REAL (%)

disparity_detected INT DEFAULT 0

JSON disparity_details

TEXT

JSON checklist_status

TEXT (4 Photos)

engineer_signature TEXT

STATE sync_status

'PENDING' | 'SYNCED'

created_at, updated_at DATETIME (CURRENT_TIMESTAMP)

photo_library local_photo_queue

Hàng đợi ảnh

PK photo_id

TEXT (UUID)

FK record_id

TEXT ➔ local_pmis_record

* photo_type

TEXT (Enum 4 Types)

lock file_path

TEXT (Encrypted Sandbox)

file_size_bytes INTEGER

HASH sha256_hash

TEXT (Toàn vẹn dữ liệu)

captured_at DATETIME

is_uploaded INTEGER DEFAULT 0

storage local_asset_cache

Cache Danh mục PMIS

PK asset_id

TEXT

station_id, asset_name TEXT NOT NULL

serial_number, rated_voltage_kv TEXT

rated_capacity_kva, mfg_year REAL / INT

last_synced_at DATETIME NOT NULL

PK: Primary Key FK: Foreign Key (1 - N Cascade) JSON Payload

verified_user Cơ chế Chống Giả Mạo: SHA-256 Checksum + SQLite Atomic Transactions