kcl

Tables (33)

access_log (Untitled)

  • ACCESS_ID (Key2) — int(11) — Primary key — NOT NULL
  • USER_NAME (Field) — int(11)
  • ACCESS_DATE (Field2) — datetime
  • AUTH_ACTION (Field3) — varchar(32)
  • AUTH_RESULT (Field4) — varchar(32)
  • AUTH_RESPONSE (Field5) — varchar(255)
  • PROJECT_ID (Field6) — int(11)

alarm_condition (Untitled2)

  • Confition_ID (Key) — int(11) — Primary key — NOT NULL
  • GRADE_ID (Key2) — int(11) — Foreign key → alarm_grade_info.GRADE_ID — NOT NULL
  • SENSOR_ID (Key3) — int(11) — Foreign key → sensor_info.SENSOR_ID — NOT NULL
  • CONTENTS (Field3) — varchar(255)
  • ALARM_TYPE (Field4) — varchar(32)
  • THRESHOLD (Field5) — float
  • THRESHOLD_CONDITION (Field6) — tinyint(4)
  • ALARM_AVAILABLE (Field7)

alarm_grade_info (Untitled3)

  • GRADE_ID (Key) — int(11) — Primary key — NOT NULL
  • GRADE_TEXT (Field) — varchar(64)

alarm_log (Untitled5)

  • ALARM_ID (Key) — int(11) — Primary key — NOT NULL
  • SENSOR_ID (Key2) — int(11) — Foreign key → sensor_info.SENSOR_ID — NOT NULL
  • GRADE_ID (Key3) — int(11) — Foreign key → alarm_grade_info.GRADE_ID — NOT NULL
  • USER_ID (Field3) — int(11)
  • ALARM_TYPE (Field4) — varchar(32)
  • SENT_DATE (Field5) — datetime
  • GEN_DATE (Field6) — datetime
  • CONTENTS (Field7) — varchar(255)
  • ALARM_STATUS (Field8) — char(1)
  • ALARM_CATEGORY (Field9) — char(1)

auth_info (Untitled4)

  • AUTH_ID (Key) — tinyint(4) — Primary key — NOT NULL
  • AUTH_NAME (Field) — varchar(64)

command_log (Untitled6)

  • COMMAND_ID (Key) — int(11) — Primary key — NOT NULL
  • NODE_ID (Key2) — int(11) — Foreign key → node_info.NODE_ID — NOT NULL
  • DEVICE_ID (Key3) — int(11) — Foreign key → node_info.DEVICE_ID — NOT NULL
  • COMMAND (Field3) — varchar(16)
  • SEND_DATA (Field4) — vcarchar(128)
  • RECORD_DT (Field5) — datetime
  • SEND_DT (Field6) — datetime
  • RESPONSE (Field7) — varchar(128)
  • COMMAND_STATUS (Field8) — char(1)
  • DESCRIPTION (Field9) — varchar(255)

control_info (Untitled7)

  • CONTROL_ID (Key) — int(11) — Primary key — NOT NULL
  • COMMAND (Field) — varchar(16)
  • SET_DATA (Field2) — varchar(128)
  • DATA_TYPE (Field3) — varchar(16)
  • DATA_ENCODE (Field4) — varchar(16)
  • DEVICE_MODEL (Field5) — varchar(128)
  • DESCRIPTION (Field6) — varchar(255)
  • Field7

cs_info (Untitled8)

  • CS_ID (Key) — int(1!) — Primary key — NOT NULL
  • TYPE_ID (Key2) — tinyint(4) — Foreign key → cs_type_info.TYPE_ID — NOT NULL
  • INPUT_DATE (Field2) — datetime
  • INCHARGE (Field3) — varchar(64)
  • WORK_DATE (Field4) — datetime
  • CONTENTS (Field5) — varchar(255)
  • DEVICE_ID (Field6) — int(1!)
  • Field7

cs_type_info (Untitled9)

  • TYPE_ID (Key) — tinyint(4) — Primary key — NOT NULL
  • TYPE_TEXT (Field) — varchar(255)

