2024年4月12日发(作者：)

-- ----------------------------

-- Table structure for `JobParameter`

-- ----------------------------

CREATE TABLE HF_JOB_PARAMETER (ID NUMBER (10)

,NAME NVARCHAR2 (40)

,VALUE NCLOB

,JOB_ID NUMBER (10))

LOGGING

NOCOMPRESS

NOCACHE

NOPARALLEL

MONITORING;

ALTER TABLE HF_JOB_PARAMETER ADD (

PRIMARY KEY

(ID)

USING INDEX

ENABLE VALIDATE);

ALTER TABLE HF_JOB_PARAMETER ADD (

CONSTRAINT FK_JOB_PARAMETER_JOB

FOREIGN KEY (JOB_ID)

REFERENCES HF_JOB (ID)

ON DELETE CASCADE ENABLE VALIDATE);

-- ----------------------------

-- Table structure for `JobQueue`

-- ----------------------------

CREATE TABLE HF_JOB_QUEUE (ID NUMBER (10)

,JOB_ID NUMBER (10)

,QUEUE NVARCHAR2 (50)

,FETCHED_AT TIMESTAMP (4)

,FETCH_TOKEN NVARCHAR2 (36))

LOGGING

NOCOMPRESS

NOCACHE

NOPARALLEL

MONITORING;

ALTER TABLE HF_JOB_QUEUE ADD (

PRIMARY KEY

(ID)

USING INDEX

ENABLE VALIDATE);

ALTER TABLE HF_JOB_QUEUE ADD (

CONSTRAINT FK_JOB_QUEUE_JOB

FOREIGN KEY (JOB_ID)

REFERENCES HF_JOB (ID)

ON DELETE CASCADE ENABLE VALIDATE);

-- ----------------------------

-- Table structure for `JobState`

-- ----------------------------

CREATE TABLE HF_JOB_STATE (ID NUMBER (10)

,JOB_ID NUMBER (10)

,NAME NVARCHAR2 (20)

,REASON NVARCHAR2 (100)

,CREATED_AT TIMESTAMP (4)

,DATA NCLOB)

LOGGING

NOCOMPRESS

NOCACHE

NOPARALLEL

MONITORING;

ALTER TABLE HF_JOB_STATE ADD (

PRIMARY KEY

(ID)

USING INDEX

ENABLE VALIDATE);

ALTER TABLE HF_JOB_STATE ADD (

CONSTRAINT FK_JOB_STATE_JOB

FOREIGN KEY (JOB_ID)

REFERENCES HF_JOB (ID)

ON DELETE CASCADE ENABLE VALIDATE);

-- ----------------------------

-- Table structure for `Server`

-- ----------------------------

CREATE TABLE HF_SERVER (ID NVARCHAR2 (100), DATA NCLOB, LAST_HEART_BEAT TIMESTAMP (4))

LOGGING

NOCOMPRESS

NOCACHE

NOPARALLEL

MONITORING;

ALTER TABLE HF_SERVER ADD (

PRIMARY KEY

(ID)

USING INDEX

ENABLE VALIDATE);

-- ----------------------------

-- Table structure for `Set`

-- ----------------------------

CREATE TABLE HF_SET (ID NUMBER (10)

,KEY NVARCHAR2 (255)

,VALUE NVARCHAR2 (255)

,SCORE FLOAT (126)

,EXPIRE_AT TIMESTAMP (4))

LOGGING

NOCOMPRESS

NOCACHE

NOPARALLEL

MONITORING;

ALTER TABLE HF_SET ADD (

PRIMARY KEY

(ID)

USING INDEX

ENABLE VALIDATE,

UNIQUE (KEY, VALUE)