TEST

Tables (6)

TB_SENSOR_STATUS (센서수집정보)

  • SS_CD (Key3) — Foreign key → TB_WARSHIP_EQUIP_SENSOR_INFO.SS_CD — NOT NULL
  • EQ_CD (Key) — VARCHAR — Foreign key → TB_WARSHIP_EQUIP_SENSOR_INFO.EQ_CD — NOT NULL
  • WS_CD (Key2) — VARCHAR — Foreign key → TB_WARSHIP_EQUIP_SENSOR_INFO.WS_CD — NOT NULL
  • STATUS_FLAG (Field) — VARCHAR
  • WORK_FLAG (Field2) — VARCHAR
  • TEMP01 (Field3) — decimal(5,2)
  • TEMP02 (Field4) — decimal(5,2)
  • TEMP03 (Field5) — decimal(5,2)
  • TEMP04 (Field6) — decimal(5,2)
  • CPU_USE (Field7) — decimal(5,2)
  • MEM_USE (Field8) — decimal(5,2)
  • CPU_TEMP (Field9) — decimal(5,2)
  • ... (Field10)

TB_UNIT_INFO (함정의 소속 부대 정보)

  • UNIT_CD (Key) — VARCHAR — Primary key — NOT NULL
  • 부대 한글 명 (Field) — VARCHAR
  • ... — ...

TB_WARSHIP_EQUIP_INFO (함정 전자장비의 마스터)

  • EQ_CD (Key) — VARCHAR — Primary key — NOT NULL
  • WS_CD (Key2) — VARCHAR — Foreign key → TB_WARSHIP_INFO.WS_CD — NOT NULL
  • EQ_ID (Field) — VARCHAR
  • EQ_KOR_NM (Field2) — VARCHAR
  • ... (Field3)

TB_WARSHIP_EQUIP_SENSOR_INFO (함정의 핵심전자장비의 하드웨어 정보의 기준코드를 관리)

  • SS_CD (Key3) — Primary key — NOT NULL
  • EQ_CD (Key) — VARCHAR — Foreign key → TB_WARSHIP_EQUIP_INFO.EQ_CD — NOT NULL
  • WS_CD (Key2) — VARCHAR — Foreign key → TB_WARSHIP_EQUIP_INFO.WS_CD — NOT NULL
  • UP_SS_CD (Field) — VARCHAR
  • SS_ID (Field2) — VARCHAR
  • SS_KOR_NM (Field3) — VARCHAR
  • ... (Field4)

TB_WARSHIP_INFO (함정관리 마스터 정보)

  • WS_CD (Key) — VARCHAR — Primary key — NOT NULL
  • UNIT_CD (Key2) — VARCHAR — Foreign key → TB_UNIT_INFO.UNIT_CD — NOT NULL
  • WS_KOR_NM (Field) — VARCHAR
  • ... (Field2)

TB_WARSHIP_REM_LIFE_TRENDS1 (함정 데이터 기반 잔여수명 예측정보)

  • COLLECT_TIME (Key3) — TIMESTAMP — Primary key — NOT NULL
  • EQ_CD (Key) — VARCHAR — Foreign key → TB_SENSOR_STATUS.EQ_CD — NOT NULL
  • WS_CD (Key2) — VARCHAR — Foreign key → TB_SENSOR_STATUS.WS_CD — NOT NULL
  • STATUS_FLAG (Field) — INT
  • REM_LIFE (Field2) — DECIMAL(20,6)
  • TOTAL_TIME (Field3) — DECIMAL(20,6)