device_info (Untitled10)

  • DEVICE_ID (Key) — int(11) — Primary key — NOT NULL
  • FACILITY_ID (Key2) — int(11) — Foreign key → facility_info.FACILITY_ID — NOT NULL
  • DEVICE_NAME (Field2) — varchar(128)
  • DEVICE_MODEL (Field3) — varchar(64)
  • DEVICE_TYPE (Field4) — varchar(64)
  • DEVICE_VERSION (Field5) — varchar(64)
  • INSTALL_DATE (Field6) — datetime
  • PERIOD_SEC (Field7) — int(11)
  • PERIOD_CNT (Field8) — int(11)
  • MANUFACTURER (Field9) — varchar(64)
  • SERIAL_NUM (Field10) — varchar(64)
  • DESCRIPTION (Field13) — varchar(255)
  • DEVICE_STATUS (Field11) — char(1)
  • SERVICE_ID (Field12) — smallint(6)

facility_info (Untitled11)

  • FACILITY_ID (Key) — int(11) — Primary key — NOT NULL
  • FACILITY_NAME (Field) — varchar(128)
  • FACILITY_POSITION (Field2) — varchar(255)
  • FACILITY_NUMBER (Field3) — varchar(64)
  • LATITUDE (Field4) — float
  • LONGITUDE (Field5) — float
  • DESCRIPTION (Field6) — varchar(255)
  • CUSTOM_ATTR1 (Field7) — varchar(32)
  • CUSTOM_ATTR2 (Field8) — varchar(32)
  • CUSTOM_ATTR3 (Field9) — varchar(32)
  • CUSTOM_ATTR4 (Field10) — varchar(32)
  • CUSTOM_ATTR5 (Field11) — varchar(32)
  • CUSTOM_ATTR6 (Field12) — varchar(32)
  • PROJECT_ID (Field13) — int(11)

group_device (Untitled12)

  • GROUP_ID (Key3) — INT(11) — Foreign key → group_info.GROUP_ID — NOT NULL
  • DEVICE_ID (Key2) — int(11) — Foreign key → device_info.DEVICE_ID — NOT NULL

group_info (Untitled13)

  • GROUP_ID (Key) — INT(11) — Primary key — NOT NULL
  • GROUP_NAME (Field) — varchar(255)
  • PAR_GROUP_ID (Field2) — int(11)
  • CREATE_DT (Field3) — datetime

maintenance_log (Untitled14)

  • MAINTENANCE_ID (Key) — int(11) — Primary key — NOT NULL
  • TYPE_ID (Key2) — tinyint(4) — Foreign key → maintenance_type_info.TYPE_ID — NOT NULL
  • DEVICE_ID (Field2) — int(11)
  • MAINTENANCE_DATE (Field3) — datetime
  • DESCRIPTION (Field4) — varchar(255)
  • Field5

maintenance_type_info (Untitled15)

  • TYPE_ID (Key) — tinyint(4) — Primary key — NOT NULL
  • TYE_TEXT (Field) — varchar(128)
  • Field2

node_info (Untitled16)

  • NODE_ID (Key) — int(11) — Primary key — NOT NULL
  • DEVICE_ID (Key3) — int(11) — Foreign key → device_info.DEVICE_ID — NOT NULL
  • DEVICE_MODEL (Field) — varchar(64)
  • SERVICE_CODE (Field2) — varchar(64)
  • NODE_TYPE (Field3) — varchar(32)
  • CTN (Field4) — varchar(64)
  • MAC (Field5) — varchar(64)
  • DEVICE_SERIAL (Field6) — varchar(64)
  • ICCID (Field7) — varchar(128)
  • ENTITY_ID (Field8) — varchar(255)
  • ENRM_KEY (Field9) — varchar(255)
  • TOKEN (Field10) — varchar(255)
  • ENRM_KEY_ID (Field11) — varchar(255)
  • RECHABLE (Field12) — char(1)
  • REG_TIME (Field13) — datetime

