-- Name: xdat_field_mapping_set_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_field_mapping_set_history (
    method character varying(255),
    change_user integer,
    previous_change_date timestamp without time zone,
    field_mapping_set_info integer,
    history_id integer NOT NULL,
    xdat_field_mapping_set_id integer,
    permissions_allow_set_xdat_elem_xdat_element_access_id integer,
    xft_version integer,
    change_date timestamp without time zone,
    new_row_xdat_field_mapping_set_id integer
);


ALTER TABLE public.xdat_field_mapping_set_history OWNER TO xnat;

--
-- Name: xdat_field_mapping_set_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_field_mapping_set_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_field_mapping_set_history_history_id_seq OWNER TO xnat;

--
-- Name: xdat_field_mapping_set_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_field_mapping_set_history_history_id_seq OWNED BY public.xdat_field_mapping_set_history.history_id;


--
-- Name: xdat_field_mapping_set_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_field_mapping_set_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xdat_field_mapping_set_meta_data OWNER TO xnat;

--
-- Name: xdat_field_mapping_set_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_field_mapping_set_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_field_mapping_set_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xdat_field_mapping_set_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_field_mapping_set_meta_data_meta_data_id_seq OWNED BY public.xdat_field_mapping_set_meta_data.meta_data_id;


--
-- Name: xdat_field_mapping_set_xdat_field_mapping_set_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_field_mapping_set_xdat_field_mapping_set_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_field_mapping_set_xdat_field_mapping_set_id_seq OWNER TO xnat;

--
-- Name: xdat_field_mapping_set_xdat_field_mapping_set_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_field_mapping_set_xdat_field_mapping_set_id_seq OWNED BY public.xdat_field_mapping_set.xdat_field_mapping_set_id;


--
-- Name: xdat_field_mapping_xdat_field_mapping_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_field_mapping_xdat_field_mapping_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_field_mapping_xdat_field_mapping_id_seq OWNER TO xnat;

--
-- Name: xdat_field_mapping_xdat_field_mapping_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_field_mapping_xdat_field_mapping_id_seq OWNED BY public.xdat_field_mapping.xdat_field_mapping_id;


--
-- Name: xdat_infoentry_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_infoentry_history (
    change_user integer,
    date timestamp without time zone,
    xdat_infoentry_id integer,
    previous_change_date timestamp without time zone,
    infoentry_info integer,
    history_id integer NOT NULL,
    link character varying(255),
    title character varying(255),
    description text,
    xft_version integer,
    change_date timestamp without time zone,
    new_row_xdat_infoentry_id integer
);


ALTER TABLE public.xdat_infoentry_history OWNER TO xnat;

--
-- Name: xdat_infoentry_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_infoentry_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_infoentry_history_history_id_seq OWNER TO xnat;

--
-- Name: xdat_infoentry_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_infoentry_history_history_id_seq OWNED BY public.xdat_infoentry_history.history_id;


--
-- Name: xdat_infoentry_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_infoentry_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_infoentry_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xdat_infoentry_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_infoentry_meta_data_meta_data_id_seq OWNED BY public.xdat_infoentry_meta_data.meta_data_id;


--
-- Name: xdat_infoentry_xdat_infoentry_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_infoentry_xdat_infoentry_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_infoentry_xdat_infoentry_id_seq OWNER TO xnat;

--
-- Name: xdat_infoentry_xdat_infoentry_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_infoentry_xdat_infoentry_id_seq OWNED BY public.xdat_infoentry.xdat_infoentry_id;


--
-- Name: xdat_meta_element_xdat_meta_element_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_meta_element_xdat_meta_element_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_meta_element_xdat_meta_element_id_seq OWNER TO xnat;

--
-- Name: xdat_meta_element_xdat_meta_element_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_meta_element_xdat_meta_element_id_seq OWNED BY public.xdat_meta_element.xdat_meta_element_id;


--
-- Name: xdat_newsentry_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_newsentry_history (
    change_user integer,
    date timestamp without time zone,
    previous_change_date timestamp without time zone,
    newsentry_info integer,
    history_id integer NOT NULL,
    link character varying(255),
    title character varying(255),
    xdat_newsentry_id integer,
    description text,
    xft_version integer,
    change_date timestamp without time zone,
    new_row_xdat_newsentry_id integer
);


ALTER TABLE public.xdat_newsentry_history OWNER TO xnat;

--
-- Name: xdat_newsentry_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_newsentry_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_newsentry_history_history_id_seq OWNER TO xnat;

--
-- Name: xdat_newsentry_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_newsentry_history_history_id_seq OWNED BY public.xdat_newsentry_history.history_id;


--
-- Name: xdat_newsentry_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_newsentry_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_newsentry_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xdat_newsentry_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_newsentry_meta_data_meta_data_id_seq OWNED BY public.xdat_newsentry_meta_data.meta_data_id;


--
-- Name: xdat_newsentry_xdat_newsentry_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_newsentry_xdat_newsentry_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_newsentry_xdat_newsentry_id_seq OWNER TO xnat;

--
-- Name: xdat_newsentry_xdat_newsentry_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_newsentry_xdat_newsentry_id_seq OWNED BY public.xdat_newsentry.xdat_newsentry_id;


--
-- Name: xdat_primary_security_field_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_primary_security_field_history (
    change_user integer,
    primary_security_field_info integer,
    primary_security_field character varying(255),
    xdat_primary_security_field_id integer,
    previous_change_date timestamp without time zone,
    primary_security_fields_primary_element_name character varying(255),
    history_id integer NOT NULL,
    xft_version integer,
    change_date timestamp without time zone,
    new_row_xdat_primary_security_field_id integer
);


ALTER TABLE public.xdat_primary_security_field_history OWNER TO xnat;

--
-- Name: xdat_primary_security_field_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_primary_security_field_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_primary_security_field_history_history_id_seq OWNER TO xnat;

--
-- Name: xdat_primary_security_field_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_primary_security_field_history_history_id_seq OWNED BY public.xdat_primary_security_field_history.history_id;


--
-- Name: xdat_primary_security_field_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_primary_security_field_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xdat_primary_security_field_meta_data OWNER TO xnat;

--
-- Name: xdat_primary_security_field_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_primary_security_field_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_primary_security_field_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xdat_primary_security_field_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_primary_security_field_meta_data_meta_data_id_seq OWNED BY public.xdat_primary_security_field_meta_data.meta_data_id;


--
-- Name: xdat_primary_security_field_xdat_primary_security_field_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_primary_security_field_xdat_primary_security_field_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_primary_security_field_xdat_primary_security_field_id_seq OWNER TO xnat;

--
-- Name: xdat_primary_security_field_xdat_primary_security_field_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_primary_security_field_xdat_primary_security_field_id_seq OWNED BY public.xdat_primary_security_field.xdat_primary_security_field_id;



--
-- Name: xdat_r_xdat_role_type_assign_xdat_user; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_r_xdat_role_type_assign_xdat_user (
    xdat_user_xdat_user_id integer NOT NULL,
    xdat_role_type_role_name character varying NOT NULL,
    xdat_r_xdat_role_type_assign_xdat_user_id integer NOT NULL
);


ALTER TABLE public.xdat_r_xdat_role_type_assign_xdat_user OWNER TO xnat;

--
-- Name: xdat_r_xdat_role_type_assign__xdat_r_xdat_role_type_assign__seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_r_xdat_role_type_assign__xdat_r_xdat_role_type_assign__seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_r_xdat_role_type_assign__xdat_r_xdat_role_type_assign__seq OWNER TO xnat;

--
-- Name: xdat_r_xdat_role_type_assign__xdat_r_xdat_role_type_assign__seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_r_xdat_role_type_assign__xdat_r_xdat_role_type_assign__seq OWNED BY public.xdat_r_xdat_role_type_assign_xdat_user.xdat_r_xdat_role_type_assign_xdat_user_id;



--
-- Name: xdat_r_xdat_role_type_assign_xdat_user_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_r_xdat_role_type_assign_xdat_user_history (
    xdat_user_xdat_user_id integer,
    xdat_role_type_role_name character varying,
    xdat_r_xdat_role_type_assign_xdat_user_id integer,
    history_id integer NOT NULL
);


ALTER TABLE public.xdat_r_xdat_role_type_assign_xdat_user_history OWNER TO xnat;

--
-- Name: xdat_r_xdat_role_type_assign_xdat_user_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_r_xdat_role_type_assign_xdat_user_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_r_xdat_role_type_assign_xdat_user_history_history_id_seq OWNER TO xnat;

--
-- Name: xdat_r_xdat_role_type_assign_xdat_user_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_r_xdat_role_type_assign_xdat_user_history_history_id_seq OWNED BY public.xdat_r_xdat_role_type_assign_xdat_user_history.history_id;


--
-- Name: xdat_role_type_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_role_type_history (
    change_user integer,
    sequence integer,
    previous_change_date timestamp without time zone,
    roles_role_xdat_security_xdat_security_id integer,
    role_type_info integer,
    history_id integer NOT NULL,
    description character varying(255),
    role_name character varying(255),
    xft_version integer,
    change_date timestamp without time zone,
    new_row_role_name character varying(255)
);


ALTER TABLE public.xdat_role_type_history OWNER TO xnat;

--
-- Name: xdat_role_type_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_role_type_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_role_type_history_history_id_seq OWNER TO xnat;

--
-- Name: xdat_role_type_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_role_type_history_history_id_seq OWNED BY public.xdat_role_type_history.history_id;


--
-- Name: xdat_role_type_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_role_type_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_role_type_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xdat_role_type_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_role_type_meta_data_meta_data_id_seq OWNED BY public.xdat_role_type_meta_data.meta_data_id;


--
-- Name: xdat_search; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_search (
    id character varying(255) DEFAULT ''::character varying NOT NULL,
    page integer,
    search_info integer
);


ALTER TABLE public.xdat_search OWNER TO xnat;

--
-- Name: xdat_search_field; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_search_field (
    element_name character varying(255),
    field_id character varying(255),
    sequence integer DEFAULT 0 NOT NULL,
    type character varying(255),
    header character varying(255),
    value character varying(255),
    visible integer,
    search_field_info integer,
    xdat_search_field_id integer NOT NULL,
    xdat_stored_search_id character varying(255)
);


ALTER TABLE public.xdat_search_field OWNER TO xnat;

--
-- Name: xdat_search_field_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_search_field_history (
    xdat_stored_search_id character varying(255),
    change_user integer,
    search_field_info integer,
    visible integer,
    sequence integer,
    previous_change_date timestamp without time zone,
    header character varying(255),
    xdat_search_field_id integer,
    type character varying(255),
    element_name character varying(255),
    history_id integer NOT NULL,
    value character varying(255),
    field_id character varying(255),
    xft_version integer,
    change_date timestamp without time zone,
    new_row_xdat_search_field_id integer
);


ALTER TABLE public.xdat_search_field_history OWNER TO xnat;

--
-- Name: xdat_search_field_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_search_field_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_search_field_history_history_id_seq OWNER TO xnat;

--
-- Name: xdat_search_field_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_search_field_history_history_id_seq OWNED BY public.xdat_search_field_history.history_id;


--
-- Name: xdat_search_field_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_search_field_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xdat_search_field_meta_data OWNER TO xnat;

--
-- Name: xdat_search_field_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_search_field_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_search_field_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xdat_search_field_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_search_field_meta_data_meta_data_id_seq OWNED BY public.xdat_search_field_meta_data.meta_data_id;


--
-- Name: xdat_search_field_xdat_search_field_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_search_field_xdat_search_field_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_search_field_xdat_search_field_id_seq OWNER TO xnat;

--
-- Name: xdat_search_field_xdat_search_field_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_search_field_xdat_search_field_id_seq OWNED BY public.xdat_search_field.xdat_search_field_id;


--
-- Name: xdat_search_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_search_history (
    change_user integer,
    id character varying(255),
    previous_change_date timestamp without time zone,
    page integer,
    history_id integer NOT NULL,
    search_info integer,
    xft_version integer,
    change_date timestamp without time zone,
    new_row_id character varying(255)
);


ALTER TABLE public.xdat_search_history OWNER TO xnat;

--
-- Name: xdat_search_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_search_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_search_history_history_id_seq OWNER TO xnat;

--
-- Name: xdat_search_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_search_history_history_id_seq OWNED BY public.xdat_search_history.history_id;


--
-- Name: xdat_search_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_search_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xdat_search_meta_data OWNER TO xnat;

--
-- Name: xdat_search_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_search_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_search_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xdat_search_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_search_meta_data_meta_data_id_seq OWNED BY public.xdat_search_meta_data.meta_data_id;



--
-- Name: xdat_searches; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_searches (
    search_name character varying(255) NOT NULL,
    last_access timestamp without time zone DEFAULT now(),
    created timestamp without time zone DEFAULT now(),
    owner character varying(255)
);


ALTER TABLE public.xdat_searches OWNER TO xnat;


--
-- Name: xdat_security; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_security (
    newslist_news_xdat_newsentry_id integer,
    infolist_info_xdat_infoentry_id integer,
    system character varying(255) DEFAULT ''::character varying NOT NULL,
    require_login integer DEFAULT 0 NOT NULL,
    security_info integer,
    xdat_security_id integer NOT NULL
);


ALTER TABLE public.xdat_security OWNER TO xnat;

--
-- Name: xdat_security_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_security_history (
    system character varying(255),
    change_user integer,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    xdat_security_id integer,
    infolist_info_xdat_infoentry_id integer,
    newslist_news_xdat_newsentry_id integer,
    security_info integer,
    xft_version integer,
    change_date timestamp without time zone,
    require_login integer,
    new_row_xdat_security_id integer
);


ALTER TABLE public.xdat_security_history OWNER TO xnat;

--
-- Name: xdat_security_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_security_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_security_history_history_id_seq OWNER TO xnat;

--
-- Name: xdat_security_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_security_history_history_id_seq OWNED BY public.xdat_security_history.history_id;


--
-- Name: xdat_security_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_security_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xdat_security_meta_data OWNER TO xnat;

--
-- Name: xdat_security_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_security_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_security_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xdat_security_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_security_meta_data_meta_data_id_seq OWNED BY public.xdat_security_meta_data.meta_data_id;


--
-- Name: xdat_security_xdat_security_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_security_xdat_security_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_security_xdat_security_id_seq OWNER TO xnat;

--
-- Name: xdat_security_xdat_security_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_security_xdat_security_id_seq OWNED BY public.xdat_security.xdat_security_id;


--
-- Name: xdat_stored_search_allowed_user; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_stored_search_allowed_user (
    login character varying(255),
    stored_search_allowed_user_info integer,
    xdat_stored_search_allowed_user_id integer NOT NULL,
    xdat_stored_search_id character varying(255)
);


ALTER TABLE public.xdat_stored_search_allowed_user OWNER TO xnat;

--
-- Name: xdat_stored_search_allowed_us_xdat_stored_search_allowed_us_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_stored_search_allowed_us_xdat_stored_search_allowed_us_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_stored_search_allowed_us_xdat_stored_search_allowed_us_seq OWNER TO xnat;

--
-- Name: xdat_stored_search_allowed_us_xdat_stored_search_allowed_us_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_stored_search_allowed_us_xdat_stored_search_allowed_us_seq OWNED BY public.xdat_stored_search_allowed_user.xdat_stored_search_allowed_user_id;


--
-- Name: xdat_stored_search_allowed_user_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_stored_search_allowed_user_history (
    xdat_stored_search_id character varying(255),
    change_user integer,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    login character varying(255),
    xft_version integer,
    change_date timestamp without time zone,
    stored_search_allowed_user_info integer,
    xdat_stored_search_allowed_user_id integer,
    new_row_xdat_stored_search_allowed_user_id integer
);


ALTER TABLE public.xdat_stored_search_allowed_user_history OWNER TO xnat;

--
-- Name: xdat_stored_search_allowed_user_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_stored_search_allowed_user_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_stored_search_allowed_user_history_history_id_seq OWNER TO xnat;

--
-- Name: xdat_stored_search_allowed_user_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_stored_search_allowed_user_history_history_id_seq OWNED BY public.xdat_stored_search_allowed_user_history.history_id;


--
-- Name: xdat_stored_search_allowed_user_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_stored_search_allowed_user_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xdat_stored_search_allowed_user_meta_data OWNER TO xnat;

--
-- Name: xdat_stored_search_allowed_user_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_stored_search_allowed_user_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_stored_search_allowed_user_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xdat_stored_search_allowed_user_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_stored_search_allowed_user_meta_data_meta_data_id_seq OWNED BY public.xdat_stored_search_allowed_user_meta_data.meta_data_id;


--
-- Name: xdat_stored_search_groupid; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_stored_search_groupid (
    groupid character varying(255),
    stored_search_groupid_info integer,
    xdat_stored_search_groupid_id integer NOT NULL,
    allowed_groups_groupid_xdat_sto_id character varying(255)
);


ALTER TABLE public.xdat_stored_search_groupid OWNER TO xnat;

--
-- Name: xdat_stored_search_groupid_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_stored_search_groupid_history (
    stored_search_groupid_info integer,
    xdat_stored_search_groupid_id integer,
    change_user integer,
    allowed_groups_groupid_xdat_sto_id character varying(255),
    groupid character varying(255),
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    xft_version integer,
    change_date timestamp without time zone,
    new_row_xdat_stored_search_groupid_id integer
);


ALTER TABLE public.xdat_stored_search_groupid_history OWNER TO xnat;

--
-- Name: xdat_stored_search_groupid_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_stored_search_groupid_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_stored_search_groupid_history_history_id_seq OWNER TO xnat;

--
-- Name: xdat_stored_search_groupid_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_stored_search_groupid_history_history_id_seq OWNED BY public.xdat_stored_search_groupid_history.history_id;


--
-- Name: xdat_stored_search_groupid_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_stored_search_groupid_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xdat_stored_search_groupid_meta_data OWNER TO xnat;

--
-- Name: xdat_stored_search_groupid_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_stored_search_groupid_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_stored_search_groupid_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xdat_stored_search_groupid_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_stored_search_groupid_meta_data_meta_data_id_seq OWNED BY public.xdat_stored_search_groupid_meta_data.meta_data_id;


--
-- Name: xdat_stored_search_groupid_xdat_stored_search_groupid_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_stored_search_groupid_xdat_stored_search_groupid_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_stored_search_groupid_xdat_stored_search_groupid_id_seq OWNER TO xnat;

--
-- Name: xdat_stored_search_groupid_xdat_stored_search_groupid_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_stored_search_groupid_xdat_stored_search_groupid_id_seq OWNED BY public.xdat_stored_search_groupid.xdat_stored_search_groupid_id;


--
-- Name: xdat_stored_search_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_stored_search_history (
    change_date timestamp without time zone,
    allow_diff_columns integer,
    sort_by_element_name character varying(255),
    change_user integer,
    xft_version integer,
    secure integer,
    id character varying(255),
    history_id integer NOT NULL,
    sort_by_field_id character varying(255),
    stored_search_info integer,
    description character varying(255),
    previous_change_date timestamp without time zone,
    brief_description character varying(255),
    root_element_name character varying(255),
    tag character varying(255),
    layeredsequence character varying(255),
    extension integer,
    new_row_id character varying(255)
);


