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