SMND_PILOT2

테이블 (17)

CopyOfUntitled10

  • id — VARCHAR(255) — 기본 키 — NOT NULL
  • PhaseName — VARCHAR(255)
  • ComponentType — VARCHAR(255) — 외래 키 → mm_component.ComponentType
  • Key — 외래 키 → mm_component.Key — NOT NULL

Untitled

  • id — VARCHAR(255) — 기본 키 — NOT NULL
  • Field — VARCHAR(255)
  • Field2 — VARCHAR(255)
  • Field4 — VARCHAR(255)
  • Field5 — VARCHAR(255)
  • Field3 — VARCHAR(255)

Untitled10

  • id — VARCHAR(255) — 기본 키 — NOT NULL
  • Customer — VARCHAR(255)
  • CustomerEn — VARCHAR(255)
  • created_at — VARCHAR(255)
  • delete_flag — VARCHAR(255)

Untitled2

  • AreaCode — VARCHAR(20) — 기본 키 — 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) — 기본 키 — NOT NULL
  • SiteName — VARCHAR(255)

Untitled5

  • InsulatorType — VARCHAR(255) — 기본 키 — NOT NULL
  • InsulatorTypeNAme — VARCHAR(255)

Untitled6

  • VoltageType — VARCHAR(255) — 기본 키 — NOT NULL
  • VoltageTypeName — VARCHAR(255)

Untitled7

  • ManufacturerCode — VARCHAR(255) — 기본 키 — NOT NULL
  • Manufacturer — VARCHAR(255)
  • ManufacturerEn — VARCHAR(255)
  • created_at — VARCHAR(255)
  • delete_flag — VARCHAR(255)

mc_DataType

  • id — INT — 기본 키 — NOT NULL
  • DataType — VARCHAR(50)

mc_FilterType

  • id — INT — 기본 키 — NOT NULL
  • FilterType — VARCHAR(50)

mc_Purpse

  • id — INT — 기본 키 — NOT NULL
  • Purpose — VARCHAR(50)

mc_SensorType

  • id — INT — 기본 키 — NOT NULL
  • SensorType — VARCHAR(50)

mm_component

  • id — VARCHAR(255) — 기본 키 — NOT NULL
  • ComponentCode — INT
  • ComponentName — INT
  • Comment — VARCHAR(255)
  • LastUpdatedTime — DATETIME
  • DeleteFlag — VARCHAR
  • Route_id — INT — 외래 키 → mm_route.id — NOT NULL
  • ComponentType — VARCHAR(255) — 외래 키 → 접속함유형.ComponentType
  • Key — 외래 키 → 접속함유형.Key — NOT NULL

mm_measurement

  • id — VARCHAR(255) — 기본 키 — NOT NULL
  • MeasureCode — VARCHAR(255)
  • MeasureTime — DATETIME
  • User — VARCHAR(255)
  • DeleteFlag — VARCHAR(255)
  • Comment — VARCHAR(255)
  • PhaseId — VARCHAR(255) — 외래 키 → CopyOfUntitled10.id — NOT NULL
  • SensorType — INT — 외래 키 → mc_SensorType.id — NOT NULL
  • DataType — INT — 외래 키 → mc_DataType.id — NOT NULL
  • FilterType — INT — 외래 키 → mc_FilterType.id — NOT NULL
  • Purpose — INT — 외래 키 → mc_Purpse.id — NOT NULL
  • ChannelId — VARCHAR(255) — 외래 키 → 슬롯.id — NOT NULL
  • ComponentType — VARCHAR(255) — 외래 키 → CopyOfUntitled10.ComponentType
  • Key — 외래 키 → CopyOfUntitled10.Key — NOT NULL

mm_route

  • id — INT — 기본 키 — NOT NULL
  • RouteCode — VARCHAR(255) — NOT NULL
  • InstallationTime — DATETIME
  • Comment — VARCHAR(255)
  • LastUpdatedTime — DATETIME
  • DeleteFlag — VARCHAR
  • AreaCode — VARCHAR(20) — 외래 키 → Untitled2.AreaCode — NOT NULL
  • SiteName — VARCHAR(255)
  • ManufacturerCode — VARCHAR(255) — 외래 키 → Untitled7.ManufacturerCode — NOT NULL
  • VoltageType — VARCHAR(255) — 외래 키 → Untitled6.VoltageType — NOT NULL
  • InsulatorType — VARCHAR(255) — 외래 키 → Untitled5.InsulatorType — NOT NULL

슬롯 (Untitled8)

  • id — VARCHAR(255) — 기본 키 — NOT NULL
  • SlotNumber — VARCHAR(255)
  • ChannelName — VARCHAR(255)
  • EquipmentId — VARCHAR(255) — 외래 키 → Untitled.id — NOT NULL

접속함유형 (Untitled9)

  • Key — 기본 키 — NOT NULL
  • ComponentType — VARCHAR(255)
  • ConponentTypeName — VARCHAR(255) — NOT NULL