SmartOnM-Integration
Tables (12)
INTEGRATION_EQUIPMENT (Untitled4)
- ID (Key) — INT — Primary key — NOT NULL
- EQUIPMENT_ID (Key2) — INT — Foreign key → TB_EQUIPMENT_INFORMATION.ID — NOT NULL
- CODE (Key3) — VARCHAR(64) — Foreign key → INTEGRATION_SERVICE.CODE — NOT NULL
- SERVICE_EQUIPMENT_ID (Key4) — INT — Foreign key → SERVICE_EQUIPMENT_INFORMATION.ID — NOT NULL
INTEGRATION_SERVICE
- CODE (Key) — VARCHAR(64) — Primary key — NOT NULL
- NAME (Field) — VARCHAR(128)
INTEGRATION_USER (Untitled)
- ID (Key) — INT — Primary key — NOT NULL
- USERNAME (Key3) — VARCHAR(32) — Foreign key → TB_USER_INFORMATION.USERNAME — NOT NULL
- SERVICE_CODE (Key2) — VARCHAR(64) — Foreign key → INTEGRATION_SERVICE.CODE — NOT NULL
- SERVICE_USERNAME (Key4) — VARCHAR(32) — Foreign key → SERVICE_USER_INFORMATION.USERNAME — NOT NULL
- INTEGRATION_KEY (Field2) — VARCHAR(128)
SERVICE_COMPANY_INFORMATION (CopyOfUntitled5)
- ID (Key) — INT — Primary key — NOT NULL
- NAME (Field) — VARCHAR(128)
- ADDRESS (Field2) — VARCHAR(255)
- PHONE (Field3) — VARCHAR(32)
- INS_DT (Field4) — TIMESTAMP
- UPD_DT (Field5) — TIMESTAMP
SERVICE_EQUIPMENT_INFORMATION (CopyOfUntitled3)
- ID (Key) — INT — Primary key — NOT NULL
- FACTORY_ID (Key2) — INT — Foreign key → SERVICE_FACTORY_INFORMATION.ID — NOT NULL
- CODE (Field2) — VARCHAR(128)
SERVICE_FACTORY_INFORMATION (CopyOfUntitled6)
- ID (Key) — INT — Primary key — NOT NULL
- COMPANY_ID (Key2) — INT — Foreign key → SERVICE_COMPANY_INFORMATION.ID — NOT NULL
- NAME (Field) — VARHCAR(128)
- ADDRESS (Field2) — VARCHAR(255)
- PHONE (Field3) — VARCHAR(32)
- INS_DT (Field4) — TIMESTAMP
- UPD_DT (Field5) — TIMESTAMP
SERVICE_INTEGRATION_USER (CopyOfUntitled)
- USERNAME (Key4) — VARCHAR(32) — Foreign key → SERVICE_USER_INFORMATION.USERNAME — NOT NULL
- OnM_USERNAME (Key3) — VARCHAR(32) — Foreign key → TB_USER_INFORMATION.USERNAME — NOT NULL
- INTEGRATION_KEY (Field2) — VARCHAR(128)
SERVICE_USER_INFORMATION (CopyOfUntitled2)
- USERNAME (Key) — VARCHAR(32) — Primary key — NOT NULL
- PASSWORD (Field) — VARCHAR(128)
- FULL_NAME (Field2) — VARCHAR(128)
- COMPANY_ID (Field3) — INT
- PHONE (Field4) — VARCHAR(32)
- MAIL (Field5) — VARCHAR(128)
- LAST_LOGIN_DT (Field6) — TIMESTAMP
- INS_DT (Field7) — TIMESTAMP
- UPD_DT (Field8) — TIMESTAMP
TB_COMPANY_INFORMATION (Untitled5)
- ID (Key) — INT — Primary key — NOT NULL
- NAME (Field) — VARCHAR(128)
- ADDRESS (Field2) — VARCHAR(255)
- PHONE (Field3) — VARCHAR(32)
- INS_DT (Field4) — TIMESTAMP
- UPD_DT (Field5) — TIMESTAMP
TB_EQUIPMENT_INFORMATION (Untitled3)
- ID (Key) — INT — Primary key — NOT NULL
- FACTORY_ID (Key2) — INT — Foreign key → TB_FACTORY_INFORMATION.ID — NOT NULL
- CODE (Field2) — VARCHAR(128)
TB_FACTORY_INFORMATION (Untitled6)
- ID (Key) — INT — Primary key — NOT NULL
- COMPANY_ID (Key2) — INT — Foreign key → TB_COMPANY_INFORMATION.ID — NOT NULL
- NAME (Field) — VARHCAR(128)
- ADDRESS (Field2) — VARCHAR(255)
- PHONE (Field3) — VARCHAR(32)
- INS_DT (Field4) — TIMESTAMP
- UPD_DT (Field5) — TIMESTAMP
TB_USER_INFORMATION (Untitled2)
- USERNAME (Key) — VARCHAR(32) — Primary key — NOT NULL
- COMPANY_ID (Key2) — INT — Foreign key → TB_COMPANY_INFORMATION.ID — NOT NULL
- PASSWORD (Field) — VARCHAR(128)
- FULL_NAME (Field2) — VARCHAR(128)
- PHONE (Field4) — VARCHAR(32)
- MAIL (Field5) — VARCHAR(128)
- LAST_LOGIN_DT (Field6) — TIMESTAMP
- INS_DT (Field7) — TIMESTAMP
- UPD_DT (Field8) — TIMESTAMP