ALTER TABLE public.xdat_stored_search_history OWNER TO xnat;

--
-- Name: xdat_stored_search_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_stored_search_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_stored_search_history_history_id_seq OWNER TO xnat;

--
-- Name: xdat_stored_search_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_stored_search_history_history_id_seq OWNED BY public.xdat_stored_search_history.history_id;


--
-- Name: xdat_stored_search_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_stored_search_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_stored_search_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xdat_stored_search_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_stored_search_meta_data_meta_data_id_seq OWNED BY public.xdat_stored_search_meta_data.meta_data_id;


--
-- Name: xdat_user_groupid_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_user_groupid_history (
    change_user integer,
    user_groupid_info integer,
    groupid character varying(255),
    previous_change_date timestamp without time zone,
    xdat_user_groupid_id integer,
    groups_groupid_xdat_user_xdat_user_id integer,
    history_id integer NOT NULL,
    xft_version integer,
    change_date timestamp without time zone,
    new_row_xdat_user_groupid_id integer
);


ALTER TABLE public.xdat_user_groupid_history OWNER TO xnat;

--
-- Name: xdat_user_groupid_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_user_groupid_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_user_groupid_history_history_id_seq OWNER TO xnat;

--
-- Name: xdat_user_groupid_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_user_groupid_history_history_id_seq OWNED BY public.xdat_user_groupid_history.history_id;


--
-- Name: xdat_user_groupid_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_user_groupid_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xdat_user_groupid_meta_data OWNER TO xnat;

--
-- Name: xdat_user_groupid_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_user_groupid_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_user_groupid_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xdat_user_groupid_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_user_groupid_meta_data_meta_data_id_seq OWNED BY public.xdat_user_groupid_meta_data.meta_data_id;


--
-- Name: xdat_user_groupid_xdat_user_groupid_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_user_groupid_xdat_user_groupid_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_user_groupid_xdat_user_groupid_id_seq OWNER TO xnat;

--
-- Name: xdat_user_groupid_xdat_user_groupid_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_user_groupid_xdat_user_groupid_id_seq OWNED BY public.xdat_user_groupid.xdat_user_groupid_id;


--
-- Name: xdat_user_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_user_history (
    users_user_xdat_security_xdat_security_id integer,
    quarantine_path character varying(255),
    salt character varying(255),
    user_info integer,
    xdat_user_id integer,
    lastname character varying(255),
    enabled integer,
    change_date timestamp without time zone,
    change_user integer,
    xft_version integer,
    login character varying(255),
    history_id integer NOT NULL,
    email character varying(255),
    primary_password_encrypt integer,
    verified integer,
    previous_change_date timestamp without time zone,
    primary_password character varying(255),
    firstname character varying(255),
    new_row_xdat_user_id integer
);


ALTER TABLE public.xdat_user_history OWNER TO xnat;

--
-- Name: xdat_user_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_user_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_user_history_history_id_seq OWNER TO xnat;

--
-- Name: xdat_user_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_user_history_history_id_seq OWNED BY public.xdat_user_history.history_id;


--
-- Name: xdat_user_login_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_user_login_history (
    change_user integer,
    session_id character varying(255),
    ip_address character varying(255),
    previous_change_date timestamp without time zone,
    user_xdat_user_id integer,
    login_date timestamp without time zone,
    history_id integer NOT NULL,
    xft_version integer,
    user_login_info integer,
    change_date timestamp without time zone,
    logout_date timestamp without time zone,
    xdat_user_login_id integer,
    new_row_xdat_user_login_id integer
);


ALTER TABLE public.xdat_user_login_history OWNER TO xnat;

--
-- Name: xdat_user_login_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_user_login_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_user_login_history_history_id_seq OWNER TO xnat;

--
-- Name: xdat_user_login_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_user_login_history_history_id_seq OWNED BY public.xdat_user_login_history.history_id;


--
-- Name: xdat_user_login_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_user_login_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xdat_user_login_meta_data OWNER TO xnat;

--
-- Name: xdat_user_login_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_user_login_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_user_login_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xdat_user_login_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_user_login_meta_data_meta_data_id_seq OWNED BY public.xdat_user_login_meta_data.meta_data_id;


--
-- Name: xdat_user_login_xdat_user_login_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_user_login_xdat_user_login_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_user_login_xdat_user_login_id_seq OWNER TO xnat;

--
-- Name: xdat_user_login_xdat_user_login_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_user_login_xdat_user_login_id_seq OWNED BY public.xdat_user_login.xdat_user_login_id;


--
-- Name: xdat_user_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_user_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_user_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xdat_user_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_user_meta_data_meta_data_id_seq OWNED BY public.xdat_user_meta_data.meta_data_id;


--
-- Name: xdat_user_xdat_user_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_user_xdat_user_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_user_xdat_user_id_seq OWNER TO xnat;

--
-- Name: xdat_user_xdat_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_user_xdat_user_id_seq OWNED BY public.xdat_user.xdat_user_id;


--
-- Name: xdat_usergroup_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xdat_usergroup_history (
    usergroup_info integer,
    change_user integer,
    id character varying(255),
    previous_change_date timestamp without time zone,
    displayname character varying(255),
    history_id integer NOT NULL,
    xdat_usergroup_id integer,
    xft_version integer,
    change_date timestamp without time zone,
    groups_group_xdat_security_xdat_security_id integer,
    tag character varying(255),
    new_row_xdat_usergroup_id integer
);


ALTER TABLE public.xdat_usergroup_history OWNER TO xnat;

--
-- Name: xdat_usergroup_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_usergroup_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_usergroup_history_history_id_seq OWNER TO xnat;

--
-- Name: xdat_usergroup_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_usergroup_history_history_id_seq OWNED BY public.xdat_usergroup_history.history_id;


--
-- Name: xdat_usergroup_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_usergroup_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_usergroup_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xdat_usergroup_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_usergroup_meta_data_meta_data_id_seq OWNED BY public.xdat_usergroup_meta_data.meta_data_id;


--
-- Name: xdat_usergroup_xdat_usergroup_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xdat_usergroup_xdat_usergroup_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xdat_usergroup_xdat_usergroup_id_seq OWNER TO xnat;

--
-- Name: xdat_usergroup_xdat_usergroup_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xdat_usergroup_xdat_usergroup_id_seq OWNED BY public.xdat_usergroup.xdat_usergroup_id;



--
-- Name: xhbm_alias_token; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_alias_token (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    alias character varying(255) NOT NULL,
    estimated_expiration_time timestamp without time zone,
    secret character varying(255) NOT NULL,
    single_use boolean NOT NULL,
    xdat_user_id character varying(255) NOT NULL
);


ALTER TABLE public.xhbm_alias_token OWNER TO xnat;

--
-- Name: xhbm_alias_token_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_alias_token_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_alias_token_id_seq OWNER TO xnat;

--
-- Name: xhbm_alias_token_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_alias_token_id_seq OWNED BY public.xhbm_alias_token.id;


--
-- Name: xhbm_alias_token_validipaddresses; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_alias_token_validipaddresses (
    alias_token bigint NOT NULL,
    validipaddresses character varying(255)
);


ALTER TABLE public.xhbm_alias_token_validipaddresses OWNER TO xnat;

--
-- Name: xhbm_archive_processor_instance; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_archive_processor_instance (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    label character varying(255),
    location character varying(255),
    priority integer NOT NULL,
    processor_class character varying(255),
    scope character varying(255)
);


ALTER TABLE public.xhbm_archive_processor_instance OWNER TO xnat;

--
-- Name: xhbm_archive_processor_instance_aud; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_archive_processor_instance_aud (
    id bigint NOT NULL,
    rev integer NOT NULL,
    revtype smallint,
    label character varying(255),
    location character varying(255),
    priority integer,
    processor_class character varying(255),
    scope character varying(255)
);


ALTER TABLE public.xhbm_archive_processor_instance_aud OWNER TO xnat;

--
-- Name: xhbm_archive_processor_instance_aud_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_archive_processor_instance_aud_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_archive_processor_instance_aud_id_seq OWNER TO xnat;

--
-- Name: xhbm_archive_processor_instance_aud_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_archive_processor_instance_aud_id_seq OWNED BY public.xhbm_archive_processor_instance_aud.id;


--
-- Name: xhbm_archive_processor_instance_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_archive_processor_instance_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_archive_processor_instance_id_seq OWNER TO xnat;

--
-- Name: xhbm_archive_processor_instance_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_archive_processor_instance_id_seq OWNED BY public.xhbm_archive_processor_instance.id;


--
-- Name: xhbm_archive_processor_instance_parameters; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_archive_processor_instance_parameters (
    archive_processor_instance bigint NOT NULL,
    value character varying(255),
    parameter_name character varying(255) NOT NULL
);


ALTER TABLE public.xhbm_archive_processor_instance_parameters OWNER TO xnat;

--
-- Name: xhbm_archive_processor_instance_parameters_aud; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_archive_processor_instance_parameters_aud (
    rev integer NOT NULL,
    archive_processor_instance bigint NOT NULL,
    value character varying(255) NOT NULL,
    parameter_name character varying(255) NOT NULL,
    revtype smallint
);


ALTER TABLE public.xhbm_archive_processor_instance_parameters_aud OWNER TO xnat;

--
-- Name: xhbm_archive_processor_instance_project_ids_list; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_archive_processor_instance_project_ids_list (
    archive_processor_instance bigint NOT NULL,
    project_ids_list character varying(255)
);


ALTER TABLE public.xhbm_archive_processor_instance_project_ids_list OWNER TO xnat;

--
-- Name: xhbm_archive_processor_instance_project_ids_list_aud; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_archive_processor_instance_project_ids_list_aud (
    rev integer NOT NULL,
    archive_processor_instance bigint NOT NULL,
    project_ids_list character varying(255) NOT NULL,
    revtype smallint
);


ALTER TABLE public.xhbm_archive_processor_instance_project_ids_list_aud OWNER TO xnat;

--
-- Name: xhbm_archive_processor_instance_scp_blacklist; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_archive_processor_instance_scp_blacklist (
    archive_processor_instance bigint NOT NULL,
    scp_blacklist character varying(255)
);


ALTER TABLE public.xhbm_archive_processor_instance_scp_blacklist OWNER TO xnat;

--
-- Name: xhbm_archive_processor_instance_scp_blacklist_aud; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_archive_processor_instance_scp_blacklist_aud (
    rev integer NOT NULL,
    archive_processor_instance bigint NOT NULL,
    scp_blacklist character varying(255) NOT NULL,
    revtype smallint
);


ALTER TABLE public.xhbm_archive_processor_instance_scp_blacklist_aud OWNER TO xnat;

--
-- Name: xhbm_archive_processor_instance_scp_whitelist; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_archive_processor_instance_scp_whitelist (
    archive_processor_instance bigint NOT NULL,
    scp_whitelist character varying(255)
);


ALTER TABLE public.xhbm_archive_processor_instance_scp_whitelist OWNER TO xnat;

--
-- Name: xhbm_archive_processor_instance_scp_whitelist_aud; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_archive_processor_instance_scp_whitelist_aud (
    rev integer NOT NULL,
    archive_processor_instance bigint NOT NULL,
    scp_whitelist character varying(255) NOT NULL,
    revtype smallint
);


ALTER TABLE public.xhbm_archive_processor_instance_scp_whitelist_aud OWNER TO xnat;

--
-- Name: xhbm_automation_event_ids; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_automation_event_ids (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    external_id character varying(255),
    src_event_class character varying(255)
);


ALTER TABLE public.xhbm_automation_event_ids OWNER TO xnat;

--
-- Name: xhbm_automation_event_ids_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_automation_event_ids_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_automation_event_ids_id_seq OWNER TO xnat;

--
-- Name: xhbm_automation_event_ids_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_automation_event_ids_id_seq OWNED BY public.xhbm_automation_event_ids.id;


--
-- Name: xhbm_automation_event_ids_ids; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_automation_event_ids_ids (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    counter bigint,
    event_id character varying(255),
    parent_automation_event_ids bigint
);


ALTER TABLE public.xhbm_automation_event_ids_ids OWNER TO xnat;

--
-- Name: xhbm_automation_event_ids_ids_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_automation_event_ids_ids_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_automation_event_ids_ids_id_seq OWNER TO xnat;

--
-- Name: xhbm_automation_event_ids_ids_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_automation_event_ids_ids_id_seq OWNED BY public.xhbm_automation_event_ids_ids.id;


--
-- Name: xhbm_automation_filters; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_automation_filters (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    external_id character varying(255),
    field character varying(255),
    src_event_class character varying(255)
);


ALTER TABLE public.xhbm_automation_filters OWNER TO xnat;

--
-- Name: xhbm_automation_filters_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_automation_filters_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_automation_filters_id_seq OWNER TO xnat;

--
-- Name: xhbm_automation_filters_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_automation_filters_id_seq OWNED BY public.xhbm_automation_filters.id;


--
-- Name: xhbm_automation_filters_values; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_automation_filters_values (
    automation_filters bigint NOT NULL,
    "values" character varying(255)
);


ALTER TABLE public.xhbm_automation_filters_values OWNER TO xnat;

--
-- Name: xhbm_category; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_category (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    event character varying(255),
    scope integer
);


ALTER TABLE public.xhbm_category OWNER TO xnat;

--
-- Name: xhbm_category_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_category_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_category_id_seq OWNER TO xnat;

--
-- Name: xhbm_category_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_category_id_seq OWNED BY public.xhbm_category.id;


--
-- Name: xhbm_channel; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_channel (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    format character varying(255),
    name character varying(255) NOT NULL
);


ALTER TABLE public.xhbm_channel OWNER TO xnat;

--
-- Name: xhbm_channel_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_channel_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_channel_id_seq OWNER TO xnat;

--
-- Name: xhbm_channel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_channel_id_seq OWNED BY public.xhbm_channel.id;


--
-- Name: xhbm_configuration; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_configuration (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    entity_id character varying(255),
    path character varying(255),
    project bigint,
    reason character varying(255),
    scope integer,
    status character varying(255),
    tool character varying(255),
    unversioned boolean DEFAULT false,
    version integer NOT NULL,
    xnat_user character varying(255),
    config_data bigint
);


ALTER TABLE public.xhbm_configuration OWNER TO xnat;

--
-- Name: xhbm_configuration_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_configuration_data (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    contents character varying(10485760)
);


ALTER TABLE public.xhbm_configuration_data OWNER TO xnat;

--
-- Name: xhbm_configuration_data_configurations; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_configuration_data_configurations (
    configuration_data bigint NOT NULL,
    configurations bigint NOT NULL
);


ALTER TABLE public.xhbm_configuration_data_configurations OWNER TO xnat;

--
-- Name: xhbm_configuration_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_configuration_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_configuration_data_id_seq OWNER TO xnat;

--
-- Name: xhbm_configuration_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_configuration_data_id_seq OWNED BY public.xhbm_configuration_data.id;


--
-- Name: xhbm_configuration_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_configuration_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_configuration_id_seq OWNER TO xnat;

--
-- Name: xhbm_configuration_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_configuration_id_seq OWNED BY public.xhbm_configuration.id;


--
-- Name: xhbm_data_cache_item; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_data_cache_item (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    key character varying(255),
    type character varying(255),
    value text
);


ALTER TABLE public.xhbm_data_cache_item OWNER TO xnat;

--
-- Name: xhbm_data_cache_item_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_data_cache_item_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_data_cache_item_id_seq OWNER TO xnat;

--
-- Name: xhbm_data_cache_item_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_data_cache_item_id_seq OWNED BY public.xhbm_data_cache_item.id;


--
-- Name: xhbm_definition; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_definition (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    entity bigint NOT NULL,
    category bigint
);


ALTER TABLE public.xhbm_definition OWNER TO xnat;

--
-- Name: xhbm_definition_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_definition_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_definition_id_seq OWNER TO xnat;

--
-- Name: xhbm_definition_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_definition_id_seq OWNED BY public.xhbm_definition.id;


--
-- Name: xhbm_event; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_event (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    event_id character varying(255),
    event_label character varying(255)
);


ALTER TABLE public.xhbm_event OWNER TO xnat;

--
-- Name: xhbm_event_filters; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_event_filters (
    id bigint NOT NULL,
    filter_var character varying(255),
    event_filters bigint
);


ALTER TABLE public.xhbm_event_filters OWNER TO xnat;

--
-- Name: xhbm_event_filters_filter_vals; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_event_filters_filter_vals (
    event_filters bigint NOT NULL,
    filter_vals character varying(255)
);


ALTER TABLE public.xhbm_event_filters_filter_vals OWNER TO xnat;

--
-- Name: xhbm_event_filters_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_event_filters_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_event_filters_id_seq OWNER TO xnat;

--
-- Name: xhbm_event_filters_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_event_filters_id_seq OWNED BY public.xhbm_event_filters.id;


--
-- Name: xhbm_event_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_event_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_event_id_seq OWNER TO xnat;

--
-- Name: xhbm_event_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_event_id_seq OWNED BY public.xhbm_event.id;


--
-- Name: xhbm_event_specific_fields; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_event_specific_fields (
    id bigint NOT NULL,
    field_name character varying(255),
    field_val character varying(255),
    event_specific_fields bigint
);


ALTER TABLE public.xhbm_event_specific_fields OWNER TO xnat;

--
-- Name: xhbm_event_specific_fields_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_event_specific_fields_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_event_specific_fields_id_seq OWNER TO xnat;

--
-- Name: xhbm_event_specific_fields_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_event_specific_fields_id_seq OWNED BY public.xhbm_event_specific_fields.id;


--
-- Name: xhbm_feature_definition; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_feature_definition (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    banned boolean,
    description character varying(255),
    key character varying(255),
    name character varying(255),
    on_by_default boolean
);


ALTER TABLE public.xhbm_feature_definition OWNER TO xnat;

--
-- Name: xhbm_feature_definition_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_feature_definition_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_feature_definition_id_seq OWNER TO xnat;

--
-- Name: xhbm_feature_definition_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_feature_definition_id_seq OWNED BY public.xhbm_feature_definition.id;


--
-- Name: xhbm_group_feature; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_group_feature (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    blocked boolean,
    feature character varying(255),
    group_id character varying(255),
    on_by_default boolean,
    tag character varying(255)
);


ALTER TABLE public.xhbm_group_feature OWNER TO xnat;

--
-- Name: xhbm_group_feature_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_group_feature_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_group_feature_id_seq OWNER TO xnat;

--
-- Name: xhbm_group_feature_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_group_feature_id_seq OWNED BY public.xhbm_group_feature.id;


--
-- Name: xhbm_host_info; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_host_info (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    host_name character varying(255)
);