picture_info (Untitled17)

  • PICTURE_ID (Key) — int(11) — Primary key — NOT NULL
  • DEVICE_ID (Key2) — int(11) — Foreign key → device_info.DEVICE_ID — NOT NULL
  • PICTURE_PATH (Field2) — varchar(255)
  • PICTURE_TYPE (Field3) — char(1)
  • REG_DATE (Field4) — datetime

project (Untitled18)

  • PROJECT_ID (Key) — int(11) — Primary key — NOT NULL
  • PRIJECT_CODE (Field) — varchar(32)
  • PROJECT_NAME (Field2) — varchar(128)
  • BLD_DATE (Field3) — datetime
  • CLS_DATE (Field4) — datetime
  • LATITUDE (Field5) — float
  • LONGITUDE (Field6) — float
  • MNGER_UID (Field7) — int(11)
  • PROJECT_DESC (Field8) — varchar(255)
  • IS_DELETE (Field9) — char(1)
  • Field10

project_service (Untitled19)

  • PROJECT_ID (Key3) — int(11) — Foreign key → project.PROJECT_ID — NOT NULL
  • SERVICE_ID (Key4) — smallint(6) — Foreign key → service.SERVICE_ID — NOT NULL
  • VISIBLE (Field2) — char(1)
  • DESPLAY_NAME (Field3) — varchar(128)
  • DESPLAY_ORDER (Field4) — smallint(6)

recent_data (Untitled20)

  • SENSOR_ID (Key2) — int(11) — Foreign key → sensor_info.SENSOR_ID — NOT NULL
  • DATA_VALUE (Field) — float
  • MEASURE_DT (Field2) — datetime
  • RECORD_DT (Field3) — datetime

sensor_data (Untitled21)

  • DATA_ID (Key) — bigintt(20) — Primary key — NOT NULL
  • SENSOR_ID (Key4) — int(11) — Foreign key → sensor_info.SENSOR_ID — NOT NULL
  • DATA_VALUE (Field) — float
  • MEASURE_DT (Key3) — datetime — NOT NULL
  • RECORD_DT (Field2) — datetime
  • VALUE_INDEX (Field3) — int

sensor_data_history (Untitled22)

  • DATA_ID (Key4) — bigintt(20) — Foreign key → sensor_data.DATA_ID — NOT NULL
  • SENSOR_ID (Key5) — int(11) — Foreign key → sensor_info.SENSOR_ID — NOT NULL
  • DATA_VALUE (Field2) — float
  • MEASURE_DT (Key2) — datetime — NOT NULL
  • RECORD_DT (Field3) — datetime
  • VALUE_INDEX (Field4) — int(11)
  • ACTION (Field5) — varchar(20)
  • ACTION_DT (Key3) — datetime — NOT NULL

sensor_info (Untitled23)

  • SENSOR_ID (Key) — int(11) — Primary key — NOT NULL
  • DEVICE_ID (Key2) — int(11) — Foreign key → device_info.DEVICE_ID — NOT NULL
  • TYPE_ID (Key3) — int(11) — Foreign key → sensor_type_info.TYPE_ID — NOT NULL
  • SENSOR_NAME (Field3) — varchar(128)
  • MANUFACTURER (Field4) — varchar(64)
  • SERIAL_NUM (Field5) — varchar(64)
  • VISIBLE (Field14) — char(1)
  • INSTALL_DATE (Field6) — datetime
  • DESCRIPTION (Field7) — varchar(255)
  • SENSOR_STATUS (Field8) — char(1)
  • OFFSET_VALUE (Field9) — float
  • MAX_THRESHOLD (Field10) — float
  • MIN_THRESHOLD (Field11) — float
  • VALUE_MAGNIFICATION (Field12) — float
  • DATA_LINK (Field13) — varchar(255)

