-- Table: public.db_sys_dashboards

-- DROP TABLE public.db_sys_dashboards;

CREATE TABLE public.db_sys_dashboards
(
    id_dash integer NOT NULL DEFAULT nextval('db_sys_dashboards_id_dash_seq'::regclass),
    id_projet bigint,
    nom_dash character varying COLLATE pg_catalog."default",
    desc_dash text COLLATE pg_catalog."default",
    visibilite_dash boolean DEFAULT true,
    date_creation timestamp without time zone,
    CONSTRAINT db_sys_dashboards_pkey PRIMARY KEY (id_dash)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.db_sys_dashboards
    OWNER to postgres;


-- Table: public.db_sys_charts

-- DROP TABLE public.db_sys_charts;

CREATE TABLE public.db_sys_charts
(
    id_chart integer NOT NULL DEFAULT nextval('db_sys_charts_id_chart_seq'::regclass),
    id_projet bigint NOT NULL,
    id_dashboard bigint NOT NULL,
    sql character varying COLLATE pg_catalog."default" NOT NULL,
    typechart character varying COLLATE pg_catalog."default" NOT NULL,
    width integer NOT NULL DEFAULT 0,
    height integer NOT NULL DEFAULT 0,
    tablename character varying COLLATE pg_catalog."default",
    colvalue character varying COLLATE pg_catalog."default",
    colitem character varying COLLATE pg_catalog."default",
    colaxex character varying COLLATE pg_catalog."default",
    colaxey character varying COLLATE pg_catalog."default",
    date_creation timestamp without time zone,
    date_modification timestamp without time zone,
    titre character varying COLLATE pg_catalog."default",
    titre_px integer,
    titre_py integer,
    soustitre character varying COLLATE pg_catalog."default",
    soustitre_px integer,
    soustitre_py integer,
    aspect character varying COLLATE pg_catalog."default",
    label_x character varying COLLATE pg_catalog."default",
    label_y character varying COLLATE pg_catalog."default",
    "offset" character varying COLLATE pg_catalog."default",
    legende_visible boolean,
    legende_type character varying COLLATE pg_catalog."default",
    legende_nbr_rows integer NOT NULL DEFAULT 0,
    legende_nbr_cols integer NOT NULL DEFAULT 0,
    chartname character varying(200) COLLATE pg_catalog."default",
    CONSTRAINT db_sys_charts_pkey PRIMARY KEY (id_chart)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.db_sys_charts
    OWNER to postgres;