ㄷㄹ

Tables (6)

if_condition

  • if_condition_id — bigint
  • interval — int
  • isActive — bit
  • isGroup — bit
  • name — varchar(100)
  • purpose — varchar(25)
  • type — varchar(10)
  • updated — datetime

if_schedule

  • stop_time — time — Primary key
  • if_condition_id — bigint
  • if_schedule_id — bigint
  • start_time — time

if_target

  • if_target_id — bigint
  • alarm_type — varchar(50)
  • name — varchar(50)
  • useCurrentValue — bit
  • useDB — bit
  • useHistory — bit
  • groups_id — bigint
  • if_condition_id — bigint
  • tag_id — bigint

if_that

  • if_that_id — bigint
  • deshboaldPopup — bit
  • kakaoAlarmTalk — bit
  • alarm_talk_id — bigint
  • if_condition_id — bigint

if_then

  • if_then_id — bigint
  • dataType — varchar(50)
  • order — int
  • satisfy — bit
  • useCurrentValue — bit
  • useDB — bit
  • useHistory — bit
  • value — double
  • groups_id — bigint
  • if_condition_id — bigint
  • tag_id — bigint

tags

  • tag_id — bigint
  • calc_type — varchar(255)
  • comport_id — bigint
  • description — varchar(150)
  • is_trend — bit
  • logging — smallint — NOT NULL
  • site_id — int
  • tag_uid — binary(16) — NOT NULL
  • tagname — varchar(35)
  • tagtype — varchar(32)
  • unit — varchar(32)
  • workplace_id — int
  • device_id — bigint
  • tag_package_id — bigint