 DROP TABLE IF EXISTS parameters_admin;

CREATE TABLE public.parameters_admin
(   
   key character varying (100) NOT NULL,
   value text NOT NULL,
   id_user integer NULL,
   date_modified timestamp without time zone NULL,
   display boolean DEFAULT true,
   CONSTRAINT pk_parameters_admin_key PRIMARY KEY (key),
	constraint fkey_user_sonata_key
     foreign key (id_user) 
     REFERENCES user_sonata (id)
)
WITH (
   OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.parameters_admin
   OWNER to postgres;

COMMENT ON TABLE public.parameters_admin
    IS 'Parámetros administrables de la aplicación. ';