sensor_type_info (Untitled24)

  • TYPE_ID (Key) — int(11) — Primary key — NOT NULL
  • TYPE_CODE (Field) — varchar(16)
  • TYPE_NAME (Field2) — varchar(128)
  • UNIT (Field3) — varchar(16)
  • MAX_VALUE (Field4) — float
  • MIN_VALUE (Field5) — float
  • VISIBLE (Field6) — char(1)
  • MAX_THRESHOLD (Field7) — float
  • MIN_THRESHOLD (Field8) — float

service (Untitled25)

  • SERVICE_ID (Key) — smallint(6) — Primary key — NOT NULL
  • SERVICE_CODE (Field) — varchar(16)
  • SERVICE_NAME (Field2) — varchar(128)
  • SERVICE_DESC (Field3) — varchar(255)
  • IS_DELETE (Field4) — char(1)

service_sensor_type (Untitled26)

  • SERVICE_ID (Field) — smallint(6)
  • PROJECT_ID (Field2) — int(11)
  • TYPE_ID (Field3) — int(11)
  • VISIBLE (Field4) — char(1)
  • DISPLAY_NAME (Field5) — varchar(128)
  • DISPLAY_ORDER (Field6) — tinyint(4)
  • DATA_LINK (Field7) — varchar(255)

site_info (Untitled27)

  • SITE_ID (Key) — int(11) — Primary key — NOT NULL
  • SITE_NAME (Field) — varchar(128)
  • COMPANY (Field2) — varchar(64)
  • DESCRIPTION (Field3) — varchar(255)
  • LOGO_PATH (Field4) — varchar(255)
  • ADDRESS (Field5) — varchar(255)
  • SITE_URL (Field6) — varchar(128)
  • REP_PHONE (Field7) — varchar(16)
  • SDT (Field8) — datetime
  • IS_DELETE (Field9) — char(1)

site_project (Untitled28)

  • SITE_ID (Key3) — int(11) — Foreign key → site_info.SITE_ID — NOT NULL
  • PROJECT_ID (Key) — int(11) — Foreign key → project.PROJECT_ID — NOT NULL

ticker_info (Untitled29)

  • TICKER_ID (Key) — int(11) — Primary key — NOT NULL
  • TICKER_CONTENT (Field) — varchar(255)
  • TICKER_LINK (Field2) — varchar(255)
  • START_DT (Field3) — datetime
  • END_DT (Field4) — datetime
  • PROJECT_ID (Field5) — int(11)
  • VISIBLE (Field6) — char(1)

user_group (Untitled30)

  • USER_ID (Key) — int(11) — Foreign key → user_info.USER_ID — NOT NULL
  • GROUP_ID (Key2) — INT(11) — Foreign key → group_info.GROUP_ID — NOT NULL

user_info (Untitled31)

  • USER_ID (Key) — int(11) — Primary key — NOT NULL
  • AUTH_ID (Key2) — tinyint(4) — Foreign key → auth_info.AUTH_ID — NOT NULL
  • EMAIL (Field2) — varchar(255)
  • USER_NAME (Field3) — varchar(128)
  • PASSWORD (Field4) — varchar(128)
  • PHONE (Field5) — varchar(32)
  • SITE_ID (Field6) — int(11)
  • REG_TIME (Field7) — datetime
  • TOKEN (Field8) — varchar(255)
  • ALARM (Field9) — char(1)
  • DIVISION (Field10) — varchar(64)
  • POSITION (Field11) — varchar(64)
  • USER_STATUS (Field12) — char(1)

user_project (Untitled32)

  • USER_ID (Key) — int(11) — Foreign key → user_info.USER_ID — NOT NULL
  • PROJECT_ID (Key2) — int(11) — Foreign key → project.PROJECT_ID — NOT NULL

user_service (Untitled33)

  • USER_ID (Key) — int(11) — Foreign key → user_info.USER_ID — NOT NULL
  • PROJECT_ID (Key2) — int(11) — Foreign key → project.PROJECT_ID — NOT NULL
  • SERVICE_ID (Field3) — smallint(6)
  • VISIBLE (Field4) — char(1)