ALTER TABLE public.xhbm_host_info OWNER TO xnat;

--
-- Name: xhbm_host_info_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_host_info_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_host_info_id_seq OWNER TO xnat;

--
-- Name: xhbm_host_info_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_host_info_id_seq OWNED BY public.xhbm_host_info.id;


--
-- Name: xhbm_notification; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_notification (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    parameter_format character varying(255),
    parameters text,
    definition bigint
);


ALTER TABLE public.xhbm_notification OWNER TO xnat;

--
-- Name: xhbm_notification_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_notification_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_notification_id_seq OWNER TO xnat;

--
-- Name: xhbm_notification_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_notification_id_seq OWNED BY public.xhbm_notification.id;


--
-- Name: xhbm_persistent_event; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_persistent_event (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    entity_id character varying(255),
    entity_type character varying(255),
    event_id character varying(255),
    external_id character varying(255),
    src_event_class character varying(255),
    user_id integer
);


ALTER TABLE public.xhbm_persistent_event OWNER TO xnat;

--
-- Name: xhbm_persistent_event_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_persistent_event_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_persistent_event_id_seq OWNER TO xnat;

--
-- Name: xhbm_persistent_event_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_persistent_event_id_seq OWNED BY public.xhbm_persistent_event.id;


--
-- Name: xhbm_preference; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_preference (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    entity_id character varying(255),
    name character varying(255) NOT NULL,
    scope integer,
    value character varying(65535) NOT NULL,
    tool bigint
);


ALTER TABLE public.xhbm_preference OWNER TO xnat;

--
-- Name: xhbm_preference_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_preference_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_preference_id_seq OWNER TO xnat;

--
-- Name: xhbm_preference_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_preference_id_seq OWNED BY public.xhbm_preference.id;


--
-- Name: xhbm_revinfo; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_revinfo (
    rev integer NOT NULL,
    revtstmp bigint
);


ALTER TABLE public.xhbm_revinfo OWNER TO xnat;

--
-- Name: xhbm_script; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_script (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    content text,
    description character varying(255),
    language character varying(255),
    script_id character varying(255),
    script_label character varying(255)
);


ALTER TABLE public.xhbm_script OWNER TO xnat;

--
-- Name: xhbm_script_aud; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_script_aud (
    id bigint NOT NULL,
    rev integer NOT NULL,
    revtype smallint,
    content text,
    description character varying(255),
    language character varying(255),
    script_id character varying(255),
    script_label character varying(255)
);


ALTER TABLE public.xhbm_script_aud OWNER TO xnat;

--
-- Name: xhbm_script_aud_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_script_aud_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_script_aud_id_seq OWNER TO xnat;

--
-- Name: xhbm_script_aud_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_script_aud_id_seq OWNED BY public.xhbm_script_aud.id;


--
-- Name: xhbm_script_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_script_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_script_id_seq OWNER TO xnat;

--
-- Name: xhbm_script_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_script_id_seq OWNED BY public.xhbm_script.id;


--
-- Name: xhbm_script_launch_request_event; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_script_launch_request_event (
    id bigint NOT NULL
);


ALTER TABLE public.xhbm_script_launch_request_event OWNER TO xnat;

--
-- Name: xhbm_script_launch_request_event_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_script_launch_request_event_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_script_launch_request_event_id_seq OWNER TO xnat;

--
-- Name: xhbm_script_launch_request_event_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_script_launch_request_event_id_seq OWNED BY public.xhbm_script_launch_request_event.id;


--
-- Name: xhbm_script_trigger; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_script_trigger (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    association character varying(255) NOT NULL,
    description character varying(255),
    event character varying(255),
    script_id character varying(255) NOT NULL,
    src_event_class character varying(255),
    trigger_id character varying(255) NOT NULL
);


ALTER TABLE public.xhbm_script_trigger OWNER TO xnat;

--
-- Name: xhbm_script_trigger_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_script_trigger_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_script_trigger_id_seq OWNER TO xnat;

--
-- Name: xhbm_script_trigger_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_script_trigger_id_seq OWNED BY public.xhbm_script_trigger.id;


--
-- Name: xhbm_script_trigger_template; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_script_trigger_template (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    description character varying(255),
    template_id character varying(255)
);


ALTER TABLE public.xhbm_script_trigger_template OWNER TO xnat;

--
-- Name: xhbm_script_trigger_template_associated_entities; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_script_trigger_template_associated_entities (
    script_trigger_template bigint NOT NULL,
    associated_entities character varying(255)
);


ALTER TABLE public.xhbm_script_trigger_template_associated_entities OWNER TO xnat;

--
-- Name: xhbm_script_trigger_template_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_script_trigger_template_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_script_trigger_template_id_seq OWNER TO xnat;

--
-- Name: xhbm_script_trigger_template_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_script_trigger_template_id_seq OWNED BY public.xhbm_script_trigger_template.id;


--
-- Name: xhbm_script_trigger_template_triggers; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_script_trigger_template_triggers (
    script_trigger_template bigint NOT NULL,
    triggers bigint NOT NULL
);


ALTER TABLE public.xhbm_script_trigger_template_triggers OWNER TO xnat;

--
-- Name: xhbm_spawner_element; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_spawner_element (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    description character varying(1024),
    element_id character varying(255) NOT NULL,
    label character varying(255),
    namespace character varying(255) DEFAULT 'xnat'::character varying NOT NULL,
    yaml text
);


ALTER TABLE public.xhbm_spawner_element OWNER TO xnat;

--
-- Name: xhbm_spawner_element_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_spawner_element_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_spawner_element_id_seq OWNER TO xnat;

--
-- Name: xhbm_spawner_element_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_spawner_element_id_seq OWNED BY public.xhbm_spawner_element.id;


--
-- Name: xhbm_subscriber; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_subscriber (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    emails character varying(255),
    name character varying(255)
);


ALTER TABLE public.xhbm_subscriber OWNER TO xnat;

--
-- Name: xhbm_subscriber_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_subscriber_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_subscriber_id_seq OWNER TO xnat;

--
-- Name: xhbm_subscriber_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_subscriber_id_seq OWNED BY public.xhbm_subscriber.id;


--
-- Name: xhbm_subscription; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_subscription (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    subscriber_type integer,
    definition bigint,
    subscriber bigint
);


ALTER TABLE public.xhbm_subscription OWNER TO xnat;

--
-- Name: xhbm_subscription_channels; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_subscription_channels (
    subscription bigint NOT NULL,
    channels bigint NOT NULL
);


ALTER TABLE public.xhbm_subscription_channels OWNER TO xnat;

--
-- Name: xhbm_subscription_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_subscription_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_subscription_id_seq OWNER TO xnat;

--
-- Name: xhbm_subscription_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_subscription_id_seq OWNED BY public.xhbm_subscription.id;


--
-- Name: xhbm_tool; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_tool (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    resolver character varying(255),
    strict boolean NOT NULL,
    tool_description character varying(255),
    tool_id character varying(255) NOT NULL,
    tool_name character varying(255) NOT NULL
);


ALTER TABLE public.xhbm_tool OWNER TO xnat;

--
-- Name: xhbm_tool_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_tool_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_tool_id_seq OWNER TO xnat;

--
-- Name: xhbm_tool_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_tool_id_seq OWNED BY public.xhbm_tool.id;


--
-- Name: xhbm_user_change_request; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_user_change_request (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    change_id character varying(255),
    field_to_change character varying(255),
    guid character varying(255),
    new_value character varying(255),
    username character varying(255)
);


ALTER TABLE public.xhbm_user_change_request OWNER TO xnat;

--
-- Name: xhbm_user_change_request_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_user_change_request_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_user_change_request_id_seq OWNER TO xnat;

--
-- Name: xhbm_user_change_request_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_user_change_request_id_seq OWNED BY public.xhbm_user_change_request.id;


--
-- Name: xhbm_user_registration_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_user_registration_data (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    comments character varying(255),
    login character varying(255) NOT NULL,
    organization character varying(255),
    phone character varying(255)
);


ALTER TABLE public.xhbm_user_registration_data OWNER TO xnat;

--
-- Name: xhbm_user_registration_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_user_registration_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_user_registration_data_id_seq OWNER TO xnat;

--
-- Name: xhbm_user_registration_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_user_registration_data_id_seq OWNED BY public.xhbm_user_registration_data.id;


--
-- Name: xhbm_user_role; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_user_role (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    role character varying(255),
    username character varying(255)
);


ALTER TABLE public.xhbm_user_role OWNER TO xnat;

--
-- Name: xhbm_user_role_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_user_role_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_user_role_id_seq OWNER TO xnat;

--
-- Name: xhbm_user_role_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_user_role_id_seq OWNED BY public.xhbm_user_role.id;


--
-- Name: xhbm_xdat_user_auth; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_xdat_user_auth (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    auth_method character varying(255),
    auth_method_id character varying(255),
    auth_user character varying(255),
    failed_login_attempts integer,
    last_login_attempt timestamp without time zone,
    last_successful_login timestamp without time zone,
    lockout_time timestamp without time zone,
    password_updated timestamp without time zone,
    xdat_username character varying(255)
);


ALTER TABLE public.xhbm_xdat_user_auth OWNER TO xnat;

--
-- Name: xhbm_xdat_user_auth_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_xdat_user_auth_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_xdat_user_auth_id_seq OWNER TO xnat;

--
-- Name: xhbm_xdat_user_auth_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_xdat_user_auth_id_seq OWNED BY public.xhbm_xdat_user_auth.id;


--
-- Name: xhbm_xft_field_exclusion; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_xft_field_exclusion (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    pattern character varying(255),
    scope integer,
    target_id character varying(255)
);


ALTER TABLE public.xhbm_xft_field_exclusion OWNER TO xnat;

--
-- Name: xhbm_xft_field_exclusion_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_xft_field_exclusion_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_xft_field_exclusion_id_seq OWNER TO xnat;

--
-- Name: xhbm_xft_field_exclusion_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_xft_field_exclusion_id_seq OWNED BY public.xhbm_xft_field_exclusion.id;


--
-- Name: xhbm_xnat_node_info; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_xnat_node_info (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    host_name character varying(255),
    is_active boolean,
    last_check_in timestamp without time zone,
    last_initialized timestamp without time zone,
    last_ip_address character varying(255),
    node_id character varying(255)
);


ALTER TABLE public.xhbm_xnat_node_info OWNER TO xnat;

--
-- Name: xhbm_xnat_node_info_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_xnat_node_info_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_xnat_node_info_id_seq OWNER TO xnat;

--
-- Name: xhbm_xnat_node_info_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_xnat_node_info_id_seq OWNED BY public.xhbm_xnat_node_info.id;


--
-- Name: xhbm_xnat_task_info; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xhbm_xnat_task_info (
    id bigint NOT NULL,
    created timestamp without time zone NOT NULL,
    disabled timestamp without time zone NOT NULL,
    enabled boolean DEFAULT true,
    "timestamp" timestamp without time zone NOT NULL,
    last_run timestamp without time zone,
    task_id character varying(255),
    xnat_node_info_id bigint
);


ALTER TABLE public.xhbm_xnat_task_info OWNER TO xnat;

--
-- Name: xhbm_xnat_task_info_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xhbm_xnat_task_info_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xhbm_xnat_task_info_id_seq OWNER TO xnat;

--
-- Name: xhbm_xnat_task_info_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xhbm_xnat_task_info_id_seq OWNED BY public.xhbm_xnat_task_info.id;



--
-- Name: xnat_a_scidresearchdata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_a_scidresearchdata_history (
    psychoticdisorders_pastschizophreniformdisorder integer,
    moodepisodes_currenthypomanicepisode integer,
    substanceusedisorders_currentamphetaminedependence integer,
    substanceusedisorders_pastopioidabuse integer,
    anxietydisorders_currentanxietyduetomedicalcondition integer,
    psychoticsymptoms_currentcatatonicbehavior integer,
    psychoticdisorders_pastcatatonictype integer,
    somatoformdisorders_somatizationdisorder integer,
    anxietydisorders_currentocd integer,
    history_id integer NOT NULL,
    substanceusedisorders_currentalcoholdependence integer,
    psychoticdisorders_pastdelusionaldisorder integer,
    psychoticsymptoms_currentnegativesymptoms integer,
    psychoticdisorders_currentundifferentiatedtype integer,
    moodepisodes_pasthypomanicepisode integer,
    psychoticdisorders_pastundifferentiatedtype integer,
    anxietydisorders_currentpanicwithoutagoraphobia integer,
    mooddisorders_currentbipolar2disorder integer,
    anxietydisorders_pastspecificphobia integer,
    moodepisodes_currentdysthmicepisode integer,
    anxietydisorders_pastanxietyduetomedicalcondition integer,
    substanceusedisorders_pastphencyclidineabuse integer,
    substanceusedisorders_pastamphetamineabuse integer,
    substanceusedisorders_pastsedativehypnoticanxiolyticabuse integer,
    anxietydisorders_pastanxietydisordernos integer,
    anxietydisorders_pastsocialphobia integer,
    substanceusedisorders_pasthallucinogenabuse integer,
    substanceusedisorders_currentpolysubstancedependence integer,
    psychoticdisorders_currentdelusionaldisorder integer,
    somatoformdisorders_hypochondriasis integer,
    psychoticdisorders_currentpsychoticdisordernos integer,
    change_date timestamp without time zone,
    eatingdisorders_pastbulimianervosa integer,
    moodepisodes_currentmanicepisode integer,
    anxietydisorders_currentanxietydisordernos integer,
    substanceusedisorders_currentcocainedependence integer,
    somatoformdisorders_bodydysmorphicdisorder integer,
    psychoticdisorders_pastpsychoticdisordernos integer,
    moodepisodes_currentmajordepressiveepisode integer,
    id character varying(255),
    optional_pastacutestressdisorder integer,
    psychoticdisorders_pastschizoaffectivedisorder integer,
    substanceusedisorders_currentsedativehypnoticanxiolyticabuse integer,
    mooddisorders_pastmajordepressivedisorder integer,
    somatoformdisorders_undifferentiatedsomatformdisorder integer,
    optional_currentacutestressdisorder integer,
    substanceusedisorders_currenthallucinogendependence integer,
    substanceusedisorders_currentcannabisdependence integer,
    anxietydisorders_pastpanicwithoutagoraphobia integer,
    mooddisorders_pastbipolar1disorder integer,
    optional_pastmixedanxietydepressivedisorder integer,
    substanceusedisorders_currentopioidabuse integer,
    substanceusedisorders_pastcocaineabuse integer,
    psychoticsymptoms_currentdisorganizedspeechbehavior integer,
    administrator character varying(255),
    substanceusedisorders_pastpolysubstancedependence integer,
    substanceusedisorders_pastalcoholabuse integer,
    psychoticdisorders_currentparanoidtype integer,
    optional_pastsympomaticdetails character varying(255),
    substanceusedisorders_currentotherorunknowndependence integer,
    psychoticsymptoms_pastcatatonicbehavior integer,
    psychoticdisorders_currentpsychoticdisorderduetomedicalconditio integer,
    substanceusedisorders_currentotherorunknownabuse integer,
    anxietydisorders_currentagoraphobiawithoutpanichx integer,
    substanceusedisorders_currentamphetamineabuse integer,
    psychoticdisorders_currentbriefpsychoticdisorder integer,
    substanceusedisorders_currentsedativehypnoticanxiolyticdependen integer,
    psychoticdisorders_pastparanoidtype integer,
    xft_version integer,
    psychoticsymptoms_pasthallucinations integer,
    scidresearchdata_info integer,
    substanceusedisorders_currentcocaineabuse integer,
    adjustmentdisorder integer,
    substanceusedisorders_currentphencyclidineabuse integer,
    psychoticsymptoms_pastnegativesymptoms integer,
    psychoticdisorders_pastbriefpsychoticdisorder integer,
    substanceusedisorders_currentalcoholabuse integer,
    moodepisodes_pastmanicepisode integer,
    previous_change_date timestamp without time zone,
    mooddisorders_currentmajordepressivedisorder integer,
    substanceusedisorders_pastalcoholdependence integer,
    psychoticdisorders_currentschizoaffectivedisorder integer,
    psychoticdisorders_pastsubstanceinducedpsychoticdisorder integer,
    moodepisodes_pastmooddisorderduetomedicalcondition integer,
    psychoticsymptoms_currenthallucinations integer,
    optional_currentmixedanxietydepressivedisorder integer,
    substanceusedisorders_pastamphetaminedependence integer,
    moodepisodes_pastmajordepressiveepisode integer,
    moodepisodes_currentsubstanceinducedmooddisorder integer,
    anxietydisorders_currentptsd integer,
    mooddisorders_currentdepressivedisordernos integer,
    psychoticdisorders_currentschizophreniformdisorder integer,
    mooddisorders_pastotherbipolardisorder integer,
    optional_currentminordepressivedisorder integer,
    psychoticsymptoms_pastdisorganizedspeechbehavior integer,
    psychoticdisorders_currentsubstanceinducedpsychoticdisorder integer,
    mooddisorders_pastbipolar2disorder integer,
    substanceusedisorders_pastcocainedependence integer,
    psychoticdisorders_currentresidualtype integer,
    substanceusedisorders_pastsedativehypnoticanxiolyticdependence integer,
    substanceusedisorders_pastopioiddependence integer,
    anxietydisorders_pastsubstanceinducedanxietydisorder integer,
    substanceusedisorders_pastotherorunknowndependence integer,
    eatingdisorders_currentbingeeatingdisorder integer,
    substanceusedisorders_pastcannabisabuse integer,
    substanceusedisorders_currentphencyclidinedependence integer,
    substanceusedisorders_currenthallucinogenabuse integer,
    anxietydisorders_currentgeneralizedanxietydisorder integer,
    anxietydisorders_currentspecificphobia integer,
    anxietydisorders_pastptsd integer,
    substanceusedisorders_currentcannabisabuse integer,
    moodepisodes_pastsubstanceinducedmooddisorder integer,
    mooddisorders_currentotherbipolardisorder integer,
    psychoticdisorders_currentschizophrenia integer,
    psychoticdisorders_pastresidualtype integer,
    anxietydisorders_pastocd integer,
    eatingdisorders_currentbulimianervosa integer,
    mooddisorders_currentbipolar1disorder integer,
    eatingdisorders_currentanorexianervosa integer,
    substanceusedisorders_currentopioiddependence integer,
    eatingdisorders_pastanorexianervosa integer,
    moodepisodes_currentmooddisorderduetomedicalcondition integer,
    psychoticdisorders_pastpsychoticdisorderduetomedicalcondition integer,
    optional_pastminordepressivedisorder integer,
    substanceusedisorders_pasthallucinogendependence integer,
    anxietydisorders_currentsubstanceinducedanxietydisorder integer,
    change_user integer,
    psychoticsymptoms_currentdelusions integer,
    substanceusedisorders_pastphencyclidinedependence integer,
    psychoticdisorders_currentcatatonictype integer,
    mooddisorders_pastdepressivedisordernos integer,
    anxietydisorders_pastpanicwithagoraphobia integer,
    anxietydisorders_currentsocialphobia integer,
    anxietydisorders_pastagoraphobiawithoutpanichx integer,
    somatoformdisorders_paindisorder integer,
    psychoticdisorders_currentdisorganizedtype integer,
    psychoticdisorders_pastschizophrenia integer,
    psychoticsymptoms_pastdelusions integer,
    substanceusedisorders_pastcannabisdependence integer,
    anxietydisorders_currentpanicwithagoraphobia integer,
    substanceusedisorders_pastotherorunknownabuse integer,
    psychoticdisorders_pastdisorganizedtype integer,
    eatingdisorders_pastbingeeatingdisorder integer,
    new_row_id character varying(255)
);


