﻿-- T_BUSI_INSURE_EVA 应急预案安全生产评价（安责险）
CREATE TABLE t_busi_insure_eva (
    guid            VARCHAR(32)   PRIMARY KEY,
    org_guid        VARCHAR(32)   NOT NULL,
    create_time     TIMESTAMP     DEFAULT CURRENT_TIMESTAMP,
    start_date      VARCHAR(20),
    end_date        VARCHAR(20),
    eng_total       INTEGER       DEFAULT 0,
    is_insure       INTEGER       DEFAULT 0,
    not_insure      INTEGER       DEFAULT 0,
    tend_total      INTEGER       DEFAULT 0,
    tend_is_insure  INTEGER       DEFAULT 0,
    tend_not_insure INTEGER       DEFAULT 0,
    bxl             NUMERIC(8,2)  DEFAULT 0,
    nbxl            NUMERIC(8,2)  DEFAULT 0,
    bx_fx           NUMERIC(8,2)  DEFAULT 0,
    date_type       VARCHAR(1),
    date_year       VARCHAR(4),
    date_quarter    VARCHAR(1)
);

COMMENT ON TABLE  t_busi_insure_eva           IS '安责险安全生产评价';
COMMENT ON COLUMN t_busi_insure_eva.guid      IS '主键';
COMMENT ON COLUMN t_busi_insure_eva.org_guid  IS '所属机构';
COMMENT ON COLUMN t_busi_insure_eva.eng_total IS '工程数量';
COMMENT ON COLUMN t_busi_insure_eva.is_insure IS '工程安责险数量';
COMMENT ON COLUMN t_busi_insure_eva.bxl       IS '标段保险率';
COMMENT ON COLUMN t_busi_insure_eva.date_year IS '日期年份';
COMMENT ON COLUMN t_busi_insure_eva.date_quarter IS '日期季度';
COMMENT ON COLUMN t_busi_insure_eva.date_type IS '日期类型';

CREATE INDEX idx_busi_insure_eva_org ON t_busi_insure_eva(org_guid);
