123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732 |
- -- SP_GRID_CATEGORY - 网格类别
- CREATE TABLE "SECURE_PRODUCTING"."SP_GRID_CATEGORY"(
- "ID" BIGINT NOT NULL,
- "CATEGORY_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "DESCRIPTION" VARCHAR(50) NOT NULL DEFAULT '',
- "STATUS" TINYINT NOT NULL DEFAULT 0,
- "CREATE_TIME" BIGINT NOT NULL DEFAULT 0,
- "UPDATE_TIME" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(),
- "CREATE_BY" VARCHAR(50) NOT NULL DEFAULT '',
- "CREATE_BY_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "UPDATE_BY" VARCHAR(50) NOT NULL DEFAULT '',
- "UPDATE_BY_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "IS_DELETE" TINYINT NOT NULL DEFAULT 0,
- -- 主键
- PRIMARY KEY("ID")
- );
- -- 索引
- CREATE INDEX IDX_SP_GRID_CATEGORY_STATUS ON "SECURE_PRODUCTING"."SP_GRID_CATEGORY"("STATUS");
- CREATE INDEX IDX_SP_GRID_CATEGORY_CREATE_TIME ON "SECURE_PRODUCTING"."SP_GRID_CATEGORY"("CREATE_TIME");
- -- 触发器:自动赋值最后修改时间
- CREATE OR REPLACE TRIGGER "TG_SP_GRID_CATEGORY"
- BEFORE INSERT OR UPDATE ON "SECURE_PRODUCTING"."SP_GRID_CATEGORY" FOR EACH ROW
- BEGIN
- :new.UPDATE_TIME=CURRENT_TIMESTAMP();
- END;
- -- 字段描述
- COMMENT ON TABLE "SECURE_PRODUCTING"."SP_GRID_CATEGORY" IS '网格类别';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_CATEGORY"."ID" IS '主键';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_CATEGORY"."CATEGORY_NAME" IS '类别名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_CATEGORY"."DESCRIPTION" IS '描述';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_CATEGORY"."STATUS" IS '状态 EState';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_CATEGORY"."CREATE_TIME" IS '数据创建时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_CATEGORY"."UPDATE_TIME" IS '最后更新时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_CATEGORY"."CREATE_BY" IS '数据创建人';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_CATEGORY"."CREATE_BY_NAME" IS '数据创建人名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_CATEGORY"."UPDATE_BY" IS '最后更新人';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_CATEGORY"."UPDATE_BY_NAME" IS '最后更新人名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_CATEGORY"."IS_DELETE" IS '是否删除(逻辑删除)';
- -- SP_DANGER_CATEGORY - 隐患类别
- CREATE TABLE "SECURE_PRODUCTING"."SP_DANGER_CATEGORY"(
- "ID" BIGINT NOT NULL,
- "CATEGORY_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "CHECK_CYCLE" TINYINT NOT NULL DEFAULT 0,
- "DESCRIPTION" VARCHAR(50) NOT NULL DEFAULT '',
- "STATUS" TINYINT NOT NULL DEFAULT 0,
- "CREATE_TIME" BIGINT NOT NULL DEFAULT 0,
- "UPDATE_TIME" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(),
- "CREATE_BY" VARCHAR(50) NOT NULL DEFAULT '',
- "CREATE_BY_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "UPDATE_BY" VARCHAR(50) NOT NULL DEFAULT '',
- "UPDATE_BY_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "IS_DELETE" TINYINT NOT NULL DEFAULT 0,
- -- 主键
- PRIMARY KEY("ID")
- );
- -- 索引
- CREATE INDEX IDX_SP_DANGER_CATEGORY_STATUS ON "SECURE_PRODUCTING"."SP_DANGER_CATEGORY"("STATUS");
- CREATE INDEX IDX_SP_DANGER_CATEGORY_CREATE_TIME ON "SECURE_PRODUCTING"."SP_DANGER_CATEGORY"("CREATE_TIME");
- -- 触发器:自动赋值最后修改时间
- CREATE OR REPLACE TRIGGER "TG_SP_DANGER_CATEGORY"
- BEFORE INSERT OR UPDATE ON "SECURE_PRODUCTING"."SP_DANGER_CATEGORY" FOR EACH ROW
- BEGIN
- :new.UPDATE_TIME=CURRENT_TIMESTAMP();
- END;
- -- 字段描述
- COMMENT ON TABLE "SECURE_PRODUCTING"."SP_DANGER_CATEGORY" IS '隐患类别';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CATEGORY"."ID" IS '主键';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CATEGORY"."CATEGORY_NAME" IS '类别名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CATEGORY"."CHECK_CYCLE" IS '检查频率 ECheckCycle';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CATEGORY"."DESCRIPTION" IS '描述';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CATEGORY"."STATUS" IS '状态 EState';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CATEGORY"."CREATE_TIME" IS '数据创建时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CATEGORY"."UPDATE_TIME" IS '最后更新时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CATEGORY"."CREATE_BY" IS '数据创建人';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CATEGORY"."CREATE_BY_NAME" IS '数据创建人名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CATEGORY"."UPDATE_BY" IS '最后更新人';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CATEGORY"."UPDATE_BY_NAME" IS '最后更新人名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CATEGORY"."IS_DELETE" IS '是否删除(逻辑删除)';
- -- SP_GRID_INFO - 网格信息
- CREATE TABLE "SECURE_PRODUCTING"."SP_GRID_INFO"(
- "ID" BIGINT NOT NULL,
- "GRID_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "DEPARTMENT" VARCHAR(500) NOT NULL DEFAULT '',
- "DEPARTMENT_NAME" VARCHAR(1000) NOT NULL DEFAULT '',
- "GRID_CATEGORY" BIGINT NOT NULL DEFAULT 0,
- "DANGER_CATEGORY" BIGINT NOT NULL DEFAULT 0,
- "GRID_PERSON_DUTY" VARCHAR(500) NOT NULL DEFAULT '',
- "STATUS" TINYINT NOT NULL DEFAULT 0,
- "CREATE_TIME" BIGINT NOT NULL DEFAULT 0,
- "UPDATE_TIME" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(),
- "CREATE_BY" VARCHAR(50) NOT NULL DEFAULT '',
- "CREATE_BY_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "UPDATE_BY" VARCHAR(50) NOT NULL DEFAULT '',
- "UPDATE_BY_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "IS_DELETE" TINYINT NOT NULL DEFAULT 0,
- -- 主键
- PRIMARY KEY("ID")
- );
- -- 索引
- CREATE INDEX IDX_SP_GRID_INFO_DEPARTMENT ON "SECURE_PRODUCTING"."SP_GRID_INFO"("DEPARTMENT");
- CREATE INDEX IDX_SP_GRID_INFO_GRID_CATEGORY ON "SECURE_PRODUCTING"."SP_GRID_INFO"("GRID_CATEGORY");
- CREATE INDEX IDX_SP_GRID_INFO_DANGER_CATEGORY ON "SECURE_PRODUCTING"."SP_GRID_INFO"("DANGER_CATEGORY");
- CREATE INDEX IDX_SP_GRID_INFO_STATUS ON "SECURE_PRODUCTING"."SP_GRID_INFO"("STATUS");
- CREATE INDEX IDX_SP_GRID_INFO_CREATE_TIME ON "SECURE_PRODUCTING"."SP_GRID_INFO"("CREATE_TIME");
- -- 触发器:自动赋值最后修改时间
- CREATE OR REPLACE TRIGGER "TG_SP_GRID_INFO"
- BEFORE INSERT OR UPDATE ON "SECURE_PRODUCTING"."SP_GRID_INFO" FOR EACH ROW
- BEGIN
- :new.UPDATE_TIME=CURRENT_TIMESTAMP();
- END;
- -- 字段描述
- COMMENT ON TABLE "SECURE_PRODUCTING"."SP_GRID_INFO" IS '网格信息';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_INFO"."ID" IS '主键';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_INFO"."GRID_NAME" IS '网格名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_INFO"."DEPARTMENT" IS '所属部门';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_INFO"."DEPARTMENT_NAME" IS '部门名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_INFO"."GRID_CATEGORY" IS '网格类型';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_INFO"."DANGER_CATEGORY" IS '隐患分类';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_INFO"."GRID_PERSON_DUTY" IS '网格员职责';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_INFO"."STATUS" IS '状态 EState';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_INFO"."CREATE_TIME" IS '数据创建时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_INFO"."UPDATE_TIME" IS '最后更新时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_INFO"."CREATE_BY" IS '数据创建人';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_INFO"."CREATE_BY_NAME" IS '数据创建人名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_INFO"."UPDATE_BY" IS '最后更新人';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_INFO"."UPDATE_BY_NAME" IS '最后更新人名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_INFO"."IS_DELETE" IS '是否删除(逻辑删除)';
- -- SP_GRID_PERSON - 网格人员
- CREATE TABLE "SECURE_PRODUCTING"."SP_GRID_PERSON"(
- "ID" BIGINT NOT NULL,
- "DEPARTMENT" VARCHAR(500) NOT NULL DEFAULT '',
- "DEPARTMENT_NAME" VARCHAR(1000) NOT NULL DEFAULT '',
- "GRID_ID" BIGINT NOT NULL DEFAULT 0,
- "USER_GUID" VARCHAR(50) NOT NULL DEFAULT '',
- "USER_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "CONTACT_INFO" VARCHAR(50) NOT NULL DEFAULT '',
- "IS_ADMIN" TINYINT NOT NULL DEFAULT 0,
- "STATUS" TINYINT NOT NULL DEFAULT 0,
- "CREATE_TIME" BIGINT NOT NULL DEFAULT 0,
- "UPDATE_TIME" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(),
- "CREATE_BY" VARCHAR(50) NOT NULL DEFAULT '',
- "CREATE_BY_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "UPDATE_BY" VARCHAR(50) NOT NULL DEFAULT '',
- "UPDATE_BY_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "IS_DELETE" TINYINT NOT NULL DEFAULT 0,
- -- 主键
- PRIMARY KEY("ID")
- );
- -- 索引
- CREATE INDEX IDX_SP_GRID_PERSON_DEPARTMENT ON "SECURE_PRODUCTING"."SP_GRID_PERSON"("DEPARTMENT");
- CREATE INDEX IDX_SP_GRID_PERSON_GRID_ID ON "SECURE_PRODUCTING"."SP_GRID_PERSON"("GRID_ID");
- CREATE INDEX IDX_SP_GRID_PERSON_USER_GUID ON "SECURE_PRODUCTING"."SP_GRID_PERSON"("USER_GUID");
- CREATE INDEX IDX_SP_GRID_PERSON_STATUS ON "SECURE_PRODUCTING"."SP_GRID_PERSON"("STATUS");
- CREATE INDEX IDX_SP_GRID_PERSON_CREATE_TIME ON "SECURE_PRODUCTING"."SP_GRID_PERSON"("CREATE_TIME");
- -- 触发器:自动赋值最后修改时间
- CREATE OR REPLACE TRIGGER "TG_SP_GRID_PERSON"
- BEFORE INSERT OR UPDATE ON "SECURE_PRODUCTING"."SP_GRID_PERSON" FOR EACH ROW
- BEGIN
- :new.UPDATE_TIME=CURRENT_TIMESTAMP();
- END;
- -- 字段描述
- COMMENT ON TABLE "SECURE_PRODUCTING"."SP_GRID_PERSON" IS '网格人员';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_PERSON"."ID" IS '主键';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_PERSON"."DEPARTMENT" IS '所属部门';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_PERSON"."DEPARTMENT_NAME" IS '部门名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_PERSON"."GRID_ID" IS '所属网格';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_PERSON"."USER_GUID" IS '用户guid';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_PERSON"."USER_NAME" IS '用户名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_PERSON"."CONTACT_INFO" IS '联系方式';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_PERSON"."IS_ADMIN" IS '是否网格管理员';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_PERSON"."STATUS" IS '状态 EState';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_PERSON"."CREATE_TIME" IS '数据创建时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_PERSON"."UPDATE_TIME" IS '最后更新时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_PERSON"."CREATE_BY" IS '数据创建人';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_PERSON"."CREATE_BY_NAME" IS '数据创建人名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_PERSON"."UPDATE_BY" IS '最后更新人';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_PERSON"."UPDATE_BY_NAME" IS '最后更新人名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_GRID_PERSON"."IS_DELETE" IS '是否删除(逻辑删除)';
- -- SP_DANGER_CHECK_FORM - 隐患检查表
- CREATE TABLE "SECURE_PRODUCTING"."SP_DANGER_CHECK_FORM"(
- "ID" BIGINT NOT NULL,
- "NAME" VARCHAR(200) NOT NULL DEFAULT '',
- "DANGER_CATEGORY" BIGINT NOT NULL DEFAULT 0,
- "CHECK_CYCLE" TINYINT NOT NULL DEFAULT 0,
- "CHECK_TIMES" TINYINT NOT NULL DEFAULT 0,
- "DESCRIPTION" VARCHAR(500) NOT NULL DEFAULT '',
- "STATUS" TINYINT NOT NULL DEFAULT 0,
- "CREATE_TIME" BIGINT NOT NULL DEFAULT 0,
- "UPDATE_TIME" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(),
- "CREATE_BY" VARCHAR(50) NOT NULL DEFAULT '',
- "CREATE_BY_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "UPDATE_BY" VARCHAR(50) NOT NULL DEFAULT '',
- "UPDATE_BY_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "IS_DELETE" TINYINT NOT NULL DEFAULT 0,
- -- 主键
- PRIMARY KEY("ID")
- );
- -- 索引
- CREATE INDEX IDX_SP_DANGER_CHECK_FORM_DANGER_CATEGORY ON "SECURE_PRODUCTING"."SP_DANGER_CHECK_FORM"("DANGER_CATEGORY");
- CREATE INDEX IDX_SP_DANGER_CHECK_FORM_CHECK_CYCLE ON "SECURE_PRODUCTING"."SP_DANGER_CHECK_FORM"("CHECK_CYCLE");
- CREATE INDEX IDX_SP_DANGER_CHECK_FORM_STATUS ON "SECURE_PRODUCTING"."SP_DANGER_CHECK_FORM"("STATUS");
- CREATE INDEX IDX_SP_DANGER_CHECK_FORM_CREATE_TIME ON "SECURE_PRODUCTING"."SP_DANGER_CHECK_FORM"("CREATE_TIME");
- -- 触发器:自动赋值最后修改时间
- CREATE OR REPLACE TRIGGER "TG_SP_DANGER_CHECK_FORM"
- BEFORE INSERT OR UPDATE ON "SECURE_PRODUCTING"."SP_DANGER_CHECK_FORM" FOR EACH ROW
- BEGIN
- :new.UPDATE_TIME=CURRENT_TIMESTAMP();
- END;
- -- 字段描述
- COMMENT ON TABLE "SECURE_PRODUCTING"."SP_DANGER_CHECK_FORM" IS '隐患检查表';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CHECK_FORM"."ID" IS '主键';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CHECK_FORM"."NAME" IS '检查表名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CHECK_FORM"."DANGER_CATEGORY" IS '隐患分类';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CHECK_FORM"."CHECK_CYCLE" IS '检查频率 ECheckCycle';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CHECK_FORM"."CHECK_TIMES" IS '检查次数(周期内)';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CHECK_FORM"."DESCRIPTION" IS '描述';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CHECK_FORM"."STATUS" IS '状态 EState';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CHECK_FORM"."CREATE_TIME" IS '数据创建时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CHECK_FORM"."UPDATE_TIME" IS '最后更新时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CHECK_FORM"."CREATE_BY" IS '数据创建人';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CHECK_FORM"."CREATE_BY_NAME" IS '数据创建人名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CHECK_FORM"."UPDATE_BY" IS '最后更新人';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CHECK_FORM"."UPDATE_BY_NAME" IS '最后更新人名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CHECK_FORM"."IS_DELETE" IS '是否删除(逻辑删除)';
- -- SP_DANGER_CHECK_ITEM - 隐患检查表-检查项
- CREATE TABLE "SECURE_PRODUCTING"."SP_DANGER_CHECK_ITEM"(
- "ID" BIGINT NOT NULL,
- "CHECK_FORM_ID" BIGINT NOT NULL DEFAULT 0,
- "ITEM_NAME" VARCHAR(200) NOT NULL DEFAULT '',
- "DESCRIPTION" VARCHAR(500) NOT NULL DEFAULT '',
- "CREATE_TIME" BIGINT NOT NULL DEFAULT 0,
- "UPDATE_TIME" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(),
- "IS_DELETE" TINYINT NOT NULL DEFAULT 0,
- -- 主键
- PRIMARY KEY("ID")
- );
- -- 索引
- CREATE INDEX IDX_SP_DANGER_CHECK_ITEM_FORM_ID ON "SECURE_PRODUCTING"."SP_DANGER_CHECK_ITEM"("CHECK_FORM_ID");
- CREATE INDEX IDX_SP_DANGER_CHECK_ITEM_CREATE_TIME ON "SECURE_PRODUCTING"."SP_DANGER_CHECK_ITEM"("CREATE_TIME");
- -- 触发器:自动赋值最后修改时间
- CREATE OR REPLACE TRIGGER "TG_SP_DANGER_CHECK_ITEM"
- BEFORE INSERT OR UPDATE ON "SECURE_PRODUCTING"."SP_DANGER_CHECK_ITEM" FOR EACH ROW
- BEGIN
- :new.UPDATE_TIME=CURRENT_TIMESTAMP();
- END;
- -- 字段描述
- COMMENT ON TABLE "SECURE_PRODUCTING"."SP_DANGER_CHECK_ITEM" IS '隐患检查表-检查项';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CHECK_ITEM"."ID" IS '主键';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CHECK_ITEM"."CHECK_FORM_ID" IS '所属隐患检查表';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CHECK_ITEM"."ITEM_NAME" IS '检查项名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CHECK_ITEM"."DESCRIPTION" IS '描述 判断有无隐患的标准等信息';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CHECK_ITEM"."CREATE_TIME" IS '数据创建时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CHECK_ITEM"."UPDATE_TIME" IS '最后更新时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DANGER_CHECK_ITEM"."IS_DELETE" IS '是否删除(逻辑删除)';
- -- SP_CHECK_FORM_GRID_CYCLE - 检查表-网格-频率设置
- CREATE TABLE "SECURE_PRODUCTING"."SP_CHECK_FORM_GRID_CYCLE"(
- "ID" BIGINT NOT NULL,
- "CHECK_FORM_ID" BIGINT NOT NULL DEFAULT 0,
- "CHECK_FORM_NAME" VARCHAR(200) NOT NULL DEFAULT '',
- "GRID_ID" BIGINT NOT NULL DEFAULT 0,
- "GRID_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "CHECK_CYCLE" TINYINT NOT NULL DEFAULT 0,
- "CREATE_TIME" BIGINT NOT NULL DEFAULT 0,
- "UPDATE_TIME" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(),
- "IS_DELETE" TINYINT NOT NULL DEFAULT 0,
- -- 主键
- PRIMARY KEY("ID")
- );
- -- 索引
- CREATE INDEX IDX_SP_CHECK_FORM_GRID_CYCLE_CHECK_FORM_ID ON "SECURE_PRODUCTING"."SP_CHECK_FORM_GRID_CYCLE"("CHECK_FORM_ID");
- CREATE INDEX IDX_SP_CHECK_FORM_GRID_CYCLE_GRID_ID ON "SECURE_PRODUCTING"."SP_CHECK_FORM_GRID_CYCLE"("GRID_ID");
- CREATE INDEX IDX_SP_CHECK_FORM_GRID_CYCLE_CREATE_TIME ON "SECURE_PRODUCTING"."SP_CHECK_FORM_GRID_CYCLE"("CREATE_TIME");
- -- 触发器:自动赋值最后修改时间
- CREATE OR REPLACE TRIGGER "SECURE_PRODUCTING"."TG_SP_CHECK_FORM_GRID_CYCLE"
- BEFORE INSERT OR UPDATE ON "SECURE_PRODUCTING"."SP_CHECK_FORM_GRID_CYCLE" FOR EACH ROW
- BEGIN
- :new.UPDATE_TIME=CURRENT_TIMESTAMP();
- END;
- -- 字段描述
- COMMENT ON TABLE "SECURE_PRODUCTING"."SP_CHECK_FORM_GRID_CYCLE" IS '检查表-网格-频率设置';
- COMMENT ON COLUMN "SECURE_PRODUCTING"."SP_CHECK_FORM_GRID_CYCLE"."ID" IS '主键';
- COMMENT ON COLUMN "SECURE_PRODUCTING"."SP_CHECK_FORM_GRID_CYCLE"."CHECK_FORM_ID" IS '关联检查表';
- COMMENT ON COLUMN "SECURE_PRODUCTING"."SP_CHECK_FORM_GRID_CYCLE"."CHECK_FORM_NAME" IS '检查表名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING"."SP_CHECK_FORM_GRID_CYCLE"."GRID_ID" IS '关联网格';
- COMMENT ON COLUMN "SECURE_PRODUCTING"."SP_CHECK_FORM_GRID_CYCLE"."GRID_NAME" IS '网格名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING"."SP_CHECK_FORM_GRID_CYCLE"."CHECK_CYCLE" IS '检查频率 ECheckCycle';
- COMMENT ON COLUMN "SECURE_PRODUCTING"."SP_CHECK_FORM_GRID_CYCLE"."CREATE_TIME" IS '数据创建时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING"."SP_CHECK_FORM_GRID_CYCLE"."UPDATE_TIME" IS '最后更新时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING"."SP_CHECK_FORM_GRID_CYCLE"."IS_DELETE" IS '是否删除(逻辑删除)';
- -- SP_CHECK_RECORD - 隐患检查记录
- CREATE TABLE "SECURE_PRODUCTING"."SP_CHECK_RECORD"(
- "ID" BIGINT NOT NULL,
- "CHECK_FORM_NO" VARCHAR(50) NOT NULL DEFAULT '',
- "GRID_ID" BIGINT NOT NULL DEFAULT 0,
- "CHECK_FORM_ID" BIGINT NOT NULL DEFAULT 0,
- "CHECK_FORM_NAME" VARCHAR(200) NOT NULL DEFAULT '',
- "DEPARTMENT" VARCHAR(500) NOT NULL DEFAULT '',
- "DEPARTMENT_NAME" VARCHAR(1000) NOT NULL DEFAULT '',
- "CUSTOMS" VARCHAR(50) NOT NULL DEFAULT '',
- "CUSTOMS_NAME" VARCHAR(200) NOT NULL DEFAULT '',
- "CHECK_TIME" BIGINT NOT NULL DEFAULT 0,
- "CHECK_PERSON" VARCHAR(50) NOT NULL DEFAULT '',
- "CHECK_PERSON_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "CONTACT_INFO" VARCHAR(50) NOT NULL DEFAULT '',
- "GRID_CATEGORY" BIGINT NOT NULL DEFAULT 0,
- "DANGER_CATEGORY" BIGINT NOT NULL DEFAULT 0,
- "ATTACHMENT_LIST" VARCHAR(5000) NOT NULL DEFAULT '',
- "HAS_DANGER" TINYINT NOT NULL DEFAULT 0,
- "HAS_RECTIFY_PLAN" TINYINT NOT NULL DEFAULT 0,
- "RECTIFY_SUBMIT_TIME" BIGINT NOT NULL DEFAULT 0,
- "RECTIFY_DEADLINE" BIGINT NOT NULL DEFAULT 0,
- "STATUS" TINYINT NOT NULL DEFAULT 0,
- "REMARK" VARCHAR(500) NOT NULL DEFAULT '',
- "CREATE_TIME" BIGINT NOT NULL DEFAULT 0,
- "UPDATE_TIME" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(),
- "CREATE_BY" VARCHAR(50) NOT NULL DEFAULT '',
- "CREATE_BY_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "UPDATE_BY" VARCHAR(50) NOT NULL DEFAULT '',
- "UPDATE_BY_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "IS_DELETE" TINYINT NOT NULL DEFAULT 0,
- -- 主键
- PRIMARY KEY("ID")
- );
- -- 索引
- CREATE UNIQUE INDEX UID_SP_CHECK_RECORD_CHECK_FORM_NO ON "SECURE_PRODUCTING"."SP_CHECK_RECORD"("CHECK_FORM_NO");
- CREATE INDEX IDX_SP_CHECK_RECORD_CHECK_TIME ON "SECURE_PRODUCTING"."SP_CHECK_RECORD"("CHECK_TIME");
- CREATE INDEX IDX_SP_CHECK_RECORD_STATUS ON "SECURE_PRODUCTING"."SP_CHECK_RECORD"("STATUS");
- CREATE INDEX IDX_SP_CHECK_RECORD_CREATE_TIME ON "SECURE_PRODUCTING"."SP_CHECK_RECORD"("CREATE_TIME");
- -- 触发器:自动赋值最后修改时间
- CREATE OR REPLACE TRIGGER "TG_SP_CHECK_RECORD"
- BEFORE INSERT OR UPDATE ON "SECURE_PRODUCTING"."SP_CHECK_RECORD" FOR EACH ROW
- BEGIN
- :new.UPDATE_TIME=CURRENT_TIMESTAMP();
- END;
- -- 字段描述
- COMMENT ON TABLE "SECURE_PRODUCTING"."SP_CHECK_RECORD" IS '隐患检查记录';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."ID" IS '主键';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."CHECK_FORM_NO" IS '检查单号';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."GRID_ID" IS '所属网格';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."CHECK_FORM_ID" IS '所属检查表';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."CHECK_FORM_NAME" IS '检查表名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."DEPARTMENT" IS '所属部门';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."DEPARTMENT_NAME" IS '部门名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."CUSTOMS" IS '所属关区';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."CUSTOMS_NAME" IS '关区名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."CHECK_TIME" IS '检查时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."CHECK_PERSON" IS '检查人员';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."CHECK_PERSON_NAME" IS '检查人员名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."CONTACT_INFO" IS '联系方式';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."GRID_CATEGORY" IS '网格类型';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."DANGER_CATEGORY" IS '隐患分类';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."ATTACHMENT_LIST" IS '附件列表';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."HAS_DANGER" IS '是否有隐患';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."HAS_RECTIFY_PLAN" IS '是否已提供整改措施';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."RECTIFY_SUBMIT_TIME" IS '整改措施提交时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."RECTIFY_DEADLINE" IS '整改期限';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."STATUS" IS '状态 ECheckFormStatus';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."REMARK" IS '备注';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."CREATE_TIME" IS '数据创建时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."UPDATE_TIME" IS '最后更新时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."CREATE_BY" IS '数据创建人';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."CREATE_BY_NAME" IS '数据创建人名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."UPDATE_BY" IS '最后更新人';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."UPDATE_BY_NAME" IS '最后更新人名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD"."IS_DELETE" IS '是否删除(逻辑删除)';
- -- SP_CHECK_RECORD_ITEM - 隐患检查-检查项
- CREATE TABLE "SECURE_PRODUCTING"."SP_CHECK_RECORD_ITEM"(
- "ID" BIGINT NOT NULL,
- "CHECK_RECORD_ID" BIGINT NOT NULL DEFAULT 0,
- "GRID_ID" BIGINT NOT NULL DEFAULT 0,
- "CHECK_FORM_ID" BIGINT NOT NULL DEFAULT 0,
- "CHECK_FORM_NAME" VARCHAR(200) NOT NULL DEFAULT '',
- "DEPARTMENT" VARCHAR(500) NOT NULL DEFAULT '',
- "DEPARTMENT_NAME" VARCHAR(1000) NOT NULL DEFAULT '',
- "CUSTOMS" VARCHAR(50) NOT NULL DEFAULT '',
- "CUSTOMS_NAME" VARCHAR(200) NOT NULL DEFAULT '',
- "ITEM_NAME" VARCHAR(200) NOT NULL DEFAULT '',
- "CHECK_TIME" BIGINT NOT NULL DEFAULT 0,
- "CHECK_PERSON" VARCHAR(50) NOT NULL DEFAULT '',
- "CHECK_RESULT" TINYINT NOT NULL DEFAULT 0,
- "DANGER_DESCRIPTION" VARCHAR(500) NOT NULL DEFAULT '',
- "RECTIFY_PLAN" VARCHAR(8000) NOT NULL DEFAULT '',
- "RECTIFY_SUBMIT_TIME" BIGINT NOT NULL DEFAULT 0,
- "RECTIFY_DEADLINE" BIGINT NOT NULL DEFAULT 0,
- "RECTIFY_STATUS" TINYINT NOT NULL DEFAULT 0,
- "RECTIFY_TIME" BIGINT NOT NULL DEFAULT 0,
- "IS_ON_TIME" TINYINT NOT NULL DEFAULT 0,
- "RECTIFY_PERSON" VARCHAR(50) NOT NULL DEFAULT '',
- "RECTIFY_PERSON_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "CREATE_TIME" BIGINT NOT NULL DEFAULT 0,
- "UPDATE_TIME" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(),
- "IS_DELETE" TINYINT NOT NULL DEFAULT 0,
- -- 主键
- PRIMARY KEY("ID")
- );
- -- 索引
- CREATE INDEX IDX_SP_CHECK_RECORD_ITEM_CHECK_RECORD_ID ON "SECURE_PRODUCTING"."SP_CHECK_RECORD_ITEM"("CHECK_RECORD_ID");
- CREATE INDEX IDX_SP_CHECK_RECORD_ITEM_CREATE_TIME ON "SECURE_PRODUCTING"."SP_CHECK_RECORD_ITEM"("CREATE_TIME");
- -- 触发器:自动赋值最后修改时间
- CREATE OR REPLACE TRIGGER "TG_SP_CHECK_RECORD_ITEM"
- BEFORE INSERT OR UPDATE ON "SECURE_PRODUCTING"."SP_CHECK_RECORD_ITEM" FOR EACH ROW
- BEGIN
- :new.UPDATE_TIME=CURRENT_TIMESTAMP();
- END;
- -- 字段描述
- COMMENT ON TABLE "SECURE_PRODUCTING"."SP_CHECK_RECORD_ITEM" IS '隐患检查-检查项';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD_ITEM"."ID" IS '主键';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD_ITEM"."CHECK_RECORD_ID" IS '所属检查记录';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD_ITEM"."GRID_ID" IS '所属网格';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD_ITEM"."CHECK_FORM_ID" IS '所属检查表';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD_ITEM"."CHECK_FORM_NAME" IS '检查表名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD_ITEM"."DEPARTMENT" IS '所属部门';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD_ITEM"."DEPARTMENT_NAME" IS '部门名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD_ITEM"."CUSTOMS" IS '所属关区';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD_ITEM"."CUSTOMS_NAME" IS '关区名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD_ITEM"."ITEM_NAME" IS '检查项';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD_ITEM"."CHECK_TIME" IS '检查时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD_ITEM"."CHECK_PERSON" IS '检查人员';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD_ITEM"."CHECK_RESULT" IS '检查结果 ECheckResult';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD_ITEM"."DANGER_DESCRIPTION" IS '隐患描述';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD_ITEM"."RECTIFY_PLAN" IS '整改措施';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD_ITEM"."RECTIFY_SUBMIT_TIME" IS '整改措施提交时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD_ITEM"."RECTIFY_DEADLINE" IS '整改期限';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD_ITEM"."RECTIFY_STATUS" IS '整改状态 ERectifyStatus';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD_ITEM"."RECTIFY_TIME" IS '实际整改完成时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD_ITEM"."IS_ON_TIME" IS '是否准时完成整改';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD_ITEM"."RECTIFY_PERSON" IS '整改执行人';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD_ITEM"."RECTIFY_PERSON_NAME" IS '整改执行人名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD_ITEM"."CREATE_TIME" IS '数据创建时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD_ITEM"."UPDATE_TIME" IS '最后更新时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECORD_ITEM"."IS_DELETE" IS '是否删除(逻辑删除)';
- -- SP_CHECK_RECTIFY_PROGRESS - 隐患整改进度
- CREATE TABLE "SECURE_PRODUCTING"."SP_CHECK_RECTIFY_PROGRESS"(
- "ID" BIGINT NOT NULL,
- "CHECK_RECORD_ID" BIGINT NOT NULL DEFAULT 0,
- "CHECK_ITEM_ID" BIGINT NOT NULL DEFAULT 0,
- "GRID_ID" BIGINT NOT NULL DEFAULT 0,
- "CHECK_FORM_ID" BIGINT NOT NULL DEFAULT 0,
- "CHECK_FORM_NAME" VARCHAR(200) NOT NULL DEFAULT '',
- "ITEM_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "SUBMIT_USER" VARCHAR(50) NOT NULL DEFAULT '',
- "SUBMIT_USER_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "PROGRESS" DECIMAL(18,4) DEFAULT 0 NOT NULL,
- "STATUS" TINYINT NOT NULL DEFAULT 0,
- "CREATE_TIME" BIGINT NOT NULL DEFAULT 0,
- "UPDATE_TIME" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(),
- "IS_DELETE" TINYINT NOT NULL DEFAULT 0,
- -- 主键
- PRIMARY KEY("ID")
- );
- -- 索引
- CREATE INDEX IDX_SP_CHECK_RECTIFY_PROGRESS_CHECK_RECORD_ID ON "SECURE_PRODUCTING"."SP_CHECK_RECTIFY_PROGRESS"("CHECK_RECORD_ID");
- CREATE INDEX IDX_SP_CHECK_RECTIFY_PROGRESS_GRID_ID ON "SECURE_PRODUCTING"."SP_CHECK_RECTIFY_PROGRESS"("GRID_ID");
- CREATE INDEX IDX_SP_CHECK_RECTIFY_PROGRESS_STATUS ON "SECURE_PRODUCTING"."SP_CHECK_RECTIFY_PROGRESS"("STATUS");
- CREATE INDEX IDX_SP_CHECK_RECTIFY_PROGRESS_CREATE_TIME ON "SECURE_PRODUCTING"."SP_CHECK_RECTIFY_PROGRESS"("CREATE_TIME");
- -- 触发器:自动赋值最后修改时间
- CREATE OR REPLACE TRIGGER "TG_SP_CHECK_RECTIFY_PROGRESS"
- BEFORE INSERT OR UPDATE ON "SECURE_PRODUCTING"."SP_CHECK_RECTIFY_PROGRESS" FOR EACH ROW
- BEGIN
- :new.UPDATE_TIME=CURRENT_TIMESTAMP();
- END;
- -- 字段描述
- COMMENT ON TABLE "SECURE_PRODUCTING"."SP_CHECK_RECTIFY_PROGRESS" IS '隐患整改进度';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_PROGRESS"."ID" IS '主键';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_PROGRESS"."CHECK_RECORD_ID" IS '所属检查记录';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_PROGRESS"."CHECK_ITEM_ID" IS '所属检查记录-检查项';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_PROGRESS"."GRID_ID" IS '所属网格';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_PROGRESS"."CHECK_FORM_ID" IS '所属检查表';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_PROGRESS"."CHECK_FORM_NAME" IS '检查表名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_PROGRESS"."ITEM_NAME" IS '检查项';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_PROGRESS"."SUBMIT_USER" IS '进度更新人';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_PROGRESS"."SUBMIT_USER_NAME" IS '进度更新人名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_PROGRESS"."PROGRESS" IS '完成进度';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_PROGRESS"."STATUS" IS '整改状态 ERectifyStatus';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_PROGRESS"."CREATE_TIME" IS '数据创建时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_PROGRESS"."UPDATE_TIME" IS '最后更新时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_PROGRESS"."IS_DELETE" IS '是否删除(逻辑删除)';
- -- SP_CHECK_REVOKE - 隐患检查单撤回申请
- CREATE TABLE "SECURE_PRODUCTING"."SP_CHECK_REVOKE"(
- "ID" BIGINT NOT NULL,
- "CHECK_RECORD_ID" BIGINT NOT NULL DEFAULT 0,
- "GRID_ID" BIGINT NOT NULL DEFAULT 0,
- "CHECK_FORM_ID" BIGINT NOT NULL DEFAULT 0,
- "CHECK_FORM_NAME" VARCHAR(200) NOT NULL DEFAULT '',
- "APPLY_USER" VARCHAR(50) NOT NULL DEFAULT '',
- "APPLY_USER_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "AUDITOR" VARCHAR(50) NOT NULL DEFAULT '',
- "AUDITOR_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "AUDIT_RESULT" TINYINT NOT NULL DEFAULT 0,
- "AUDIT_TIME" BIGINT NOT NULL DEFAULT 0,
- "AUDIT_COMMENT" VARCHAR(500) NOT NULL DEFAULT '',
- "STATUS" TINYINT NOT NULL DEFAULT 0,
- "CREATE_TIME" BIGINT NOT NULL DEFAULT 0,
- "UPDATE_TIME" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(),
- "IS_DELETE" TINYINT NOT NULL DEFAULT 0,
- -- 主键
- PRIMARY KEY("ID")
- );
- -- 索引
- CREATE INDEX IDX_SP_CHECK_REVOKE_CHECK_RECORD_ID ON "SECURE_PRODUCTING"."SP_CHECK_REVOKE"("CHECK_RECORD_ID");
- CREATE INDEX IDX_SP_CHECK_REVOKE_STATUS ON "SECURE_PRODUCTING"."SP_CHECK_REVOKE"("STATUS");
- CREATE INDEX IDX_SP_CHECK_REVOKE_CREATE_TIME ON "SECURE_PRODUCTING"."SP_CHECK_REVOKE"("CREATE_TIME");
- -- 触发器:自动赋值最后修改时间
- CREATE OR REPLACE TRIGGER "TG_SP_CHECK_REVOKE"
- BEFORE INSERT OR UPDATE ON "SECURE_PRODUCTING"."SP_CHECK_REVOKE" FOR EACH ROW
- BEGIN
- :new.UPDATE_TIME=CURRENT_TIMESTAMP();
- END;
- -- 字段描述
- COMMENT ON TABLE "SECURE_PRODUCTING"."SP_CHECK_REVOKE" IS '隐患检查单撤回申请';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_REVOKE"."ID" IS '主键';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_REVOKE"."CHECK_RECORD_ID" IS '所属检查记录';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_REVOKE"."GRID_ID" IS '所属网格';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_REVOKE"."CHECK_FORM_ID" IS '所属隐患检查表';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_REVOKE"."CHECK_FORM_NAME" IS '检查表名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_REVOKE"."APPLY_USER" IS '申请人';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_REVOKE"."APPLY_USER_NAME" IS '申请人名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_REVOKE"."AUDITOR" IS '审核人';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_REVOKE"."AUDITOR_NAME" IS '审核人名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_REVOKE"."AUDIT_RESULT" IS '审核结果';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_REVOKE"."AUDIT_TIME" IS '审核时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_REVOKE"."AUDIT_COMMENT" IS '审核意见';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_REVOKE"."STATUS" IS '状态 EAuditStatus';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_REVOKE"."CREATE_TIME" IS '数据创建时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_REVOKE"."UPDATE_TIME" IS '最后更新时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_REVOKE"."IS_DELETE" IS '是否删除(逻辑删除)';
- -- SP_CHECK_RECTIFY_DELAY - 隐患整改延期申请
- CREATE TABLE "SECURE_PRODUCTING"."SP_CHECK_RECTIFY_DELAY"(
- "ID" BIGINT NOT NULL,
- "CHECK_RECORD_ID" BIGINT NOT NULL DEFAULT 0,
- "CHECK_ITEM_ID" BIGINT NOT NULL DEFAULT 0,
- "GRID_ID" BIGINT NOT NULL DEFAULT 0,
- "CHECK_FORM_ID" BIGINT NOT NULL DEFAULT 0,
- "CHECK_FORM_NAME" VARCHAR(200) NOT NULL DEFAULT '',
- "APPLY_USER" VARCHAR(50) NOT NULL DEFAULT '',
- "APPLY_USER_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "APPLY_DEADLINE" VARCHAR(50) NOT NULL DEFAULT '',
- "AUDITOR" VARCHAR(50) NOT NULL DEFAULT '',
- "AUDITOR_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "AUDIT_RESULT" TINYINT NOT NULL DEFAULT 0,
- "AUDIT_TIME" BIGINT NOT NULL DEFAULT 0,
- "AUDIT_COMMENT" VARCHAR(500) NOT NULL DEFAULT '',
- "STATUS" TINYINT NOT NULL DEFAULT 0,
- "CREATE_TIME" BIGINT NOT NULL DEFAULT 0,
- "UPDATE_TIME" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(),
- "IS_DELETE" TINYINT NOT NULL DEFAULT 0,
- -- 主键
- PRIMARY KEY("ID")
- );
- -- 索引
- CREATE INDEX IDX_SP_CHECK_RECTIFY_DELAY_CHECK_RECORD_ID ON "SECURE_PRODUCTING"."SP_CHECK_RECTIFY_DELAY"("CHECK_RECORD_ID");
- CREATE INDEX IDX_SP_CHECK_RECTIFY_DELAY_STATUS ON "SECURE_PRODUCTING"."SP_CHECK_RECTIFY_DELAY"("STATUS");
- CREATE INDEX IDX_SP_CHECK_RECTIFY_DELAY_CREATE_TIME ON "SECURE_PRODUCTING"."SP_CHECK_RECTIFY_DELAY"("CREATE_TIME");
- -- 触发器:自动赋值最后修改时间
- CREATE OR REPLACE TRIGGER "TG_SP_CHECK_RECTIFY_DELAY"
- BEFORE INSERT OR UPDATE ON "SECURE_PRODUCTING"."SP_CHECK_RECTIFY_DELAY" FOR EACH ROW
- BEGIN
- :new.UPDATE_TIME=CURRENT_TIMESTAMP();
- END;
- -- 字段描述
- COMMENT ON TABLE "SECURE_PRODUCTING"."SP_CHECK_RECTIFY_DELAY" IS '隐患整改延期申请';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_DELAY"."ID" IS '主键';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_DELAY"."CHECK_RECORD_ID" IS '所属检查记录';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_DELAY"."CHECK_ITEM_ID" IS '所属检查记录-检查项';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_DELAY"."GRID_ID" IS '所属网格';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_DELAY"."CHECK_FORM_ID" IS '所属隐患检查表';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_DELAY"."CHECK_FORM_NAME" IS '检查表名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_DELAY"."APPLY_USER" IS '申请人';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_DELAY"."APPLY_USER_NAME" IS '申请人名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_DELAY"."APPLY_DEADLINE" IS '申请整改期限';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_DELAY"."AUDITOR" IS '审核人';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_DELAY"."AUDITOR_NAME" IS '审核人名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_DELAY"."AUDIT_RESULT" IS '审核结果';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_DELAY"."AUDIT_TIME" IS '审核时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_DELAY"."AUDIT_COMMENT" IS '审核意见';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_DELAY"."STATUS" IS '状态 EAuditStatus';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_DELAY"."CREATE_TIME" IS '数据创建时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_DELAY"."UPDATE_TIME" IS '最后更新时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_CHECK_RECTIFY_DELAY"."IS_DELETE" IS '是否删除(逻辑删除)';
- -- SP_DRILL_TASK - 培训任务
- CREATE TABLE "SECURE_PRODUCTING"."SP_DRILL_TASK"(
- "ID" BIGINT NOT NULL,
- "TASK_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "DESCRIPTION" VARCHAR(500) NOT NULL DEFAULT '',
- "DEPARTMENT_COUNT" INT NOT NULL DEFAULT 0,
- "FINISHED_COUNT" INT NOT NULL DEFAULT 0,
- "STATUS" TINYINT NOT NULL DEFAULT 0,
- "CREATE_TIME" BIGINT NOT NULL DEFAULT 0,
- "UPDATE_TIME" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(),
- "CREATE_BY" VARCHAR(50) NOT NULL DEFAULT '',
- "CREATE_BY_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "UPDATE_BY" VARCHAR(50) NOT NULL DEFAULT '',
- "UPDATE_BY_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "IS_DELETE" TINYINT NOT NULL DEFAULT 0,
- -- 主键
- PRIMARY KEY("ID")
- );
- -- 索引
- CREATE INDEX IDX_SP_DRILL_TASK_STATUS ON "SECURE_PRODUCTING"."SP_DRILL_TASK"("STATUS");
- CREATE INDEX IDX_SP_DRILL_TASK_CREATE_TIME ON "SECURE_PRODUCTING"."SP_DRILL_TASK"("CREATE_TIME");
- -- 触发器:自动赋值最后修改时间
- CREATE OR REPLACE TRIGGER "TG_SP_DRILL_TASK"
- BEFORE INSERT OR UPDATE ON "SECURE_PRODUCTING"."SP_DRILL_TASK" FOR EACH ROW
- BEGIN
- :new.UPDATE_TIME=CURRENT_TIMESTAMP();
- END;
- -- 字段描述
- COMMENT ON TABLE "SECURE_PRODUCTING"."SP_DRILL_TASK" IS '培训任务';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DRILL_TASK"."ID" IS '主键';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DRILL_TASK"."TASK_NAME" IS '任务名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DRILL_TASK"."DESCRIPTION" IS '任务描述';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DRILL_TASK"."DEPARTMENT_COUNT" IS '设计部门数量';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DRILL_TASK"."FINISHED_COUNT" IS '已完成部门数量';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DRILL_TASK"."STATUS" IS '状态 ETaskStatus';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DRILL_TASK"."CREATE_TIME" IS '数据创建时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DRILL_TASK"."UPDATE_TIME" IS '最后更新时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DRILL_TASK"."CREATE_BY" IS '数据创建人';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DRILL_TASK"."CREATE_BY_NAME" IS '数据创建人名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DRILL_TASK"."UPDATE_BY" IS '最后更新人';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DRILL_TASK"."UPDATE_BY_NAME" IS '最后更新人名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DRILL_TASK"."IS_DELETE" IS '是否删除(逻辑删除)';
- -- SP_DRILL_TASK_PROGRESS - 培训任务进度
- CREATE TABLE "SECURE_PRODUCTING"."SP_DRILL_TASK_PROGRESS"(
- "ID" BIGINT NOT NULL,
- "TASK_ID" BIGINT NOT NULL DEFAULT 0,
- "DEPARTMENT" VARCHAR(50) NOT NULL DEFAULT '',
- "DEPARTMENT_NAME" VARCHAR(200) NOT NULL DEFAULT '',
- "SUBMIT_USER" VARCHAR(50) NOT NULL DEFAULT '',
- "SUBMIT_USER_NAME" VARCHAR(50) NOT NULL DEFAULT '',
- "FINISHED_TIME" BIGINT NOT NULL DEFAULT 0,
- "STATUS" TINYINT NOT NULL DEFAULT 0,
- "CREATE_TIME" BIGINT NOT NULL DEFAULT 0,
- "UPDATE_TIME" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(),
- "IS_DELETE" TINYINT NOT NULL DEFAULT 0,
- -- 主键
- PRIMARY KEY("ID")
- );
- -- 索引
- CREATE INDEX IDX_SP_DRILL_TASK_PROGRESS_STATUS ON "SECURE_PRODUCTING"."SP_DRILL_TASK_PROGRESS"("STATUS");
- CREATE INDEX IDX_SP_DRILL_TASK_PROGRESS_CREATE_TIME ON "SECURE_PRODUCTING"."SP_DRILL_TASK_PROGRESS"("CREATE_TIME");
- -- 触发器:自动赋值最后修改时间
- CREATE OR REPLACE TRIGGER "TG_SP_DRILL_TASK_PROGRESS"
- BEFORE INSERT OR UPDATE ON "SECURE_PRODUCTING"."SP_DRILL_TASK_PROGRESS" FOR EACH ROW
- BEGIN
- :new.UPDATE_TIME=CURRENT_TIMESTAMP();
- END;
- -- 字段描述
- COMMENT ON TABLE "SECURE_PRODUCTING"."SP_DRILL_TASK_PROGRESS" IS '培训任务进度';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DRILL_TASK_PROGRESS"."ID" IS '主键';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DRILL_TASK_PROGRESS"."TASK_ID" IS '所属培训任务';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DRILL_TASK_PROGRESS"."DEPARTMENT" IS '所属部门';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DRILL_TASK_PROGRESS"."DEPARTMENT_NAME" IS '部门名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DRILL_TASK_PROGRESS"."SUBMIT_USER" IS '进度更新人';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DRILL_TASK_PROGRESS"."SUBMIT_USER_NAME" IS '进度更新人名称';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DRILL_TASK_PROGRESS"."FINISHED_TIME" IS '完成时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DRILL_TASK_PROGRESS"."STATUS" IS '状态 ETaskStatus';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DRILL_TASK_PROGRESS"."CREATE_TIME" IS '数据创建时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DRILL_TASK_PROGRESS"."UPDATE_TIME" IS '最后更新时间';
- COMMENT ON COLUMN "SECURE_PRODUCTING". "SP_DRILL_TASK_PROGRESS"."IS_DELETE" IS '是否删除(逻辑删除)';
|