ALTER TABLE public.xnat_a_scidresearchdata_history OWNER TO xnat;

--
-- Name: xnat_a_scidresearchdata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_a_scidresearchdata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_a_scidresearchdata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_a_scidresearchdata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_a_scidresearchdata_history_history_id_seq OWNED BY public.xnat_a_scidresearchdata_history.history_id;


--
-- Name: xnat_a_scidresearchdata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_a_scidresearchdata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_a_scidresearchdata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_a_scidresearchdata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_a_scidresearchdata_meta_data_meta_data_id_seq OWNED BY public.xnat_a_scidresearchdata_meta_data.meta_data_id;


--
-- Name: xnat_a_sideeffectspittsburghdata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_a_sideeffectspittsburghdata_history (
    picking_skin_fingers_nails_lip integer,
    lossofappetite integer,
    tearful_sad_depressed integer,
    crabby_irritable integer,
    dull_tired_listless integer,
    drymouth integer,
    stomachache integer,
    socialwithdrawal integer,
    change_date timestamp without time zone,
    nausea_vomiting integer,
    troubleconcentrating_distractible integer,
    change_user integer,
    xft_version integer,
    troublesleeping integer,
    id character varying(255),
    sideeffectspittsburghdata_info integer,
    history_id integer NOT NULL,
    worried_anxious integer,
    previous_change_date timestamp without time zone,
    buccal_lingualmovements integer,
    sedation integer,
    dizziness_lightheadedness integer,
    palpitations integer,
    motortics integer,
    hallucinations integer,
    headaches integer,
    new_row_id character varying(255)
);


ALTER TABLE public.xnat_a_sideeffectspittsburghdata_history OWNER TO xnat;

--
-- Name: xnat_a_sideeffectspittsburghdata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_a_sideeffectspittsburghdata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_a_sideeffectspittsburghdata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_a_sideeffectspittsburghdata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_a_sideeffectspittsburghdata_history_history_id_seq OWNED BY public.xnat_a_sideeffectspittsburghdata_history.history_id;


--
-- Name: xnat_a_sideeffectspittsburghdata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_a_sideeffectspittsburghdata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_a_sideeffectspittsburghdata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_a_sideeffectspittsburghdata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_a_sideeffectspittsburghdata_meta_data_meta_data_id_seq OWNED BY public.xnat_a_sideeffectspittsburghdata_meta_data.meta_data_id;


--
-- Name: xnat_a_updrs3data_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_a_updrs3data_history (
    facialexpression integer,
    history_id integer NOT NULL,
    speech integer,
    change_date timestamp without time zone,
    clicker_left integer,
    tremorrest_lle character varying(255),
    handmovementsgrip_left integer,
    clicker_interval integer,
    fingertaps_left integer,
    tremorrest_lue character varying(255),
    fingertaps_right integer,
    arisefromchair integer,
    xft_version integer,
    posturalstability integer,
    problem integer,
    bodybradykinesiahypokinesia integer,
    updrs3data_info integer,
    tremorrest_rle character varying(255),
    inscanner integer,
    rigidity_lle character varying(255),
    tremorrest_rue character varying(255),
    rigidity_lue character varying(255),
    handsram_left integer,
    actionposturaltremor_right integer,
    previous_change_date timestamp without time zone,
    handmovementsgrip_right integer,
    gait integer,
    clicker_right integer,
    foottaps_left integer,
    id character varying(255),
    tremorrest_face character varying(255),
    change_user integer,
    rigidity_rle character varying(255),
    rigidity_rue character varying(255),
    rigidity_neck character varying(255),
    writing integer,
    actionposturaltremor_left integer,
    posture integer,
    handsram_right integer,
    foottaps_right integer,
    new_row_id character varying(255)
);


ALTER TABLE public.xnat_a_updrs3data_history OWNER TO xnat;

--
-- Name: xnat_a_updrs3data_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_a_updrs3data_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_a_updrs3data_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_a_updrs3data_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_a_updrs3data_history_history_id_seq OWNED BY public.xnat_a_updrs3data_history.history_id;


--
-- Name: xnat_a_updrs3data_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_a_updrs3data_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_a_updrs3data_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_a_updrs3data_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_a_updrs3data_meta_data_meta_data_id_seq OWNED BY public.xnat_a_updrs3data_meta_data.meta_data_id;


--
-- Name: xnat_a_ybocsdata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_a_ybocsdata_history (
    controloverthoughts integer,
    untiljustright integer,
    distresscaused integer,
    ybocsdata_info integer,
    untiljustrightawareness character varying(255),
    untiljustrightperceptions character varying(255),
    change_date timestamp without time zone,
    thoughtsinterferefunctioning integer,
    currentorworstever character varying(255),
    change_user integer,
    xft_version integer,
    id character varying(255),
    behaviorsinterferefunctioning integer,
    history_id integer NOT NULL,
    whenstartuntiljustright character varying(255),
    previous_change_date timestamp without time zone,
    feelingifprevented integer,
    timeperforming integer,
    firstuntiljustrightage double precision,
    efforttoresistthoughts integer,
    frequencyuntiljustright character varying(255),
    behaviordrivestrength integer,
    efforttoresistbehaviors integer,
    timeoccupiedwiththoughts integer,
    new_row_id character varying(255)
);


ALTER TABLE public.xnat_a_ybocsdata_history OWNER TO xnat;

--
-- Name: xnat_a_ybocsdata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_a_ybocsdata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_a_ybocsdata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_a_ybocsdata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_a_ybocsdata_history_history_id_seq OWNED BY public.xnat_a_ybocsdata_history.history_id;


--
-- Name: xnat_a_ybocsdata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_a_ybocsdata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_a_ybocsdata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_a_ybocsdata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_a_ybocsdata_meta_data_meta_data_id_seq OWNED BY public.xnat_a_ybocsdata_meta_data.meta_data_id;


--
-- Name: xnat_a_ygtssdata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_a_ygtssdata_history (
    phonic_complexity integer,
    motor_interference integer,
    motor_intensity integer,
    phonic_interference integer,
    motor_inventory character varying(255),
    phonic_intensity integer,
    worsteverage double precision,
    change_date timestamp without time zone,
    phonic_number integer,
    phonic_inventory character varying(255),
    change_user integer,
    xft_version integer,
    filledoutby character varying(255),
    id character varying(255),
    history_id integer NOT NULL,
    phonic_frequency integer,
    motor_complexity integer,
    motor_number integer,
    previous_change_date timestamp without time zone,
    period character varying(255),
    impairment integer,
    ygtssdata_info integer,
    motor_frequency integer,
    new_row_id character varying(255)
);


ALTER TABLE public.xnat_a_ygtssdata_history OWNER TO xnat;

--
-- Name: xnat_a_ygtssdata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_a_ygtssdata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_a_ygtssdata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_a_ygtssdata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_a_ygtssdata_history_history_id_seq OWNED BY public.xnat_a_ygtssdata_history.history_id;


--
-- Name: xnat_a_ygtssdata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_a_ygtssdata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_a_ygtssdata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_a_ygtssdata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_a_ygtssdata_meta_data_meta_data_id_seq OWNED BY public.xnat_a_ygtssdata_meta_data.meta_data_id;


--
-- Name: xnat_abstractdemographicdata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_abstractdemographicdata_history (
    change_user integer,
    xnat_abstractdemographicdata_id integer,
    previous_change_date timestamp without time zone,
    abstractdemographicdata_info integer,
    history_id integer NOT NULL,
    change_date timestamp without time zone,
    xft_version integer,
    extension integer,
    new_row_xnat_abstractdemographicdata_id integer
);


ALTER TABLE public.xnat_abstractdemographicdata_history OWNER TO xnat;

--
-- Name: xnat_abstractdemographicdata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_abstractdemographicdata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_abstractdemographicdata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_abstractdemographicdata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_abstractdemographicdata_history_history_id_seq OWNED BY public.xnat_abstractdemographicdata_history.history_id;


--
-- Name: xnat_abstractdemographicdata_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_abstractdemographicdata_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xnat_abstractdemographicdata_meta_data OWNER TO xnat;

--
-- Name: xnat_abstractdemographicdata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_abstractdemographicdata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_abstractdemographicdata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_abstractdemographicdata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_abstractdemographicdata_meta_data_meta_data_id_seq OWNED BY public.xnat_abstractdemographicdata_meta_data.meta_data_id;


--
-- Name: xnat_abstractdemographicdata_xnat_abstractdemographicdata_i_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_abstractdemographicdata_xnat_abstractdemographicdata_i_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_abstractdemographicdata_xnat_abstractdemographicdata_i_seq OWNER TO xnat;

--
-- Name: xnat_abstractdemographicdata_xnat_abstractdemographicdata_i_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_abstractdemographicdata_xnat_abstractdemographicdata_i_seq OWNED BY public.xnat_abstractdemographicdata.xnat_abstractdemographicdata_id;


--
-- Name: xnat_abstractprotocol; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_abstractprotocol (
    id character varying(255) DEFAULT ''::character varying NOT NULL,
    name character varying(255),
    description text,
    data_type character varying(255),
    extension integer,
    abstractprotocol_info integer,
    xnat_abstractprotocol_id integer NOT NULL,
    xnat_projectdata_id character varying(255)
);


ALTER TABLE public.xnat_abstractprotocol OWNER TO xnat;

--
-- Name: xnat_abstractprotocol_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_abstractprotocol_history (
    change_user integer,
    name character varying(255),
    id character varying(255),
    xnat_abstractprotocol_id integer,
    previous_change_date timestamp without time zone,
    xnat_projectdata_id character varying(255),
    history_id integer NOT NULL,
    abstractprotocol_info integer,
    data_type character varying(255),
    description text,
    xft_version integer,
    change_date timestamp without time zone,
    extension integer,
    new_row_xnat_abstractprotocol_id integer
);


ALTER TABLE public.xnat_abstractprotocol_history OWNER TO xnat;

--
-- Name: xnat_abstractprotocol_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_abstractprotocol_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_abstractprotocol_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_abstractprotocol_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_abstractprotocol_history_history_id_seq OWNED BY public.xnat_abstractprotocol_history.history_id;


--
-- Name: xnat_abstractprotocol_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_abstractprotocol_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xnat_abstractprotocol_meta_data OWNER TO xnat;

--
-- Name: xnat_abstractprotocol_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_abstractprotocol_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_abstractprotocol_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_abstractprotocol_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_abstractprotocol_meta_data_meta_data_id_seq OWNED BY public.xnat_abstractprotocol_meta_data.meta_data_id;


--
-- Name: xnat_abstractprotocol_xnat_abstractprotocol_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_abstractprotocol_xnat_abstractprotocol_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_abstractprotocol_xnat_abstractprotocol_id_seq OWNER TO xnat;

--
-- Name: xnat_abstractprotocol_xnat_abstractprotocol_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_abstractprotocol_xnat_abstractprotocol_id_seq OWNED BY public.xnat_abstractprotocol.xnat_abstractprotocol_id;


--
-- Name: xnat_abstractresource_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_abstractresource_history (
    change_user integer,
    abstractresource_info integer,
    file_count integer,
    previous_change_date timestamp without time zone,
    file_size bigint,
    history_id integer NOT NULL,
    note text,
    label character varying(255),
    xnat_imagescandata_xnat_imagescandata_id integer,
    xnat_abstractresource_id integer,
    xft_version integer,
    change_date timestamp without time zone,
    extension integer,
    new_row_xnat_abstractresource_id integer
);


ALTER TABLE public.xnat_abstractresource_history OWNER TO xnat;

--
-- Name: xnat_abstractresource_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_abstractresource_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_abstractresource_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_abstractresource_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_abstractresource_history_history_id_seq OWNED BY public.xnat_abstractresource_history.history_id;


--
-- Name: xnat_abstractresource_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_abstractresource_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xnat_abstractresource_meta_data OWNER TO xnat;

--
-- Name: xnat_abstractresource_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_abstractresource_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_abstractresource_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_abstractresource_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_abstractresource_meta_data_meta_data_id_seq OWNED BY public.xnat_abstractresource_meta_data.meta_data_id;


--
-- Name: xnat_abstractresource_tag; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_abstractresource_tag (
    tag character varying(255),
    name character varying(255),
    abstractresource_tag_info integer,
    xnat_abstractresource_tag_id integer NOT NULL,
    tags_tag_xnat_abstractresource_xnat_abstractresource_id integer
);


ALTER TABLE public.xnat_abstractresource_tag OWNER TO xnat;

--
-- Name: xnat_abstractresource_tag_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_abstractresource_tag_history (
    change_user integer,
    name character varying(255),
    previous_change_date timestamp without time zone,
    abstractresource_tag_info integer,
    history_id integer NOT NULL,
    tags_tag_xnat_abstractresource_xnat_abstractresource_id integer,
    xft_version integer,
    xnat_abstractresource_tag_id integer,
    change_date timestamp without time zone,
    tag character varying(255),
    new_row_xnat_abstractresource_tag_id integer
);


ALTER TABLE public.xnat_abstractresource_tag_history OWNER TO xnat;

--
-- Name: xnat_abstractresource_tag_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_abstractresource_tag_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_abstractresource_tag_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_abstractresource_tag_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_abstractresource_tag_history_history_id_seq OWNED BY public.xnat_abstractresource_tag_history.history_id;


--
-- Name: xnat_abstractresource_tag_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_abstractresource_tag_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xnat_abstractresource_tag_meta_data OWNER TO xnat;

--
-- Name: xnat_abstractresource_tag_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_abstractresource_tag_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_abstractresource_tag_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_abstractresource_tag_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_abstractresource_tag_meta_data_meta_data_id_seq OWNED BY public.xnat_abstractresource_tag_meta_data.meta_data_id;


--
-- Name: xnat_abstractresource_tag_xnat_abstractresource_tag_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_abstractresource_tag_xnat_abstractresource_tag_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_abstractresource_tag_xnat_abstractresource_tag_id_seq OWNER TO xnat;

--
-- Name: xnat_abstractresource_tag_xnat_abstractresource_tag_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_abstractresource_tag_xnat_abstractresource_tag_id_seq OWNED BY public.xnat_abstractresource_tag.xnat_abstractresource_tag_id;


--
-- Name: xnat_abstractresource_xnat_abstractresource_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_abstractresource_xnat_abstractresource_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_abstractresource_xnat_abstractresource_id_seq OWNER TO xnat;

--
-- Name: xnat_abstractresource_xnat_abstractresource_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_abstractresource_xnat_abstractresource_id_seq OWNED BY public.xnat_abstractresource.xnat_abstractresource_id;


--
-- Name: xnat_abstractstatistics; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_abstractstatistics (
    extension integer,
    abstractstatistics_info integer,
    xnat_abstractstatistics_id integer NOT NULL
);


ALTER TABLE public.xnat_abstractstatistics OWNER TO xnat;

--
-- Name: xnat_abstractstatistics_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_abstractstatistics_history (
    change_user integer,
    abstractstatistics_info integer,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    xnat_abstractstatistics_id integer,
    change_date timestamp without time zone,
    xft_version integer,
    extension integer,
    new_row_xnat_abstractstatistics_id integer
);


ALTER TABLE public.xnat_abstractstatistics_history OWNER TO xnat;

--
-- Name: xnat_abstractstatistics_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_abstractstatistics_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_abstractstatistics_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_abstractstatistics_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_abstractstatistics_history_history_id_seq OWNED BY public.xnat_abstractstatistics_history.history_id;


--
-- Name: xnat_abstractstatistics_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_abstractstatistics_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xnat_abstractstatistics_meta_data OWNER TO xnat;

--
-- Name: xnat_abstractstatistics_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_abstractstatistics_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_abstractstatistics_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_abstractstatistics_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_abstractstatistics_meta_data_meta_data_id_seq OWNED BY public.xnat_abstractstatistics_meta_data.meta_data_id;


--
-- Name: xnat_abstractstatistics_xnat_abstractstatistics_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_abstractstatistics_xnat_abstractstatistics_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_abstractstatistics_xnat_abstractstatistics_id_seq OWNER TO xnat;

--
-- Name: xnat_abstractstatistics_xnat_abstractstatistics_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_abstractstatistics_xnat_abstractstatistics_id_seq OWNED BY public.xnat_abstractstatistics.xnat_abstractstatistics_id;


--
-- Name: xnat_abstractsubjectmetadata; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_abstractsubjectmetadata (
    extension integer,
    abstractsubjectmetadata_info integer,
    xnat_abstractsubjectmetadata_id integer NOT NULL
);


ALTER TABLE public.xnat_abstractsubjectmetadata OWNER TO xnat;

--
-- Name: xnat_abstractsubjectmetadata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_abstractsubjectmetadata_history (
    xnat_abstractsubjectmetadata_id integer,
    change_user integer,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    abstractsubjectmetadata_info integer,
    change_date timestamp without time zone,
    xft_version integer,
    extension integer,
    new_row_xnat_abstractsubjectmetadata_id integer
);


ALTER TABLE public.xnat_abstractsubjectmetadata_history OWNER TO xnat;

--
-- Name: xnat_abstractsubjectmetadata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_abstractsubjectmetadata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_abstractsubjectmetadata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_abstractsubjectmetadata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_abstractsubjectmetadata_history_history_id_seq OWNED BY public.xnat_abstractsubjectmetadata_history.history_id;


--
-- Name: xnat_abstractsubjectmetadata_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_abstractsubjectmetadata_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xnat_abstractsubjectmetadata_meta_data OWNER TO xnat;

--
-- Name: xnat_abstractsubjectmetadata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_abstractsubjectmetadata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_abstractsubjectmetadata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_abstractsubjectmetadata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_abstractsubjectmetadata_meta_data_meta_data_id_seq OWNED BY public.xnat_abstractsubjectmetadata_meta_data.meta_data_id;


--
-- Name: xnat_abstractsubjectmetadata_xnat_abstractsubjectmetadata_i_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_abstractsubjectmetadata_xnat_abstractsubjectmetadata_i_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_abstractsubjectmetadata_xnat_abstractsubjectmetadata_i_seq OWNER TO xnat;

--
-- Name: xnat_abstractsubjectmetadata_xnat_abstractsubjectmetadata_i_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_abstractsubjectmetadata_xnat_abstractsubjectmetadata_i_seq OWNED BY public.xnat_abstractsubjectmetadata.xnat_abstractsubjectmetadata_id;


