RUIAN_OA/sql/z_report.sql

--
-- Kingbase database dump
--

-- Dumped from database version 12.1
-- Dumped by sys_dump version 12.1

-- Started on 2024-10-23 14:27:20

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'GBK';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', 'public', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
SET default_with_oids = off;
SET default_with_rowid = off;

--
-- TOC entry 45 (class 2615 OID 21511)
-- Name: z_report; Type: SCHEMA; Schema: -; Owner: system
--

CREATE SCHEMA z_report;


ALTER SCHEMA z_report OWNER TO system;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- TOC entry 1083 (class 1259 OID 21512)
-- Name: report; Type: TABLE; Schema: z_report; Owner: sysdba
--

SET escape = off;
CREATE TABLE z_report.report (
    id varcharbyte NOT NULL,
    index_code numeric,
    create_worker varcharbyte,
    create_time timestamp(6) without time zone,
    latest_modify_worker varcharbyte,
    latest_modify_time timestamp(6) without time zone,
    isvalid numeric,
    bz1 varcharbyte,
    bz2 varcharbyte,
    bz3 varcharbyte,
    bz4 varcharbyte,
    name varcharbyte,
    bz varcharbyte,
    report_catalog_id varcharbyte,
    datasource_url varcharbyte,
    report_mark varcharbyte,
    i_enable_save_word_btn integer,
    i_enable_save_excel_btn integer
);


ALTER TABLE z_report.report OWNER TO sysdba;

--
-- TOC entry 6728 (class 0 OID 0)
-- Dependencies: 1083
-- Name: COLUMN report.i_enable_save_word_btn; Type: COMMENT; Schema: z_report; Owner: sysdba
--

COMMENT ON COLUMN z_report.report.i_enable_save_word_btn IS '是否启用保存报表为Word按钮';


--
-- TOC entry 6729 (class 0 OID 0)
-- Dependencies: 1083
-- Name: COLUMN report.i_enable_save_excel_btn; Type: COMMENT; Schema: z_report; Owner: sysdba
--

COMMENT ON COLUMN z_report.report.i_enable_save_excel_btn IS '是否启用保存报表为Excel按钮';


--
-- TOC entry 1084 (class 1259 OID 21520)
-- Name: report_catalog; Type: TABLE; Schema: z_report; Owner: sysdba
--

SET escape = off;
CREATE TABLE z_report.report_catalog (
    id varcharbyte NOT NULL,
    index_code numeric,
    create_worker varcharbyte,
    create_time timestamp(6) without time zone,
    latest_modify_worker varcharbyte,
    latest_modify_time timestamp(6) without time zone,
    isvalid numeric,
    bz1 varcharbyte,
    bz2 varcharbyte,
    bz3 varcharbyte,
    bz4 varcharbyte,
    parent_id varcharbyte,
    name varcharbyte
);


ALTER TABLE z_report.report_catalog OWNER TO sysdba;

--
-- TOC entry 1085 (class 1259 OID 21528)
-- Name: report_content; Type: TABLE; Schema: z_report; Owner: sysdba
--

SET escape = off;
CREATE TABLE z_report.report_content (
    id varcharbyte NOT NULL,
    index_code numeric,
    create_worker varcharbyte,
    create_time timestamp(6) without time zone,
    latest_modify_worker varcharbyte,
    latest_modify_time timestamp(6) without time zone,
    isvalid numeric,
    bz1 varcharbyte,
    bz2 varcharbyte,
    bz3 varcharbyte,
    bz4 varcharbyte,
    content blob,
    report_id varcharbyte
);


ALTER TABLE z_report.report_content OWNER TO sysdba;

--
-- TOC entry 1086 (class 1259 OID 21887)
-- Name: report_data_connection; Type: TABLE; Schema: z_report; Owner: sysdba
--

SET escape = off;
CREATE TABLE z_report.report_data_connection (
    id varcharbyte NOT NULL,
    index_code numeric,
    create_worker varcharbyte,
    create_time timestamp(6) without time zone,
    latest_modify_worker varcharbyte,
    latest_modify_time timestamp(6) without time zone,
    isvalid numeric,
    bz1 varcharbyte,
    bz2 varcharbyte,
    bz3 varcharbyte,
    bz4 varcharbyte,
    name varcharbyte,
    connection_driver varcharbyte,
    connection_url varcharbyte,
    connection_username varcharbyte,
    connection_password varcharbyte,
    connection_identity varcharbyte
);


