-
Notifications
You must be signed in to change notification settings - Fork 2.3k
/
tables-main.sql.vpp
57 lines (54 loc) · 2.13 KB
/
tables-main.sql.vpp
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
CREATE TABLE BATCH_JOB_INSTANCE (
JOB_INSTANCE_ID ${BIGINT} $!{IDENTITY} NOT NULL PRIMARY KEY $!{GENERATED},
VERSION ${BIGINT} $!{NULL},
JOB_NAME ${VARCHAR}(100) NOT NULL,
JOB_KEY ${VARCHAR}(2500) $!{NULL},
constraint JOB_INST_UN unique (JOB_NAME, JOB_KEY)
) $!{VOODOO};
CREATE TABLE BATCH_JOB_EXECUTION (
JOB_EXECUTION_ID ${BIGINT} $!{IDENTITY} NOT NULL PRIMARY KEY $!{GENERATED},
VERSION ${BIGINT} $!{NULL},
JOB_INSTANCE_ID ${BIGINT} NOT NULL,
CREATE_TIME ${TIMESTAMP} NOT NULL,
START_TIME ${TIMESTAMP} DEFAULT NULL $!{NULL},
END_TIME ${TIMESTAMP} DEFAULT NULL $!{NULL},
STATUS ${VARCHAR}(10) $!{NULL},
EXIT_CODE ${VARCHAR}(20) $!{NULL},
EXIT_MESSAGE ${VARCHAR}(2500) $!{NULL},
LAST_UPDATED ${TIMESTAMP},
constraint JOB_INST_EXEC_FK foreign key (JOB_INSTANCE_ID)
references BATCH_JOB_INSTANCE(JOB_INSTANCE_ID)
) $!{VOODOO};
CREATE TABLE BATCH_JOB_PARAMS (
JOB_INSTANCE_ID ${BIGINT} NOT NULL ,
TYPE_CD ${VARCHAR}(6) NOT NULL ,
KEY_NAME ${VARCHAR}(100) NOT NULL ,
STRING_VAL ${VARCHAR}(250) $!{NULL},
DATE_VAL ${TIMESTAMP} DEFAULT NULL $!{NULL},
LONG_VAL ${BIGINT} $!{NULL},
DOUBLE_VAL ${DOUBLE} $!{NULL},
constraint JOB_INST_PARAMS_FK foreign key (JOB_INSTANCE_ID)
references BATCH_JOB_INSTANCE(JOB_INSTANCE_ID)
) $!{VOODOO};
CREATE TABLE BATCH_STEP_EXECUTION (
STEP_EXECUTION_ID ${BIGINT} $!{IDENTITY} NOT NULL PRIMARY KEY $!{GENERATED},
VERSION ${BIGINT} NOT NULL,
STEP_NAME ${VARCHAR}(100) NOT NULL,
JOB_EXECUTION_ID ${BIGINT} NOT NULL,
START_TIME ${TIMESTAMP} NOT NULL ,
END_TIME ${TIMESTAMP} DEFAULT NULL $!{NULL},
STATUS ${VARCHAR}(10) $!{NULL},
COMMIT_COUNT ${BIGINT} $!{NULL},
READ_COUNT ${BIGINT} $!{NULL},
FILTER_COUNT ${BIGINT} $!{NULL},
WRITE_COUNT ${BIGINT} $!{NULL},
READ_SKIP_COUNT ${BIGINT} $!{NULL},
WRITE_SKIP_COUNT ${BIGINT} $!{NULL},
PROCESS_SKIP_COUNT ${BIGINT} $!{NULL},
ROLLBACK_COUNT ${BIGINT} $!{NULL},
EXIT_CODE ${VARCHAR}(20) $!{NULL},
EXIT_MESSAGE ${VARCHAR}(2500) $!{NULL},
LAST_UPDATED ${TIMESTAMP},
constraint JOB_EXEC_STEP_FK foreign key (JOB_EXECUTION_ID)
references BATCH_JOB_EXECUTION(JOB_EXECUTION_ID)
) $!{VOODOO};