SMND PILOT
Tables (17)
CopyOfUntitled10
- id — VARCHAR(255) — Primary key — NOT NULL
- PhaseName — VARCHAR(255)
- ComponentType — VARCHAR(255)
Untitled
- id — VARCHAR(255) — Primary key — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field5 — VARCHAR(255)
- Field3 — VARCHAR(255)
Untitled10
- id — VARCHAR(255) — Primary key — NOT NULL
- Customer — VARCHAR(255)
- CustomerEn — VARCHAR(255)
- created_at — VARCHAR(255)
- delete_flag — VARCHAR(255)
Untitled2
- AreaCode — VARCHAR(20) — Primary key — NOT NULL
- AreaName — VARCHAR(255)
- AreaNameEn — VARCHAR(255)
- DistrictName — VARCHAR(255)
- created_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_at — VARCHAR(255)
- delated_at — VARCHAR(255)
- delete_flag — VARCHAR(255)
Untitled4
- id — VARCHAR(255) — Primary key — NOT NULL
- SiteName — VARCHAR(255)
Untitled5
- InsulatorType — VARCHAR(255) — Primary key — NOT NULL
- InsulatorTypeNAme — VARCHAR(255)
Untitled6
- VoltageType — VARCHAR(255) — Primary key — NOT NULL
- VoltageTypeName — VARCHAR(255)
Untitled7
- ManufacturerCode — VARCHAR(255) — Primary key — NOT NULL
- Manufacturer — VARCHAR(255)
- ManufacturerEn — VARCHAR(255)
- created_at — VARCHAR(255)
- delete_flag — VARCHAR(255)
Untitled8
- id — VARCHAR(255) — Primary key — NOT NULL
- SlotNumber — VARCHAR(255)
- ChannelName — VARCHAR(255)
- EquipmentId — VARCHAR(255) — NOT NULL
Untitled9
- ComponentType — VARCHAR(255)
- ConponentTypeName — VARCHAR(255) — NOT NULL
mc_DataType
- id — INT — Primary key — NOT NULL
- DataType — VARCHAR(50)
mc_FilterType
- id — INT — Primary key — NOT NULL
- FilterType — VARCHAR(50)
mc_Purpse
- id — INT — Primary key — NOT NULL
- Purpose — VARCHAR(50)
mc_SensorType
- id — INT — Primary key — NOT NULL
- SensorType — VARCHAR(50)
mm_component
- id — VARCHAR(255) — Primary key — NOT NULL
- ComponentCode — INT
- ComponentName — INT
- Comment — VARCHAR(255)
- LastUpdatedTime — DATETIME
- DeleteFlag — VARCHAR
- Route_id — INT — NOT NULL
- ComponentType — VARCHAR(255)
mm_measurement
- id — VARCHAR(255) — Primary key — NOT NULL
- MeasureCode — VARCHAR(255)
- MeasureTime — DATETIME
- User — VARCHAR(255)
- DeleteFlag — VARCHAR(255)
- Comment — VARCHAR(255)
- PhaseId — VARCHAR(255) — NOT NULL
- SensorType — INT — NOT NULL
- DataType — INT — NOT NULL
- FilterType — INT — NOT NULL
- Purpose — INT — NOT NULL
- ChannelId — VARCHAR(255) — NOT NULL
- ComponentType — VARCHAR(255)
mm_route
- id — INT — Primary key — NOT NULL
- RouteCode — VARCHAR(255) — NOT NULL
- InstallationTime — DATETIME
- Comment — VARCHAR(255)
- LastUpdatedTime — DATETIME
- DeleteFlag — VARCHAR
- AreaCode — VARCHAR(20) — NOT NULL
- SiteName — VARCHAR(255)
- ManufacturerCode — VARCHAR(255) — NOT NULL
- VoltageType — VARCHAR(255) — NOT NULL
- InsulatorType — VARCHAR(255) — NOT NULL