--
-- Name: xnat_addfield; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_addfield (
    addfield text DEFAULT ''::text NOT NULL,
    name character varying(255),
    addfield_info integer,
    xnat_addfield_id integer NOT NULL,
    parameters_addparam_xnat_mrscan_xnat_imagescandata_id integer,
    parameters_addparam_xnat_recons_xnat_reconstructedimagedata_id integer,
    parameters_addparam_xnat_petsca_xnat_imagescandata_id integer,
    parameters_addparam_xnat_imagea_id character varying(255)
);


ALTER TABLE public.xnat_addfield OWNER TO xnat;

--
-- Name: xnat_addfield_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_addfield_history (
    parameters_addparam_xnat_petsca_xnat_imagescandata_id integer,
    change_user integer,
    name character varying(255),
    parameters_addparam_xnat_recons_xnat_reconstructedimagedata_id integer,
    addfield text,
    parameters_addparam_xnat_mrscan_xnat_imagescandata_id integer,
    previous_change_date timestamp without time zone,
    parameters_addparam_xnat_imagea_id character varying(255),
    addfield_info integer,
    xnat_addfield_id integer,
    history_id integer NOT NULL,
    xft_version integer,
    change_date timestamp without time zone,
    new_row_xnat_addfield_id integer
);


ALTER TABLE public.xnat_addfield_history OWNER TO xnat;

--
-- Name: xnat_addfield_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_addfield_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_addfield_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_addfield_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_addfield_history_history_id_seq OWNED BY public.xnat_addfield_history.history_id;


--
-- Name: xnat_addfield_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_addfield_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xnat_addfield_meta_data OWNER TO xnat;

--
-- Name: xnat_addfield_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_addfield_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_addfield_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_addfield_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_addfield_meta_data_meta_data_id_seq OWNED BY public.xnat_addfield_meta_data.meta_data_id;


--
-- Name: xnat_addfield_xnat_addfield_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_addfield_xnat_addfield_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_addfield_xnat_addfield_id_seq OWNER TO xnat;

--
-- Name: xnat_addfield_xnat_addfield_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_addfield_xnat_addfield_id_seq OWNED BY public.xnat_addfield.xnat_addfield_id;


--
-- Name: xnat_algorithm_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_algorithm_history (
    source character varying(255),
    change_user integer,
    name character varying(255),
    algorithm_info integer,
    previous_change_date timestamp without time zone,
    namecode_xnat_dicomcodedvalue_id integer,
    version character varying(255),
    history_id integer NOT NULL,
    xnat_algorithm_id integer,
    family_xnat_dicomcodedvalue_id integer,
    parameters text,
    xft_version integer,
    change_date timestamp without time zone,
    new_row_xnat_algorithm_id integer
);


ALTER TABLE public.xnat_algorithm_history OWNER TO xnat;

--
-- Name: xnat_algorithm_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_algorithm_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_algorithm_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_algorithm_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_algorithm_history_history_id_seq OWNED BY public.xnat_algorithm_history.history_id;


--
-- Name: xnat_algorithm_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_algorithm_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_algorithm_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_algorithm_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_algorithm_meta_data_meta_data_id_seq OWNED BY public.xnat_algorithm_meta_data.meta_data_id;


--
-- Name: xnat_algorithm_xnat_algorithm_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_algorithm_xnat_algorithm_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_algorithm_xnat_algorithm_id_seq OWNER TO xnat;

--
-- Name: xnat_algorithm_xnat_algorithm_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_algorithm_xnat_algorithm_id_seq OWNED BY public.xnat_algorithm.xnat_algorithm_id;


--
-- Name: xnat_computationdata; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_computationdata (
    name character varying(255) DEFAULT ''::character varying NOT NULL,
    value character varying(255) DEFAULT ''::character varying NOT NULL,
    source character varying(255) DEFAULT ''::character varying NOT NULL,
    units character varying(255),
    computationdata_info integer,
    xnat_computationdata_id integer NOT NULL,
    computations_datum_xnat_reconst_xnat_reconstructedimagedata_id integer
);


ALTER TABLE public.xnat_computationdata OWNER TO xnat;

--
-- Name: xnat_computationdata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_computationdata_history (
    source character varying(255),
    change_user integer,
    name character varying(255),
    computationdata_info integer,
    previous_change_date timestamp without time zone,
    xnat_computationdata_id integer,
    computations_datum_xnat_reconst_xnat_reconstructedimagedata_id integer,
    units character varying(255),
    history_id integer NOT NULL,
    value character varying(255),
    xft_version integer,
    change_date timestamp without time zone,
    new_row_xnat_computationdata_id integer
);


ALTER TABLE public.xnat_computationdata_history OWNER TO xnat;

--
-- Name: xnat_computationdata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_computationdata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_computationdata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_computationdata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_computationdata_history_history_id_seq OWNED BY public.xnat_computationdata_history.history_id;


--
-- Name: xnat_computationdata_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_computationdata_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xnat_computationdata_meta_data OWNER TO xnat;

--
-- Name: xnat_computationdata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_computationdata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_computationdata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_computationdata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_computationdata_meta_data_meta_data_id_seq OWNED BY public.xnat_computationdata_meta_data.meta_data_id;


--
-- Name: xnat_computationdata_xnat_computationdata_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_computationdata_xnat_computationdata_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_computationdata_xnat_computationdata_id_seq OWNER TO xnat;

--
-- Name: xnat_computationdata_xnat_computationdata_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_computationdata_xnat_computationdata_id_seq OWNED BY public.xnat_computationdata.xnat_computationdata_id;


--
-- Name: xnat_contrastbolus; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_contrastbolus (
    agent character varying(255),
    route character varying(255),
    volume double precision,
    totaldose double precision,
    flowrate double precision,
    flowduration double precision,
    activeingredient character varying(255),
    concentration double precision,
    contrastbolus_info integer,
    xnat_contrastbolus_id integer NOT NULL
);


ALTER TABLE public.xnat_contrastbolus OWNER TO xnat;

--
-- Name: xnat_contrastbolus_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_contrastbolus_history (
    change_user integer,
    totaldose double precision,
    flowduration double precision,
    previous_change_date timestamp without time zone,
    agent character varying(255),
    concentration double precision,
    flowrate double precision,
    volume double precision,
    contrastbolus_info integer,
    xnat_contrastbolus_id integer,
    history_id integer NOT NULL,
    activeingredient character varying(255),
    route character varying(255),
    xft_version integer,
    change_date timestamp without time zone,
    new_row_xnat_contrastbolus_id integer
);


ALTER TABLE public.xnat_contrastbolus_history OWNER TO xnat;

--
-- Name: xnat_contrastbolus_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_contrastbolus_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_contrastbolus_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_contrastbolus_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_contrastbolus_history_history_id_seq OWNED BY public.xnat_contrastbolus_history.history_id;


--
-- Name: xnat_contrastbolus_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_contrastbolus_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xnat_contrastbolus_meta_data OWNER TO xnat;

--
-- Name: xnat_contrastbolus_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_contrastbolus_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_contrastbolus_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_contrastbolus_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_contrastbolus_meta_data_meta_data_id_seq OWNED BY public.xnat_contrastbolus_meta_data.meta_data_id;


--
-- Name: xnat_contrastbolus_xnat_contrastbolus_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_contrastbolus_xnat_contrastbolus_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_contrastbolus_xnat_contrastbolus_id_seq OWNER TO xnat;

--
-- Name: xnat_contrastbolus_xnat_contrastbolus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_contrastbolus_xnat_contrastbolus_id_seq OWNED BY public.xnat_contrastbolus.xnat_contrastbolus_id;


--
-- Name: xnat_crscandata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_crscandata_history (
    crscandata_info integer,
    xft_version integer,
    xnat_imagescandata_id integer,
    change_user integer,
    change_date timestamp without time zone,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    new_row_xnat_imagescandata_id integer
);


ALTER TABLE public.xnat_crscandata_history OWNER TO xnat;

--
-- Name: xnat_crscandata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_crscandata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_crscandata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_crscandata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_crscandata_history_history_id_seq OWNED BY public.xnat_crscandata_history.history_id;


--
-- Name: xnat_crscandata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_crscandata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_crscandata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_crscandata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_crscandata_meta_data_meta_data_id_seq OWNED BY public.xnat_crscandata_meta_data.meta_data_id;


--
-- Name: xnat_crsessiondata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_crsessiondata_history (
    crsessiondata_info integer,
    xft_version integer,
    change_user integer,
    change_date timestamp without time zone,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    id character varying(255),
    new_row_id character varying(255)
);


ALTER TABLE public.xnat_crsessiondata_history OWNER TO xnat;

--
-- Name: xnat_crsessiondata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_crsessiondata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_crsessiondata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_crsessiondata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_crsessiondata_history_history_id_seq OWNED BY public.xnat_crsessiondata_history.history_id;


--
-- Name: xnat_crsessiondata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_crsessiondata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_crsessiondata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_crsessiondata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_crsessiondata_meta_data_meta_data_id_seq OWNED BY public.xnat_crsessiondata_meta_data.meta_data_id;


--
-- Name: xnat_ctscandata_focalspot; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_ctscandata_focalspot (
    focalspot double precision DEFAULT 0 NOT NULL,
    ctscandata_focalspot_info integer,
    xnat_ctscandata_focalspot_id integer NOT NULL,
    parameters_focalspots_focalspot_xnat_imagescandata_id integer
);


ALTER TABLE public.xnat_ctscandata_focalspot OWNER TO xnat;

--
-- Name: xnat_ctscandata_focalspot_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_ctscandata_focalspot_history (
    xnat_ctscandata_focalspot_id integer,
    change_user integer,
    ctscandata_focalspot_info integer,
    previous_change_date timestamp without time zone,
    parameters_focalspots_focalspot_xnat_imagescandata_id integer,
    history_id integer NOT NULL,
    xft_version integer,
    change_date timestamp without time zone,
    focalspot double precision,
    new_row_xnat_ctscandata_focalspot_id integer
);


ALTER TABLE public.xnat_ctscandata_focalspot_history OWNER TO xnat;

--
-- Name: xnat_ctscandata_focalspot_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_ctscandata_focalspot_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_ctscandata_focalspot_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_ctscandata_focalspot_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_ctscandata_focalspot_history_history_id_seq OWNED BY public.xnat_ctscandata_focalspot_history.history_id;


--
-- Name: xnat_ctscandata_focalspot_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_ctscandata_focalspot_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xnat_ctscandata_focalspot_meta_data OWNER TO xnat;

--
-- Name: xnat_ctscandata_focalspot_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_ctscandata_focalspot_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_ctscandata_focalspot_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_ctscandata_focalspot_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_ctscandata_focalspot_meta_data_meta_data_id_seq OWNED BY public.xnat_ctscandata_focalspot_meta_data.meta_data_id;


--
-- Name: xnat_ctscandata_focalspot_xnat_ctscandata_focalspot_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_ctscandata_focalspot_xnat_ctscandata_focalspot_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_ctscandata_focalspot_xnat_ctscandata_focalspot_id_seq OWNER TO xnat;

--
-- Name: xnat_ctscandata_focalspot_xnat_ctscandata_focalspot_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_ctscandata_focalspot_xnat_ctscandata_focalspot_id_seq OWNED BY public.xnat_ctscandata_focalspot.xnat_ctscandata_focalspot_id;


--
-- Name: xnat_ctscandata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_ctscandata_history (
    parameters_fov_y integer,
    parameters_collimationwidth_total double precision,
    parameters_fov_x integer,
    history_id integer NOT NULL,
    change_date timestamp without time zone,
    parameters_rescale_intercept character varying(255),
    parameters_acquisitionnumber integer,
    parameters_xraytubecurrent double precision,
    dcmvalidation_status integer,
    xnat_imagescandata_id integer,
    parameters_ctdivol double precision,
    parameters_imagetype character varying(255),
    xft_version integer,
    parameters_convolutionkernel character varying(255),
    parameters_tablefeedperrotation double precision,
    parameters_tablespeed double precision,
    parameters_exposure double precision,
    parameters_gantrytilt double precision,
    parameters_contrastbolus_xnat_contrastbolus_id integer,
    parameters_derivation character varying(255),
    parameters_pitchfactor double precision,
    parameters_distancesourcetodetector double precision,
    parameters_rotationdirection character varying(255),
    previous_change_date timestamp without time zone,
    parameters_collimationwidth_single double precision,
    parameters_estimateddosesaving double precision,
    parameters_generatorpower double precision,
    parameters_exposuretime double precision,
    parameters_distancesourcetopatient double precision,
    parameters_estimateddosesaving_modulation character varying(255),
    ctscandata_info integer,
    change_user integer,
    parameters_subjectposition character varying(255),
    dcmvalidation character varying(255),
    parameters_kvp double precision,
    parameters_tableheight double precision,
    parameters_rescale_slope character varying(255),
    parameters_options character varying(255),
    parameters_filter character varying(255),
    parameters_collectiondiameter double precision,
    parameters_voxelres_units character varying(255),
    parameters_voxelres_z double precision,
    parameters_voxelres_y double precision,
    parameters_voxelres_x double precision,
    parameters_orientation character varying(255),
    new_row_xnat_imagescandata_id integer
);


ALTER TABLE public.xnat_ctscandata_history OWNER TO xnat;

--
-- Name: xnat_ctscandata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_ctscandata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_ctscandata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_ctscandata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_ctscandata_history_history_id_seq OWNED BY public.xnat_ctscandata_history.history_id;


--
-- Name: xnat_ctscandata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_ctscandata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_ctscandata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_ctscandata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_ctscandata_meta_data_meta_data_id_seq OWNED BY public.xnat_ctscandata_meta_data.meta_data_id;


--
-- Name: xnat_ctsessiondata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_ctsessiondata_history (
    xft_version integer,
    change_user integer,
    change_date timestamp without time zone,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    ctsessiondata_info integer,
    id character varying(255),
    new_row_id character varying(255)
);


ALTER TABLE public.xnat_ctsessiondata_history OWNER TO xnat;

--
-- Name: xnat_ctsessiondata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_ctsessiondata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_ctsessiondata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_ctsessiondata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_ctsessiondata_history_history_id_seq OWNED BY public.xnat_ctsessiondata_history.history_id;


--
-- Name: xnat_ctsessiondata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_ctsessiondata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_ctsessiondata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_ctsessiondata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_ctsessiondata_meta_data_meta_data_id_seq OWNED BY public.xnat_ctsessiondata_meta_data.meta_data_id;


--
-- Name: xnat_datatypeprotocol; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_datatypeprotocol (
    xnat_abstractprotocol_id integer DEFAULT 0 NOT NULL,
    datatypeprotocol_info integer
);


ALTER TABLE public.xnat_datatypeprotocol OWNER TO xnat;


--
-- Name: xnat_datatypeprotocol_fieldgroups; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_datatypeprotocol_fieldgroups (
    xnat_datatypeprotocol_xnat_abstractprotocol_id integer NOT NULL,
    xnat_fielddefinitiongroup_xnat_fielddefinitiongroup_id integer NOT NULL,
    xnat_datatypeprotocol_fieldgroups_id integer NOT NULL
);


ALTER TABLE public.xnat_datatypeprotocol_fieldgroups OWNER TO xnat;

--
-- Name: xnat_datatypeprotocol_fieldgr_xnat_datatypeprotocol_fieldgr_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_datatypeprotocol_fieldgr_xnat_datatypeprotocol_fieldgr_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_datatypeprotocol_fieldgr_xnat_datatypeprotocol_fieldgr_seq OWNER TO xnat;

--
-- Name: xnat_datatypeprotocol_fieldgr_xnat_datatypeprotocol_fieldgr_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_datatypeprotocol_fieldgr_xnat_datatypeprotocol_fieldgr_seq OWNED BY public.xnat_datatypeprotocol_fieldgroups.xnat_datatypeprotocol_fieldgroups_id;



--
-- Name: xnat_datatypeprotocol_fieldgroups_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_datatypeprotocol_fieldgroups_history (
    xnat_datatypeprotocol_xnat_abstractprotocol_id integer,
    xnat_fielddefinitiongroup_xnat_fielddefinitiongroup_id integer,
    xnat_datatypeprotocol_fieldgroups_id integer,
    history_id integer NOT NULL
);


ALTER TABLE public.xnat_datatypeprotocol_fieldgroups_history OWNER TO xnat;

--
-- Name: xnat_datatypeprotocol_fieldgroups_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_datatypeprotocol_fieldgroups_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_datatypeprotocol_fieldgroups_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_datatypeprotocol_fieldgroups_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_datatypeprotocol_fieldgroups_history_history_id_seq OWNED BY public.xnat_datatypeprotocol_fieldgroups_history.history_id;


--
-- Name: xnat_datatypeprotocol_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_datatypeprotocol_history (
    xnat_abstractprotocol_id integer,
    xft_version integer,
    change_user integer,
    change_date timestamp without time zone,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    datatypeprotocol_info integer,
    new_row_xnat_abstractprotocol_id integer
);


ALTER TABLE public.xnat_datatypeprotocol_history OWNER TO xnat;

--
-- Name: xnat_datatypeprotocol_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_datatypeprotocol_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_datatypeprotocol_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_datatypeprotocol_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_datatypeprotocol_history_history_id_seq OWNED BY public.xnat_datatypeprotocol_history.history_id;


--
-- Name: xnat_datatypeprotocol_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_datatypeprotocol_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xnat_datatypeprotocol_meta_data OWNER TO xnat;

--
-- Name: xnat_datatypeprotocol_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_datatypeprotocol_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_datatypeprotocol_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_datatypeprotocol_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_datatypeprotocol_meta_data_meta_data_id_seq OWNED BY public.xnat_datatypeprotocol_meta_data.meta_data_id;


--
-- Name: xnat_demographicdata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_demographicdata_history (
    dob date,
    height_units character varying(255),
    weight_units character varying(255),
    employment integer,
    xnat_abstractdemographicdata_id integer,
    educationdesc character varying(255),
    race character varying(255),
    gestational_age double precision,
    education integer,
    ethnicity character varying(255),
    change_date timestamp without time zone,
    weight double precision,
    change_user integer,
    xft_version integer,
    ses integer,
    post_menstrual_age double precision,
    age integer,
    gender character varying(255),
    height double precision,
    yob integer,
    history_id integer NOT NULL,
    demographicdata_info integer,
    handedness character varying(255),
    previous_change_date timestamp without time zone,
    birth_weight double precision,
    race6 character varying(255),
    race5 character varying(255),
    race4 character varying(255),
    race3 character varying(255),
    race2 character varying(255),
    new_row_xnat_abstractdemographicdata_id integer
);


ALTER TABLE public.xnat_demographicdata_history OWNER TO xnat;

--
-- Name: xnat_demographicdata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_demographicdata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_demographicdata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_demographicdata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_demographicdata_history_history_id_seq OWNED BY public.xnat_demographicdata_history.history_id;


