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)