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)