--
-- Name: xnat_demographicdata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_demographicdata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_demographicdata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_demographicdata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_demographicdata_meta_data_meta_data_id_seq OWNED BY public.xnat_demographicdata_meta_data.meta_data_id;


--
-- Name: xnat_deriveddata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_deriveddata_history (
    change_user integer,
    id character varying(255),
    previous_change_date timestamp without time zone,
    deriveddata_info integer,
    history_id integer NOT NULL,
    xft_version integer,
    change_date timestamp without time zone,
    provenance_prov_process_id integer,
    new_row_id character varying(255)
);


ALTER TABLE public.xnat_deriveddata_history OWNER TO xnat;

--
-- Name: xnat_deriveddata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_deriveddata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_deriveddata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_deriveddata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_deriveddata_history_history_id_seq OWNED BY public.xnat_deriveddata_history.history_id;


--
-- Name: xnat_deriveddata_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_deriveddata_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xnat_deriveddata_meta_data OWNER TO xnat;

--
-- Name: xnat_deriveddata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_deriveddata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_deriveddata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_deriveddata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_deriveddata_meta_data_meta_data_id_seq OWNED BY public.xnat_deriveddata_meta_data.meta_data_id;


--
-- Name: xnat_dicomcodedvalue_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_dicomcodedvalue_history (
    meaning character varying(255),
    change_user integer,
    previous_change_date timestamp without time zone,
    designator character varying(255),
    xnat_dicomcodedvalue_id integer,
    dicomcodedvalue_info integer,
    version character varying(255),
    history_id integer NOT NULL,
    value character varying(255),
    xft_version integer,
    change_date timestamp without time zone,
    new_row_xnat_dicomcodedvalue_id integer
);


ALTER TABLE public.xnat_dicomcodedvalue_history OWNER TO xnat;

--
-- Name: xnat_dicomcodedvalue_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_dicomcodedvalue_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_dicomcodedvalue_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_dicomcodedvalue_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_dicomcodedvalue_history_history_id_seq OWNED BY public.xnat_dicomcodedvalue_history.history_id;


--
-- Name: xnat_dicomcodedvalue_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_dicomcodedvalue_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_dicomcodedvalue_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_dicomcodedvalue_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_dicomcodedvalue_meta_data_meta_data_id_seq OWNED BY public.xnat_dicomcodedvalue_meta_data.meta_data_id;


--
-- Name: xnat_dicomcodedvalue_xnat_dicomcodedvalue_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_dicomcodedvalue_xnat_dicomcodedvalue_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_dicomcodedvalue_xnat_dicomcodedvalue_id_seq OWNER TO xnat;

--
-- Name: xnat_dicomcodedvalue_xnat_dicomcodedvalue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_dicomcodedvalue_xnat_dicomcodedvalue_id_seq OWNED BY public.xnat_dicomcodedvalue.xnat_dicomcodedvalue_id;


--
-- Name: xnat_dicomseries; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_dicomseries (
    xnat_abstractresource_id integer DEFAULT 0 NOT NULL,
    dimensions_x integer,
    dimensions_y integer,
    dimensions_z integer,
    dimensions_volumes integer,
    voxelres_x double precision,
    voxelres_y double precision,
    voxelres_z double precision,
    voxelres_units character varying(255),
    orientation character varying(255),
    format character varying(255),
    description character varying(255),
    content character varying(255),
    cachepath character varying(255),
    uid character varying(255) DEFAULT ''::character varying NOT NULL,
    dicomseries_info integer
);


ALTER TABLE public.xnat_dicomseries OWNER TO xnat;

--
-- Name: xnat_dicomseries_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_dicomseries_history (
    voxelres_z double precision,
    voxelres_y double precision,
    voxelres_x double precision,
    dicomseries_info integer,
    orientation character varying(255),
    xnat_abstractresource_id integer,
    voxelres_units character varying(255),
    uid character varying(255),
    cachepath character varying(255),
    change_date timestamp without time zone,
    change_user integer,
    xft_version integer,
    history_id integer NOT NULL,
    dimensions_z integer,
    dimensions_y integer,
    dimensions_x integer,
    content character varying(255),
    dimensions_volumes integer,
    description character varying(255),
    previous_change_date timestamp without time zone,
    format character varying(255),
    new_row_xnat_abstractresource_id integer
);


ALTER TABLE public.xnat_dicomseries_history OWNER TO xnat;

--
-- Name: xnat_dicomseries_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_dicomseries_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_dicomseries_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_dicomseries_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_dicomseries_history_history_id_seq OWNED BY public.xnat_dicomseries_history.history_id;


--
-- Name: xnat_dicomseries_image; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_dicomseries_image (
    uri character varying(255) DEFAULT ''::character varying NOT NULL,
    sop_instance_uid character varying(255) DEFAULT ''::character varying NOT NULL,
    instance_number integer,
    dicomseries_image_info integer,
    xnat_dicomseries_image_id integer NOT NULL,
    imageset_image_xnat_dicomseries_xnat_abstractresource_id integer
);


ALTER TABLE public.xnat_dicomseries_image OWNER TO xnat;

--
-- Name: xnat_dicomseries_image_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_dicomseries_image_history (
    dicomseries_image_info integer,
    change_user integer,
    xnat_dicomseries_image_id integer,
    uri character varying(255),
    imageset_image_xnat_dicomseries_xnat_abstractresource_id integer,
    previous_change_date timestamp without time zone,
    sop_instance_uid character varying(255),
    history_id integer NOT NULL,
    instance_number integer,
    xft_version integer,
    change_date timestamp without time zone,
    new_row_xnat_dicomseries_image_id integer
);


ALTER TABLE public.xnat_dicomseries_image_history OWNER TO xnat;

--
-- Name: xnat_dicomseries_image_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_dicomseries_image_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_dicomseries_image_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_dicomseries_image_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_dicomseries_image_history_history_id_seq OWNED BY public.xnat_dicomseries_image_history.history_id;


--
-- Name: xnat_dicomseries_image_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_dicomseries_image_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xnat_dicomseries_image_meta_data OWNER TO xnat;

--
-- Name: xnat_dicomseries_image_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_dicomseries_image_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_dicomseries_image_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_dicomseries_image_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_dicomseries_image_meta_data_meta_data_id_seq OWNED BY public.xnat_dicomseries_image_meta_data.meta_data_id;


--
-- Name: xnat_dicomseries_image_xnat_dicomseries_image_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_dicomseries_image_xnat_dicomseries_image_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_dicomseries_image_xnat_dicomseries_image_id_seq OWNER TO xnat;

--
-- Name: xnat_dicomseries_image_xnat_dicomseries_image_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_dicomseries_image_xnat_dicomseries_image_id_seq OWNED BY public.xnat_dicomseries_image.xnat_dicomseries_image_id;


--
-- Name: xnat_dicomseries_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_dicomseries_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xnat_dicomseries_meta_data OWNER TO xnat;

--
-- Name: xnat_dicomseries_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_dicomseries_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_dicomseries_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_dicomseries_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_dicomseries_meta_data_meta_data_id_seq OWNED BY public.xnat_dicomseries_meta_data.meta_data_id;


--
-- Name: xnat_dx3dcraniofacialscandata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_dx3dcraniofacialscandata_history (
    dx3dcraniofacialscandata_info integer,
    xft_version integer,
    xnat_imagescandata_id integer,
    change_user integer,
    change_date timestamp without time zone,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    new_row_xnat_imagescandata_id integer
);


ALTER TABLE public.xnat_dx3dcraniofacialscandata_history OWNER TO xnat;

--
-- Name: xnat_dx3dcraniofacialscandata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_dx3dcraniofacialscandata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_dx3dcraniofacialscandata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_dx3dcraniofacialscandata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_dx3dcraniofacialscandata_history_history_id_seq OWNED BY public.xnat_dx3dcraniofacialscandata_history.history_id;


--
-- Name: xnat_dx3dcraniofacialscandata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_dx3dcraniofacialscandata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_dx3dcraniofacialscandata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_dx3dcraniofacialscandata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_dx3dcraniofacialscandata_meta_data_meta_data_id_seq OWNED BY public.xnat_dx3dcraniofacialscandata_meta_data.meta_data_id;


--
-- Name: xnat_dx3dcraniofacialsessiondata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_dx3dcraniofacialsessiondata_history (
    dx3dcraniofacialsessiondata_info integer,
    xft_version integer,
    change_user integer,
    change_date timestamp without time zone,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    id character varying(255),
    new_row_id character varying(255)
);


ALTER TABLE public.xnat_dx3dcraniofacialsessiondata_history OWNER TO xnat;

--
-- Name: xnat_dx3dcraniofacialsessiondata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_dx3dcraniofacialsessiondata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_dx3dcraniofacialsessiondata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_dx3dcraniofacialsessiondata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_dx3dcraniofacialsessiondata_history_history_id_seq OWNED BY public.xnat_dx3dcraniofacialsessiondata_history.history_id;


--
-- Name: xnat_dx3dcraniofacialsessiondata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_dx3dcraniofacialsessiondata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_dx3dcraniofacialsessiondata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_dx3dcraniofacialsessiondata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_dx3dcraniofacialsessiondata_meta_data_meta_data_id_seq OWNED BY public.xnat_dx3dcraniofacialsessiondata_meta_data.meta_data_id;


--
-- Name: xnat_dxscandata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_dxscandata_history (
    xft_version integer,
    xnat_imagescandata_id integer,
    change_user integer,
    change_date timestamp without time zone,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    dxscandata_info integer,
    new_row_xnat_imagescandata_id integer
);


ALTER TABLE public.xnat_dxscandata_history OWNER TO xnat;

--
-- Name: xnat_dxscandata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_dxscandata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_dxscandata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_dxscandata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_dxscandata_history_history_id_seq OWNED BY public.xnat_dxscandata_history.history_id;


--
-- Name: xnat_dxscandata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_dxscandata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_dxscandata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_dxscandata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_dxscandata_meta_data_meta_data_id_seq OWNED BY public.xnat_dxscandata_meta_data.meta_data_id;


--
-- Name: xnat_dxsessiondata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_dxsessiondata_history (
    dxsessiondata_info integer,
    xft_version integer,
    change_user integer,
    change_date timestamp without time zone,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    id character varying(255),
    new_row_id character varying(255)
);


ALTER TABLE public.xnat_dxsessiondata_history OWNER TO xnat;

--
-- Name: xnat_dxsessiondata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_dxsessiondata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_dxsessiondata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_dxsessiondata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_dxsessiondata_history_history_id_seq OWNED BY public.xnat_dxsessiondata_history.history_id;


--
-- Name: xnat_dxsessiondata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_dxsessiondata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_dxsessiondata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_dxsessiondata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_dxsessiondata_meta_data_meta_data_id_seq OWNED BY public.xnat_dxsessiondata_meta_data.meta_data_id;


--
-- Name: xnat_ecgscandata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_ecgscandata_history (
    ecgscandata_info integer,
    xft_version integer,
    xnat_imagescandata_id integer,
    change_user integer,
    change_date timestamp without time zone,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    new_row_xnat_imagescandata_id integer
);


ALTER TABLE public.xnat_ecgscandata_history OWNER TO xnat;

--
-- Name: xnat_ecgscandata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_ecgscandata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_ecgscandata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_ecgscandata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_ecgscandata_history_history_id_seq OWNED BY public.xnat_ecgscandata_history.history_id;


--
-- Name: xnat_ecgscandata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_ecgscandata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_ecgscandata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_ecgscandata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_ecgscandata_meta_data_meta_data_id_seq OWNED BY public.xnat_ecgscandata_meta_data.meta_data_id;


--
-- Name: xnat_ecgsessiondata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_ecgsessiondata_history (
    xft_version integer,
    change_user integer,
    change_date timestamp without time zone,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    ecgsessiondata_info integer,
    id character varying(255),
    new_row_id character varying(255)
);


ALTER TABLE public.xnat_ecgsessiondata_history OWNER TO xnat;

--
-- Name: xnat_ecgsessiondata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_ecgsessiondata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_ecgsessiondata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_ecgsessiondata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_ecgsessiondata_history_history_id_seq OWNED BY public.xnat_ecgsessiondata_history.history_id;


--
-- Name: xnat_ecgsessiondata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_ecgsessiondata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_ecgsessiondata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_ecgsessiondata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_ecgsessiondata_meta_data_meta_data_id_seq OWNED BY public.xnat_ecgsessiondata_meta_data.meta_data_id;


--
-- Name: xnat_eegscandata_channel; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_eegscandata_channel (
    resolution double precision,
    lowcutoff character varying(255),
    highcutoff character varying(255),
    notch character varying(255),
    name character varying(255),
    eegscandata_channel_info integer,
    xnat_eegscandata_channel_id integer NOT NULL,
    channels_channel_xnat_eegscanda_xnat_imagescandata_id integer
);


ALTER TABLE public.xnat_eegscandata_channel OWNER TO xnat;

--
-- Name: xnat_eegscandata_channel_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_eegscandata_channel_history (
    eegscandata_channel_info integer,
    name character varying(255),
    change_user integer,
    xnat_eegscandata_channel_id integer,
    resolution double precision,
    previous_change_date timestamp without time zone,
    highcutoff character varying(255),
    lowcutoff character varying(255),
    channels_channel_xnat_eegscanda_xnat_imagescandata_id integer,
    history_id integer NOT NULL,
    notch character varying(255),
    xft_version integer,
    change_date timestamp without time zone,
    new_row_xnat_eegscandata_channel_id integer
);


ALTER TABLE public.xnat_eegscandata_channel_history OWNER TO xnat;

--
-- Name: xnat_eegscandata_channel_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_eegscandata_channel_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_eegscandata_channel_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_eegscandata_channel_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_eegscandata_channel_history_history_id_seq OWNED BY public.xnat_eegscandata_channel_history.history_id;


--
-- Name: xnat_eegscandata_channel_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_eegscandata_channel_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xnat_eegscandata_channel_meta_data OWNER TO xnat;

--
-- Name: xnat_eegscandata_channel_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_eegscandata_channel_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_eegscandata_channel_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_eegscandata_channel_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_eegscandata_channel_meta_data_meta_data_id_seq OWNED BY public.xnat_eegscandata_channel_meta_data.meta_data_id;


--
-- Name: xnat_eegscandata_channel_xnat_eegscandata_channel_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_eegscandata_channel_xnat_eegscandata_channel_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_eegscandata_channel_xnat_eegscandata_channel_id_seq OWNER TO xnat;

--
-- Name: xnat_eegscandata_channel_xnat_eegscandata_channel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_eegscandata_channel_xnat_eegscandata_channel_id_seq OWNED BY public.xnat_eegscandata_channel.xnat_eegscandata_channel_id;


--
-- Name: xnat_eegscandata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_eegscandata_history (
    parameters_numberofdatarecords integer,
    change_user integer,
    previous_change_date timestamp without time zone,
    softwarefiltersimpedances_mean double precision,
    xnat_imagescandata_id integer,
    parameters_datarecord_duration double precision,
    history_id integer NOT NULL,
    xft_version integer,
    change_date timestamp without time zone,
    eegscandata_info integer,
    parameters_datarecord_units character varying(255),
    new_row_xnat_imagescandata_id integer
);


ALTER TABLE public.xnat_eegscandata_history OWNER TO xnat;

--
-- Name: xnat_eegscandata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_eegscandata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_eegscandata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_eegscandata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_eegscandata_history_history_id_seq OWNED BY public.xnat_eegscandata_history.history_id;


--
-- Name: xnat_eegscandata_impedance; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_eegscandata_impedance (
    name character varying(255),
    value character varying(255),
    eegscandata_impedance_info integer,
    xnat_eegscandata_impedance_id integer NOT NULL,
    softwarefiltersimpedances_imped_xnat_imagescandata_id integer
);


ALTER TABLE public.xnat_eegscandata_impedance OWNER TO xnat;

--
-- Name: xnat_eegscandata_impedance_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_eegscandata_impedance_history (
    change_user integer,
    name character varying(255),
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    eegscandata_impedance_info integer,
    softwarefiltersimpedances_imped_xnat_imagescandata_id integer,
    value character varying(255),
    xnat_eegscandata_impedance_id integer,
    xft_version integer,
    change_date timestamp without time zone,
    new_row_xnat_eegscandata_impedance_id integer
);


ALTER TABLE public.xnat_eegscandata_impedance_history OWNER TO xnat;

--
-- Name: xnat_eegscandata_impedance_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_eegscandata_impedance_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_eegscandata_impedance_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_eegscandata_impedance_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_eegscandata_impedance_history_history_id_seq OWNED BY public.xnat_eegscandata_impedance_history.history_id;


--
-- Name: xnat_eegscandata_impedance_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_eegscandata_impedance_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xnat_eegscandata_impedance_meta_data OWNER TO xnat;

--
-- Name: xnat_eegscandata_impedance_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_eegscandata_impedance_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_eegscandata_impedance_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_eegscandata_impedance_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_eegscandata_impedance_meta_data_meta_data_id_seq OWNED BY public.xnat_eegscandata_impedance_meta_data.meta_data_id;


--
-- Name: xnat_eegscandata_impedance_xnat_eegscandata_impedance_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_eegscandata_impedance_xnat_eegscandata_impedance_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_eegscandata_impedance_xnat_eegscandata_impedance_id_seq OWNER TO xnat;

--
-- Name: xnat_eegscandata_impedance_xnat_eegscandata_impedance_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_eegscandata_impedance_xnat_eegscandata_impedance_id_seq OWNED BY public.xnat_eegscandata_impedance.xnat_eegscandata_impedance_id;


--
-- Name: xnat_eegscandata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_eegscandata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_eegscandata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_eegscandata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_eegscandata_meta_data_meta_data_id_seq OWNED BY public.xnat_eegscandata_meta_data.meta_data_id;


--
-- Name: xnat_eegsessiondata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_eegsessiondata_history (
    samplinginterval_units character varying(255),
    dataformatversion character varying(255),
    change_user integer,
    id character varying(255),
    numberofchannels integer,
    previous_change_date timestamp without time zone,
    samplinginterval double precision,
    samplingrate_units character varying(255),
    eegsessiondata_info integer,
    history_id integer NOT NULL,
    samplingrate double precision,
    xft_version integer,
    change_date timestamp without time zone,
    new_row_id character varying(255)
);


ALTER TABLE public.xnat_eegsessiondata_history OWNER TO xnat;

--
-- Name: xnat_eegsessiondata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_eegsessiondata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_eegsessiondata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_eegsessiondata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_eegsessiondata_history_history_id_seq OWNED BY public.xnat_eegsessiondata_history.history_id;


--
-- Name: xnat_eegsessiondata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_eegsessiondata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_eegsessiondata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_eegsessiondata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_eegsessiondata_meta_data_meta_data_id_seq OWNED BY public.xnat_eegsessiondata_meta_data.meta_data_id;


