XE

Tables (6)

XE_PRECONDITION

  • ID — BIGSERIAL — Primary key — NOT NULL
  • TARGET_DB_ID — BIGINT — Foreign key → XE_TARGET_DB.ID — NOT NULL
  • NAME — VARCHAR(255)
  • SQL — TEXT
  • CREATED_DATE — TIMESTAMP
  • MODIFIED_DATE — TIMESTAMP

XE_SQL

  • ID — BIGSERIAL — Primary key — NOT NULL
  • SQL_NAME — VARCHAR(255)
  • QUERY — CLOB
  • CREATED_DATE — TIMESTAMP
  • MODIFIED_DATE — TIMESTAMP

XE_SQL_TASK

  • ID — BIGSERIAL — Primary key — NOT NULL
  • TASK_NAME — VARCHAR(255)
  • CREATED_DATE — TIMESTAMP
  • MODIFIED_DATE — TIMESTAMP

XE_SQL_TASK_CASE

  • ID — BIGSERIAL — Primary key — NOT NULL
  • XE_SQL_ID — BIGINT — Foreign key → XE_SQL.ID — NOT NULL
  • XE_SQL_TASK_ID — BIGINT — Foreign key → XE_SQL_TASK.ID — NOT NULL
  • XE_TARGET_DB_ID — BIGINT — Foreign key → XE_TARGET_DB.ID — NOT NULL
  • EXECUTION_ORDER — INTEGER
  • CREATED_DATE — TIMESTAMP
  • MODIFIED_DATE — TIMESTAMP

XE_SQL_TASK_JOB

  • ID — BIGSERIAL — Primary key — NOT NULL
  • XE_SQL_TASK_ID — BIGINT — Foreign key → XE_SQL_TASK.ID — NOT NULL
  • IS_FINISHED — BOOLEAN
  • TIMEOUT_MINUTE — INTEGER
  • SESSION_ID — VARCHAR(255)
  • MODIFIED_DATE — TIMESTAMP
  • CREATED_DATE — TIMESTAMP

XE_TARGET_DB

  • ID — BIGSERIAL — Primary key — NOT NULL
  • NAME — VARCHAR(255)
  • HOST — VARCHAR(255)
  • PORT — INTEGER
  • USERNAME — VARCHAR(255)
  • PASSWORD — VARCHAR(255)
  • DATABASE_NAME — VARCHAR(255)
  • DATABASE_TYPE — VARCHAR(32)
  • CREATED_DATE — TIMESTAMP
  • MODIFIED_DATE — TIMESTAMP