ALTER TABLE z_report.report_data_connection OWNER TO sysdba;

--
-- TOC entry 1087 (class 1259 OID 21895)
-- Name: report_datasource; Type: TABLE; Schema: z_report; Owner: sysdba
--

SET escape = off;
CREATE TABLE z_report.report_datasource (
    id varcharbyte NOT NULL,
    index_code numeric,
    create_worker varcharbyte,
    create_time timestamp(6) without time zone,
    latest_modify_worker varcharbyte,
    latest_modify_time timestamp(6) without time zone,
    isvalid numeric,
    bz1 varcharbyte,
    bz2 varcharbyte,
    bz3 varcharbyte,
    bz4 varcharbyte,
    sql blob,
    report_id varcharbyte,
    name varcharbyte,
    report_data_connection_id varcharbyte
);


ALTER TABLE z_report.report_datasource OWNER TO sysdba;

--
-- TOC entry 6717 (class 0 OID 21512)
-- Dependencies: 1083
-- Data for Name: report; Type: TABLE DATA; Schema: z_report; Owner: sysdba
--



--
-- TOC entry 6718 (class 0 OID 21520)
-- Dependencies: 1084
-- Data for Name: report_catalog; Type: TABLE DATA; Schema: z_report; Owner: sysdba
--



--
-- TOC entry 6719 (class 0 OID 21528)
-- Dependencies: 1085
-- Data for Name: report_content; Type: TABLE DATA; Schema: z_report; Owner: sysdba
--



--
-- TOC entry 6720 (class 0 OID 21887)
-- Dependencies: 1086
-- Data for Name: report_data_connection; Type: TABLE DATA; Schema: z_report; Owner: sysdba
--



--
-- TOC entry 6721 (class 0 OID 21895)
-- Dependencies: 1087
-- Data for Name: report_datasource; Type: TABLE DATA; Schema: z_report; Owner: sysdba
--



--
-- TOC entry 6176 (class 2606 OID 21527)
-- Name: report_catalog report_catalog_pkey; Type: CONSTRAINT; Schema: z_report; Owner: sysdba
--

ALTER TABLE ONLY z_report.report_catalog
    ADD CONSTRAINT report_catalog_pkey PRIMARY KEY (id);


--
-- TOC entry 6178 (class 2606 OID 21535)
-- Name: report_content report_content_pkey; Type: CONSTRAINT; Schema: z_report; Owner: sysdba
--

ALTER TABLE ONLY z_report.report_content
    ADD CONSTRAINT report_content_pkey PRIMARY KEY (id);


--
-- TOC entry 6180 (class 2606 OID 21894)
-- Name: report_data_connection report_data_connection_pkey; Type: CONSTRAINT; Schema: z_report; Owner: sysdba
--

ALTER TABLE ONLY z_report.report_data_connection
    ADD CONSTRAINT report_data_connection_pkey PRIMARY KEY (id);


--
-- TOC entry 6182 (class 2606 OID 21902)
-- Name: report_datasource report_datasource_pkey; Type: CONSTRAINT; Schema: z_report; Owner: sysdba
--

ALTER TABLE ONLY z_report.report_datasource
    ADD CONSTRAINT report_datasource_pkey PRIMARY KEY (id);


--
-- TOC entry 6174 (class 2606 OID 21519)
-- Name: report report_pkey; Type: CONSTRAINT; Schema: z_report; Owner: sysdba
--

ALTER TABLE ONLY z_report.report
    ADD CONSTRAINT report_pkey PRIMARY KEY (id);


--
-- TOC entry 6727 (class 0 OID 0)
-- Dependencies: 45
-- Name: SCHEMA z_report; Type: ACL; Schema: -; Owner: system
--

GRANT ALL ON SCHEMA z_report TO z_report;


-- Completed on 2024-10-23 14:27:21

--
-- Kingbase database dump complete
--