--
-- Name: xnat_epsscandata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_epsscandata_history (
    xft_version integer,
    epsscandata_info integer,
    xnat_imagescandata_id integer,
    change_user integer,
    change_date timestamp without time zone,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    new_row_xnat_imagescandata_id integer
);


ALTER TABLE public.xnat_epsscandata_history OWNER TO xnat;

--
-- Name: xnat_epsscandata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_epsscandata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_epsscandata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_epsscandata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_epsscandata_history_history_id_seq OWNED BY public.xnat_epsscandata_history.history_id;


--
-- Name: xnat_epsscandata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_epsscandata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_epsscandata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_epsscandata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_epsscandata_meta_data_meta_data_id_seq OWNED BY public.xnat_epsscandata_meta_data.meta_data_id;


--
-- Name: xnat_epssessiondata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_epssessiondata_history (
    epssessiondata_info integer,
    xft_version integer,
    change_user integer,
    change_date timestamp without time zone,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    id character varying(255),
    new_row_id character varying(255)
);


ALTER TABLE public.xnat_epssessiondata_history OWNER TO xnat;

--
-- Name: xnat_epssessiondata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_epssessiondata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_epssessiondata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_epssessiondata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_epssessiondata_history_history_id_seq OWNED BY public.xnat_epssessiondata_history.history_id;


--
-- Name: xnat_epssessiondata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_epssessiondata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_epssessiondata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_epssessiondata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_epssessiondata_meta_data_meta_data_id_seq OWNED BY public.xnat_epssessiondata_meta_data.meta_data_id;


--
-- Name: xnat_esscandata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_esscandata_history (
    xft_version integer,
    xnat_imagescandata_id integer,
    change_user integer,
    esscandata_info integer,
    change_date timestamp without time zone,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    new_row_xnat_imagescandata_id integer
);


ALTER TABLE public.xnat_esscandata_history OWNER TO xnat;

--
-- Name: xnat_esscandata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_esscandata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_esscandata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_esscandata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_esscandata_history_history_id_seq OWNED BY public.xnat_esscandata_history.history_id;


--
-- Name: xnat_esscandata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_esscandata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_esscandata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_esscandata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_esscandata_meta_data_meta_data_id_seq OWNED BY public.xnat_esscandata_meta_data.meta_data_id;


--
-- Name: xnat_essessiondata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_essessiondata_history (
    essessiondata_info integer,
    xft_version integer,
    change_user integer,
    change_date timestamp without time zone,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    id character varying(255),
    new_row_id character varying(255)
);


ALTER TABLE public.xnat_essessiondata_history OWNER TO xnat;

--
-- Name: xnat_essessiondata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_essessiondata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_essessiondata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_essessiondata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_essessiondata_history_history_id_seq OWNED BY public.xnat_essessiondata_history.history_id;


--
-- Name: xnat_essessiondata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_essessiondata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_essessiondata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_essessiondata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_essessiondata_meta_data_meta_data_id_seq OWNED BY public.xnat_essessiondata_meta_data.meta_data_id;


--
-- Name: xnat_esvscandata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_esvscandata_history (
    xft_version integer,
    esvscandata_info integer,
    xnat_imagescandata_id integer,
    change_user integer,
    change_date timestamp without time zone,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    new_row_xnat_imagescandata_id integer
);


ALTER TABLE public.xnat_esvscandata_history OWNER TO xnat;

--
-- Name: xnat_esvscandata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_esvscandata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_esvscandata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_esvscandata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_esvscandata_history_history_id_seq OWNED BY public.xnat_esvscandata_history.history_id;


--
-- Name: xnat_esvscandata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_esvscandata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_esvscandata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_esvscandata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_esvscandata_meta_data_meta_data_id_seq OWNED BY public.xnat_esvscandata_meta_data.meta_data_id;


--
-- Name: xnat_esvsessiondata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_esvsessiondata_history (
    xft_version integer,
    change_user integer,
    change_date timestamp without time zone,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    esvsessiondata_info integer,
    id character varying(255),
    new_row_id character varying(255)
);


ALTER TABLE public.xnat_esvsessiondata_history OWNER TO xnat;

--
-- Name: xnat_esvsessiondata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_esvsessiondata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_esvsessiondata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_esvsessiondata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_esvsessiondata_history_history_id_seq OWNED BY public.xnat_esvsessiondata_history.history_id;


--
-- Name: xnat_esvsessiondata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_esvsessiondata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_esvsessiondata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_esvsessiondata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_esvsessiondata_meta_data_meta_data_id_seq OWNED BY public.xnat_esvsessiondata_meta_data.meta_data_id;


--
-- Name: xnat_experimentdata_field; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_experimentdata_field (
    field character varying(255),
    name character varying(255),
    experimentdata_field_info integer,
    xnat_experimentdata_field_id integer NOT NULL,
    fields_field_xnat_experimentdat_id character varying(255)
);


ALTER TABLE public.xnat_experimentdata_field OWNER TO xnat;

--
-- Name: xnat_experimentdata_field_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_experimentdata_field_history (
    change_user integer,
    name character varying(255),
    experimentdata_field_info integer,
    previous_change_date timestamp without time zone,
    fields_field_xnat_experimentdat_id character varying(255),
    xnat_experimentdata_field_id integer,
    history_id integer NOT NULL,
    field character varying(255),
    xft_version integer,
    change_date timestamp without time zone,
    new_row_xnat_experimentdata_field_id integer
);


ALTER TABLE public.xnat_experimentdata_field_history OWNER TO xnat;

--
-- Name: xnat_experimentdata_field_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_experimentdata_field_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_experimentdata_field_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_experimentdata_field_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_experimentdata_field_history_history_id_seq OWNED BY public.xnat_experimentdata_field_history.history_id;


--
-- Name: xnat_experimentdata_field_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_experimentdata_field_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xnat_experimentdata_field_meta_data OWNER TO xnat;

--
-- Name: xnat_experimentdata_field_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_experimentdata_field_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_experimentdata_field_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_experimentdata_field_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_experimentdata_field_meta_data_meta_data_id_seq OWNED BY public.xnat_experimentdata_field_meta_data.meta_data_id;


--
-- Name: xnat_experimentdata_field_xnat_experimentdata_field_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_experimentdata_field_xnat_experimentdata_field_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_experimentdata_field_xnat_experimentdata_field_id_seq OWNER TO xnat;

--
-- Name: xnat_experimentdata_field_xnat_experimentdata_field_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_experimentdata_field_xnat_experimentdata_field_id_seq OWNED BY public.xnat_experimentdata_field.xnat_experimentdata_field_id;


--
-- Name: xnat_experimentdata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_experimentdata_history (
    visit_id character varying(255),
    duration character varying(255),
    acquisition_site character varying(255),
    note text,
    project character varying(255),
    version integer,
    delay_ref_expt_id character varying(255),
    "time" time without time zone,
    visit character varying(255),
    label character varying(255),
    change_date timestamp without time zone,
    experimentdata_info integer,
    change_user integer,
    xft_version integer,
    protocol character varying(255),
    validation_xnat_validationdata_id integer,
    id character varying(255),
    history_id integer NOT NULL,
    original character varying(255),
    previous_change_date timestamp without time zone,
    investigator_xnat_investigatordata_id integer,
    date date,
    delay integer,
    extension integer,
    new_row_id character varying(255)
);


ALTER TABLE public.xnat_experimentdata_history OWNER TO xnat;

--
-- Name: xnat_experimentdata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_experimentdata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_experimentdata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_experimentdata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_experimentdata_history_history_id_seq OWNED BY public.xnat_experimentdata_history.history_id;


--
-- Name: xnat_experimentdata_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_experimentdata_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xnat_experimentdata_meta_data OWNER TO xnat;

--
-- Name: xnat_experimentdata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_experimentdata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_experimentdata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_experimentdata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_experimentdata_meta_data_meta_data_id_seq OWNED BY public.xnat_experimentdata_meta_data.meta_data_id;



--
-- Name: xnat_experimentdata_resource; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_experimentdata_resource (
    xnat_experimentdata_id character varying NOT NULL,
    xnat_abstractresource_xnat_abstractresource_id integer NOT NULL,
    xnat_experimentdata_resource_id integer NOT NULL
);


ALTER TABLE public.xnat_experimentdata_resource OWNER TO xnat;


--
-- Name: xnat_experimentdata_resource_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_experimentdata_resource_history (
    xnat_experimentdata_id character varying,
    xnat_abstractresource_xnat_abstractresource_id integer,
    xnat_experimentdata_resource_id integer,
    history_id integer NOT NULL
);


ALTER TABLE public.xnat_experimentdata_resource_history OWNER TO xnat;

--
-- Name: xnat_experimentdata_resource_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_experimentdata_resource_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_experimentdata_resource_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_experimentdata_resource_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_experimentdata_resource_history_history_id_seq OWNED BY public.xnat_experimentdata_resource_history.history_id;


--
-- Name: xnat_experimentdata_resource_xnat_experimentdata_resource_i_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_experimentdata_resource_xnat_experimentdata_resource_i_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_experimentdata_resource_xnat_experimentdata_resource_i_seq OWNER TO xnat;

--
-- Name: xnat_experimentdata_resource_xnat_experimentdata_resource_i_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_experimentdata_resource_xnat_experimentdata_resource_i_seq OWNED BY public.xnat_experimentdata_resource.xnat_experimentdata_resource_id;


--
-- Name: xnat_experimentdata_share_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_experimentdata_share_history (
    change_user integer,
    previous_change_date timestamp without time zone,
    experimentdata_share_info integer,
    history_id integer NOT NULL,
    sharing_share_xnat_experimentda_id character varying(255),
    xnat_experimentdata_share_id integer,
    visit character varying(255),
    label character varying(255),
    project character varying(255),
    share character varying(255),
    xft_version integer,
    protocol character varying(255),
    change_date timestamp without time zone,
    new_row_xnat_experimentdata_share_id integer
);


ALTER TABLE public.xnat_experimentdata_share_history OWNER TO xnat;

--
-- Name: xnat_experimentdata_share_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_experimentdata_share_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_experimentdata_share_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_experimentdata_share_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_experimentdata_share_history_history_id_seq OWNED BY public.xnat_experimentdata_share_history.history_id;


--
-- Name: xnat_experimentdata_share_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_experimentdata_share_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xnat_experimentdata_share_meta_data OWNER TO xnat;

--
-- Name: xnat_experimentdata_share_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_experimentdata_share_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_experimentdata_share_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_experimentdata_share_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_experimentdata_share_meta_data_meta_data_id_seq OWNED BY public.xnat_experimentdata_share_meta_data.meta_data_id;


--
-- Name: xnat_experimentdata_share_xnat_experimentdata_share_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_experimentdata_share_xnat_experimentdata_share_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_experimentdata_share_xnat_experimentdata_share_id_seq OWNER TO xnat;

--
-- Name: xnat_experimentdata_share_xnat_experimentdata_share_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_experimentdata_share_xnat_experimentdata_share_id_seq OWNED BY public.xnat_experimentdata_share.xnat_experimentdata_share_id;


--
-- Name: xnat_fielddefinitiongroup_field; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_fielddefinitiongroup_field (
    name text DEFAULT ''::text NOT NULL,
    type character varying(255),
    datatype character varying(255),
    required integer,
    sequence integer,
    xmlpath text,
    _group character varying(255),
    fielddefinitiongroup_field_info integer,
    xnat_fielddefinitiongroup_field_id integer NOT NULL,
    fields_field_xnat_fielddefiniti_xnat_fielddefinitiongroup_id integer
);


ALTER TABLE public.xnat_fielddefinitiongroup_field OWNER TO xnat;

--
-- Name: xnat_fielddefinitiongroup_fie_xnat_fielddefinitiongroup_fi_seq1; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_fielddefinitiongroup_fie_xnat_fielddefinitiongroup_fi_seq1
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_fielddefinitiongroup_fie_xnat_fielddefinitiongroup_fi_seq1 OWNER TO xnat;

--
-- Name: xnat_fielddefinitiongroup_fie_xnat_fielddefinitiongroup_fi_seq1; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_fielddefinitiongroup_fie_xnat_fielddefinitiongroup_fi_seq1 OWNED BY public.xnat_fielddefinitiongroup_field.xnat_fielddefinitiongroup_field_id;


--
-- Name: xnat_fielddefinitiongroup_field_possiblevalue; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_fielddefinitiongroup_field_possiblevalue (
    possiblevalue character varying(255),
    display character varying(255),
    fielddefinitiongroup_field_possiblevalue_info integer,
    xnat_fielddefinitiongroup_field_possiblevalue_id integer NOT NULL,
    possiblevalues_possiblevalue_xn_xnat_fielddefinitiongroup_field integer
);


ALTER TABLE public.xnat_fielddefinitiongroup_field_possiblevalue OWNER TO xnat;

--
-- Name: xnat_fielddefinitiongroup_fie_xnat_fielddefinitiongroup_fie_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_fielddefinitiongroup_fie_xnat_fielddefinitiongroup_fie_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_fielddefinitiongroup_fie_xnat_fielddefinitiongroup_fie_seq OWNER TO xnat;

--
-- Name: xnat_fielddefinitiongroup_fie_xnat_fielddefinitiongroup_fie_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_fielddefinitiongroup_fie_xnat_fielddefinitiongroup_fie_seq OWNED BY public.xnat_fielddefinitiongroup_field_possiblevalue.xnat_fielddefinitiongroup_field_possiblevalue_id;


--
-- Name: xnat_fielddefinitiongroup_field_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_fielddefinitiongroup_field_history (
    _group character varying(255),
    change_user integer,
    name text,
    xmlpath text,
    fielddefinitiongroup_field_info integer,
    sequence integer,
    previous_change_date timestamp without time zone,
    xnat_fielddefinitiongroup_field_id integer,
    datatype character varying(255),
    required integer,
    fields_field_xnat_fielddefiniti_xnat_fielddefinitiongroup_id integer,
    history_id integer NOT NULL,
    type character varying(255),
    xft_version integer,
    change_date timestamp without time zone,
    new_row_xnat_fielddefinitiongroup_field_id integer
);


ALTER TABLE public.xnat_fielddefinitiongroup_field_history OWNER TO xnat;

--
-- Name: xnat_fielddefinitiongroup_field_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_fielddefinitiongroup_field_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_fielddefinitiongroup_field_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_fielddefinitiongroup_field_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_fielddefinitiongroup_field_history_history_id_seq OWNED BY public.xnat_fielddefinitiongroup_field_history.history_id;


--
-- Name: xnat_fielddefinitiongroup_field_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_fielddefinitiongroup_field_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xnat_fielddefinitiongroup_field_meta_data OWNER TO xnat;

--
-- Name: xnat_fielddefinitiongroup_field_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_fielddefinitiongroup_field_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_fielddefinitiongroup_field_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_fielddefinitiongroup_field_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_fielddefinitiongroup_field_meta_data_meta_data_id_seq OWNED BY public.xnat_fielddefinitiongroup_field_meta_data.meta_data_id;


--
-- Name: xnat_fielddefinitiongroup_field_possiblevalue_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_fielddefinitiongroup_field_possiblevalue_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xnat_fielddefinitiongroup_field_possiblevalue_meta_data OWNER TO xnat;

--
-- Name: xnat_fielddefinitiongroup_field_possiblevalue__meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_fielddefinitiongroup_field_possiblevalue__meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_fielddefinitiongroup_field_possiblevalue__meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_fielddefinitiongroup_field_possiblevalue__meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_fielddefinitiongroup_field_possiblevalue__meta_data_id_seq OWNED BY public.xnat_fielddefinitiongroup_field_possiblevalue_meta_data.meta_data_id;


--
-- Name: xnat_fielddefinitiongroup_field_possiblevalue_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_fielddefinitiongroup_field_possiblevalue_history (
    change_user integer,
    possiblevalue character varying(255),
    fielddefinitiongroup_field_possiblevalue_info integer,
    xnat_fielddefinitiongroup_field_possiblevalue_id integer,
    previous_change_date timestamp without time zone,
    possiblevalues_possiblevalue_xn_xnat_fielddefinitiongroup_field integer,
    display character varying(255),
    history_id integer NOT NULL,
    xft_version integer,
    change_date timestamp without time zone,
    new_row_xnat_fielddefinitiongroup_field_possiblevalue_id integer
);


ALTER TABLE public.xnat_fielddefinitiongroup_field_possiblevalue_history OWNER TO xnat;

--
-- Name: xnat_fielddefinitiongroup_field_possiblevalue_hi_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_fielddefinitiongroup_field_possiblevalue_hi_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_fielddefinitiongroup_field_possiblevalue_hi_history_id_seq OWNER TO xnat;

--
-- Name: xnat_fielddefinitiongroup_field_possiblevalue_hi_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_fielddefinitiongroup_field_possiblevalue_hi_history_id_seq OWNED BY public.xnat_fielddefinitiongroup_field_possiblevalue_history.history_id;


--
-- Name: xnat_fielddefinitiongroup_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_fielddefinitiongroup_history (
    xnat_fielddefinitiongroup_id integer,
    project_specific integer,
    change_user integer,
    id character varying(255),
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    data_type character varying(255),
    description text,
    fielddefinitiongroup_info integer,
    xft_version integer,
    change_date timestamp without time zone,
    shareable integer,
    new_row_xnat_fielddefinitiongroup_id integer
);


ALTER TABLE public.xnat_fielddefinitiongroup_history OWNER TO xnat;

--
-- Name: xnat_fielddefinitiongroup_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_fielddefinitiongroup_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_fielddefinitiongroup_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_fielddefinitiongroup_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_fielddefinitiongroup_history_history_id_seq OWNED BY public.xnat_fielddefinitiongroup_history.history_id;


--
-- Name: xnat_fielddefinitiongroup_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_fielddefinitiongroup_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_fielddefinitiongroup_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_fielddefinitiongroup_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_fielddefinitiongroup_meta_data_meta_data_id_seq OWNED BY public.xnat_fielddefinitiongroup_meta_data.meta_data_id;


--
-- Name: xnat_fielddefinitiongroup_xnat_fielddefinitiongroup_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_fielddefinitiongroup_xnat_fielddefinitiongroup_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_fielddefinitiongroup_xnat_fielddefinitiongroup_id_seq OWNER TO xnat;

--
-- Name: xnat_fielddefinitiongroup_xnat_fielddefinitiongroup_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_fielddefinitiongroup_xnat_fielddefinitiongroup_id_seq OWNED BY public.xnat_fielddefinitiongroup.xnat_fielddefinitiongroup_id;


--
-- Name: xnat_genericdata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_genericdata_history (
    genericdata_info integer,
    xft_version integer,
    change_user integer,
    change_date timestamp without time zone,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    id character varying(255),
    new_row_id character varying(255)
);


ALTER TABLE public.xnat_genericdata_history OWNER TO xnat;

--
-- Name: xnat_genericdata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_genericdata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_genericdata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_genericdata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_genericdata_history_history_id_seq OWNED BY public.xnat_genericdata_history.history_id;


