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