--
-- Name: xnat_genericdata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_genericdata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_genericdata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_genericdata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_genericdata_meta_data_meta_data_id_seq OWNED BY public.xnat_genericdata_meta_data.meta_data_id;


--
-- Name: xnat_gmscandata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_gmscandata_history (
    gmscandata_info integer,
    xft_version integer,
    xnat_imagescandata_id integer,
    change_user integer,
    change_date timestamp without time zone,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    new_row_xnat_imagescandata_id integer
);


ALTER TABLE public.xnat_gmscandata_history OWNER TO xnat;

--
-- Name: xnat_gmscandata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_gmscandata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_gmscandata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_gmscandata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_gmscandata_history_history_id_seq OWNED BY public.xnat_gmscandata_history.history_id;


--
-- Name: xnat_gmscandata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_gmscandata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_gmscandata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_gmscandata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_gmscandata_meta_data_meta_data_id_seq OWNED BY public.xnat_gmscandata_meta_data.meta_data_id;


--
-- Name: xnat_gmsessiondata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_gmsessiondata_history (
    gmsessiondata_info integer,
    xft_version integer,
    change_user integer,
    change_date timestamp without time zone,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    id character varying(255),
    new_row_id character varying(255)
);


ALTER TABLE public.xnat_gmsessiondata_history OWNER TO xnat;

--
-- Name: xnat_gmsessiondata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_gmsessiondata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_gmsessiondata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_gmsessiondata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_gmsessiondata_history_history_id_seq OWNED BY public.xnat_gmsessiondata_history.history_id;


--
-- Name: xnat_gmsessiondata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_gmsessiondata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_gmsessiondata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_gmsessiondata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_gmsessiondata_meta_data_meta_data_id_seq OWNED BY public.xnat_gmsessiondata_meta_data.meta_data_id;


--
-- Name: xnat_gmvscandata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_gmvscandata_history (
    gmvscandata_info integer,
    xft_version integer,
    xnat_imagescandata_id integer,
    change_user integer,
    change_date timestamp without time zone,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    new_row_xnat_imagescandata_id integer
);


ALTER TABLE public.xnat_gmvscandata_history OWNER TO xnat;

--
-- Name: xnat_gmvscandata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_gmvscandata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_gmvscandata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_gmvscandata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_gmvscandata_history_history_id_seq OWNED BY public.xnat_gmvscandata_history.history_id;


--
-- Name: xnat_gmvscandata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_gmvscandata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_gmvscandata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_gmvscandata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_gmvscandata_meta_data_meta_data_id_seq OWNED BY public.xnat_gmvscandata_meta_data.meta_data_id;


--
-- Name: xnat_gmvsessiondata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_gmvsessiondata_history (
    xft_version integer,
    gmvsessiondata_info integer,
    change_user integer,
    change_date timestamp without time zone,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    id character varying(255),
    new_row_id character varying(255)
);


ALTER TABLE public.xnat_gmvsessiondata_history OWNER TO xnat;

--
-- Name: xnat_gmvsessiondata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_gmvsessiondata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_gmvsessiondata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_gmvsessiondata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_gmvsessiondata_history_history_id_seq OWNED BY public.xnat_gmvsessiondata_history.history_id;


--
-- Name: xnat_gmvsessiondata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_gmvsessiondata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_gmvsessiondata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_gmvsessiondata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_gmvsessiondata_meta_data_meta_data_id_seq OWNED BY public.xnat_gmvsessiondata_meta_data.meta_data_id;


--
-- Name: xnat_hdscandata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_hdscandata_history (
    hdscandata_info integer,
    xft_version integer,
    xnat_imagescandata_id integer,
    change_user integer,
    change_date timestamp without time zone,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    new_row_xnat_imagescandata_id integer
);


ALTER TABLE public.xnat_hdscandata_history OWNER TO xnat;

--
-- Name: xnat_hdscandata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_hdscandata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_hdscandata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_hdscandata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_hdscandata_history_history_id_seq OWNED BY public.xnat_hdscandata_history.history_id;


--
-- Name: xnat_hdscandata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_hdscandata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_hdscandata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_hdscandata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_hdscandata_meta_data_meta_data_id_seq OWNED BY public.xnat_hdscandata_meta_data.meta_data_id;


--
-- Name: xnat_hdsessiondata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_hdsessiondata_history (
    xft_version integer,
    change_user integer,
    change_date timestamp without time zone,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    hdsessiondata_info integer,
    id character varying(255),
    new_row_id character varying(255)
);


ALTER TABLE public.xnat_hdsessiondata_history OWNER TO xnat;

--
-- Name: xnat_hdsessiondata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_hdsessiondata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_hdsessiondata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_hdsessiondata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_hdsessiondata_history_history_id_seq OWNED BY public.xnat_hdsessiondata_history.history_id;


--
-- Name: xnat_hdsessiondata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_hdsessiondata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_hdsessiondata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_hdsessiondata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_hdsessiondata_meta_data_meta_data_id_seq OWNED BY public.xnat_hdsessiondata_meta_data.meta_data_id;


--
-- Name: xnat_imageassessordata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_imageassessordata_history (
    change_user integer,
    id character varying(255),
    imagesession_id character varying(255),
    previous_change_date timestamp without time zone,
    imageassessordata_info integer,
    history_id integer NOT NULL,
    xft_version integer,
    change_date timestamp without time zone,
    new_row_id character varying(255)
);


ALTER TABLE public.xnat_imageassessordata_history OWNER TO xnat;

--
-- Name: xnat_imageassessordata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_imageassessordata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_imageassessordata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_imageassessordata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_imageassessordata_history_history_id_seq OWNED BY public.xnat_imageassessordata_history.history_id;


--
-- Name: xnat_imageassessordata_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_imageassessordata_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xnat_imageassessordata_meta_data OWNER TO xnat;

--
-- Name: xnat_imageassessordata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_imageassessordata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_imageassessordata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_imageassessordata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_imageassessordata_meta_data_meta_data_id_seq OWNED BY public.xnat_imageassessordata_meta_data.meta_data_id;


--
-- Name: xnat_imageresource; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_imageresource (
    xnat_abstractresource_id integer DEFAULT 0 NOT NULL,
    dimensions_x integer,
    dimensions_y integer,
    dimensions_z integer,
    dimensions_volumes integer,
    voxelres_x double precision,
    voxelres_y double precision,
    voxelres_z double precision,
    voxelres_units character varying(255),
    orientation character varying(255),
    imageresource_info integer
);


ALTER TABLE public.xnat_imageresource OWNER TO xnat;

--
-- Name: xnat_imageresource_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_imageresource_history (
    imageresource_info integer,
    change_user integer,
    orientation character varying(255),
    voxelres_z double precision,
    voxelres_y double precision,
    previous_change_date timestamp without time zone,
    voxelres_x double precision,
    voxelres_units character varying(255),
    dimensions_z integer,
    history_id integer NOT NULL,
    dimensions_y integer,
    dimensions_x integer,
    xnat_abstractresource_id integer,
    dimensions_volumes integer,
    xft_version integer,
    change_date timestamp without time zone,
    new_row_xnat_abstractresource_id integer
);


ALTER TABLE public.xnat_imageresource_history OWNER TO xnat;

--
-- Name: xnat_imageresource_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_imageresource_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_imageresource_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_imageresource_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_imageresource_history_history_id_seq OWNED BY public.xnat_imageresource_history.history_id;


--
-- Name: xnat_imageresource_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_imageresource_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xnat_imageresource_meta_data OWNER TO xnat;

--
-- Name: xnat_imageresource_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_imageresource_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_imageresource_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_imageresource_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_imageresource_meta_data_meta_data_id_seq OWNED BY public.xnat_imageresource_meta_data.meta_data_id;


--
-- Name: xnat_imageresourceseries; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_imageresourceseries (
    xnat_abstractresource_id integer DEFAULT 0 NOT NULL,
    dimensions_x integer,
    dimensions_y integer,
    dimensions_z integer,
    dimensions_volumes integer,
    voxelres_x double precision,
    voxelres_y double precision,
    voxelres_z double precision,
    voxelres_units character varying(255),
    orientation character varying(255),
    imageresourceseries_info integer
);


ALTER TABLE public.xnat_imageresourceseries OWNER TO xnat;

--
-- Name: xnat_imageresourceseries_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_imageresourceseries_history (
    change_user integer,
    orientation character varying(255),
    voxelres_z double precision,
    voxelres_y double precision,
    previous_change_date timestamp without time zone,
    voxelres_x double precision,
    voxelres_units character varying(255),
    dimensions_z integer,
    history_id integer NOT NULL,
    dimensions_y integer,
    imageresourceseries_info integer,
    dimensions_x integer,
    xnat_abstractresource_id integer,
    dimensions_volumes integer,
    xft_version integer,
    change_date timestamp without time zone,
    new_row_xnat_abstractresource_id integer
);


ALTER TABLE public.xnat_imageresourceseries_history OWNER TO xnat;

--
-- Name: xnat_imageresourceseries_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_imageresourceseries_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_imageresourceseries_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_imageresourceseries_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_imageresourceseries_history_history_id_seq OWNED BY public.xnat_imageresourceseries_history.history_id;


--
-- Name: xnat_imageresourceseries_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_imageresourceseries_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xnat_imageresourceseries_meta_data OWNER TO xnat;

--
-- Name: xnat_imageresourceseries_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_imageresourceseries_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_imageresourceseries_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_imageresourceseries_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_imageresourceseries_meta_data_meta_data_id_seq OWNED BY public.xnat_imageresourceseries_meta_data.meta_data_id;


--
-- Name: xnat_imagescandata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_imagescandata_history (
    note character varying(255),
    project character varying(255),
    start_date date,
    image_session_id character varying(255),
    type character varying(255),
    scanner character varying(255),
    imagescandata_info integer,
    uid character varying(255),
    starttime time without time zone,
    series_description character varying(255),
    operator character varying(255),
    change_date timestamp without time zone,
    scanner_manufacturer character varying(255),
    frames integer,
    quality character varying(255),
    xnat_imagescandata_id integer,
    change_user integer,
    xft_version integer,
    scanner_softwareversion character varying(255),
    validation_xnat_validationdata_id integer,
    id character varying(255),
    history_id integer NOT NULL,
    previous_change_date timestamp without time zone,
    condition character varying(255),
    modality character varying(255),
    documentation text,
    series_class character varying(255),
    scanner_model character varying(255),
    extension integer,
    new_row_xnat_imagescandata_id integer
);


ALTER TABLE public.xnat_imagescandata_history OWNER TO xnat;

--
-- Name: xnat_imagescandata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_imagescandata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_imagescandata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_imagescandata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_imagescandata_history_history_id_seq OWNED BY public.xnat_imagescandata_history.history_id;


--
-- Name: xnat_imagescandata_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_imagescandata_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xnat_imagescandata_meta_data OWNER TO xnat;

--
-- Name: xnat_imagescandata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_imagescandata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_imagescandata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_imagescandata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_imagescandata_meta_data_meta_data_id_seq OWNED BY public.xnat_imagescandata_meta_data.meta_data_id;


--
-- Name: xnat_imagescandata_share; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_imagescandata_share (
    share character varying(255),
    label character varying(255),
    project character varying(255),
    imagescandata_share_info integer,
    xnat_imagescandata_share_id integer NOT NULL,
    sharing_share_xnat_imagescandat_xnat_imagescandata_id integer
);


ALTER TABLE public.xnat_imagescandata_share OWNER TO xnat;

--
-- Name: xnat_imagescandata_share_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_imagescandata_share_history (
    change_user integer,
    previous_change_date timestamp without time zone,
    xnat_imagescandata_share_id integer,
    sharing_share_xnat_imagescandat_xnat_imagescandata_id integer,
    history_id integer NOT NULL,
    label character varying(255),
    project character varying(255),
    imagescandata_share_info integer,
    share character varying(255),
    xft_version integer,
    change_date timestamp without time zone,
    new_row_xnat_imagescandata_share_id integer
);


ALTER TABLE public.xnat_imagescandata_share_history OWNER TO xnat;

--
-- Name: xnat_imagescandata_share_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_imagescandata_share_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_imagescandata_share_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_imagescandata_share_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_imagescandata_share_history_history_id_seq OWNED BY public.xnat_imagescandata_share_history.history_id;


--
-- Name: xnat_imagescandata_share_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_imagescandata_share_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xnat_imagescandata_share_meta_data OWNER TO xnat;

--
-- Name: xnat_imagescandata_share_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_imagescandata_share_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_imagescandata_share_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_imagescandata_share_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_imagescandata_share_meta_data_meta_data_id_seq OWNED BY public.xnat_imagescandata_share_meta_data.meta_data_id;


--
-- Name: xnat_imagescandata_share_xnat_imagescandata_share_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_imagescandata_share_xnat_imagescandata_share_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_imagescandata_share_xnat_imagescandata_share_id_seq OWNER TO xnat;

--
-- Name: xnat_imagescandata_share_xnat_imagescandata_share_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_imagescandata_share_xnat_imagescandata_share_id_seq OWNED BY public.xnat_imagescandata_share.xnat_imagescandata_share_id;


--
-- Name: xnat_imagescandata_xnat_imagescandata_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_imagescandata_xnat_imagescandata_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_imagescandata_xnat_imagescandata_id_seq OWNER TO xnat;

--
-- Name: xnat_imagescandata_xnat_imagescandata_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_imagescandata_xnat_imagescandata_id_seq OWNED BY public.xnat_imagescandata.xnat_imagescandata_id;


--
-- Name: xnat_imagesessiondata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_imagesessiondata_history (
    session_type character varying(255),
    dcmpatientbirthdate date,
    study_id character varying(255),
    scanner character varying(255),
    dcmpatientweight double precision,
    uid character varying(255),
    dcmaccessionnumber character varying(255),
    operator character varying(255),
    dcmpatientname character varying(255),
    prearchivepath character varying(255),
    change_date timestamp without time zone,
    scanner_manufacturer character varying(255),
    dcmpatientid character varying(255),
    change_user integer,
    xft_version integer,
    id character varying(255),
    history_id integer NOT NULL,
    previous_change_date timestamp without time zone,
    modality character varying(255),
    imagesessiondata_info integer,
    scanner_model character varying(255),
    new_row_id character varying(255)
);


ALTER TABLE public.xnat_imagesessiondata_history OWNER TO xnat;

--
-- Name: xnat_imagesessiondata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_imagesessiondata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_imagesessiondata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_imagesessiondata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_imagesessiondata_history_history_id_seq OWNED BY public.xnat_imagesessiondata_history.history_id;


--
-- Name: xnat_imagesessiondata_meta_data; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_imagesessiondata_meta_data (
    xft_version character varying(255),
    last_modified timestamp without time zone,
    status character varying(255),
    activation_date timestamp without time zone,
    row_last_modified timestamp without time zone,
    insert_date timestamp without time zone,
    activation_user_xdat_user_id integer,
    insert_user_xdat_user_id integer,
    origin character varying(255),
    modified integer,
    shareable integer,
    meta_data_id integer NOT NULL
);


ALTER TABLE public.xnat_imagesessiondata_meta_data OWNER TO xnat;

--
-- Name: xnat_imagesessiondata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_imagesessiondata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_imagesessiondata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_imagesessiondata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_imagesessiondata_meta_data_meta_data_id_seq OWNED BY public.xnat_imagesessiondata_meta_data.meta_data_id;


--
-- Name: xnat_investigatordata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_investigatordata_history (
    investigatordata_info integer,
    change_user integer,
    id character varying(255),
    institution character varying(255),
    previous_change_date timestamp without time zone,
    department character varying(128),
    xnat_investigatordata_id integer,
    firstname character varying(25),
    lastname character varying(25),
    phone character varying(25),
    email character varying(64),
    history_id integer NOT NULL,
    title character varying(10),
    xft_version integer,
    change_date timestamp without time zone,
    new_row_xnat_investigatordata_id integer
);


ALTER TABLE public.xnat_investigatordata_history OWNER TO xnat;

--
-- Name: xnat_investigatordata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_investigatordata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_investigatordata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_investigatordata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_investigatordata_history_history_id_seq OWNED BY public.xnat_investigatordata_history.history_id;


--
-- Name: xnat_investigatordata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_investigatordata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_investigatordata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_investigatordata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_investigatordata_meta_data_meta_data_id_seq OWNED BY public.xnat_investigatordata_meta_data.meta_data_id;


--
-- Name: xnat_investigatordata_xnat_investigatordata_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_investigatordata_xnat_investigatordata_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_investigatordata_xnat_investigatordata_id_seq OWNER TO xnat;

--
-- Name: xnat_investigatordata_xnat_investigatordata_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_investigatordata_xnat_investigatordata_id_seq OWNED BY public.xnat_investigatordata.xnat_investigatordata_id;


--
-- Name: xnat_ioscandata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_ioscandata_history (
    xft_version integer,
    ioscandata_info integer,
    xnat_imagescandata_id integer,
    change_user integer,
    change_date timestamp without time zone,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    new_row_xnat_imagescandata_id integer
);


ALTER TABLE public.xnat_ioscandata_history OWNER TO xnat;

--
-- Name: xnat_ioscandata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_ioscandata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_ioscandata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_ioscandata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_ioscandata_history_history_id_seq OWNED BY public.xnat_ioscandata_history.history_id;


--
-- Name: xnat_ioscandata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_ioscandata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_ioscandata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_ioscandata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_ioscandata_meta_data_meta_data_id_seq OWNED BY public.xnat_ioscandata_meta_data.meta_data_id;


--
-- Name: xnat_iosessiondata_history; Type: TABLE; Schema: public; Owner: xnat
--

CREATE TABLE public.xnat_iosessiondata_history (
    iosessiondata_info integer,
    xft_version integer,
    change_user integer,
    change_date timestamp without time zone,
    previous_change_date timestamp without time zone,
    history_id integer NOT NULL,
    id character varying(255),
    new_row_id character varying(255)
);


ALTER TABLE public.xnat_iosessiondata_history OWNER TO xnat;

--
-- Name: xnat_iosessiondata_history_history_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_iosessiondata_history_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_iosessiondata_history_history_id_seq OWNER TO xnat;

--
-- Name: xnat_iosessiondata_history_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_iosessiondata_history_history_id_seq OWNED BY public.xnat_iosessiondata_history.history_id;


--
-- Name: xnat_iosessiondata_meta_data_meta_data_id_seq; Type: SEQUENCE; Schema: public; Owner: xnat
--

CREATE SEQUENCE public.xnat_iosessiondata_meta_data_meta_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.xnat_iosessiondata_meta_data_meta_data_id_seq OWNER TO xnat;

--
-- Name: xnat_iosessiondata_meta_data_meta_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: xnat
--

ALTER SEQUENCE public.xnat_iosessiondata_meta_data_meta_data_id_seq OWNED BY public.xnat_iosessiondata_meta_data.meta_data_id;


--
