public.metadata_provider.sql
No OneTemporary
Actions

Size

2 KB

Subscribers

None

public.metadata_provider.sql
View Options

	--
	-- PostgreSQL database dump
	--

	-- Dumped from database version 10.1
	-- Dumped by pg_dump version 10.2 (Debian 10.2-1.pgdg+1)

	SET statement_timeout = 0;
	SET lock_timeout = 0;
	SET idle_in_transaction_session_timeout = 0;
	SET client_encoding = 'UTF8';
	SET standard_conforming_strings = on;
	SET check_function_bodies = false;
	SET client_min_messages = warning;
	SET row_security = off;

	SET search_path = public, pg_catalog;

	SET default_tablespace = '';

	SET default_with_oids = false;

	--
	-- Name: metadata_provider; Type: TABLE; Schema: public; Owner: -
	--

	CREATE TABLE metadata_provider (
	id integer NOT NULL,
	provider_name text NOT NULL,
	provider_type text NOT NULL,
	provider_url text,
	metadata jsonb
	);


	--
	-- Name: TABLE metadata_provider; Type: COMMENT; Schema: public; Owner: -
	--

	COMMENT ON TABLE metadata_provider IS 'Metadata provider information';


	--
	-- Name: COLUMN metadata_provider.id; Type: COMMENT; Schema: public; Owner: -
	--

	COMMENT ON COLUMN metadata_provider.id IS 'Provider''s identifier';


	--
	-- Name: COLUMN metadata_provider.provider_name; Type: COMMENT; Schema: public; Owner: -
	--

	COMMENT ON COLUMN metadata_provider.provider_name IS 'Provider''s name';


	--
	-- Name: COLUMN metadata_provider.provider_url; Type: COMMENT; Schema: public; Owner: -
	--

	COMMENT ON COLUMN metadata_provider.provider_url IS 'Provider''s url';


	--
	-- Name: COLUMN metadata_provider.metadata; Type: COMMENT; Schema: public; Owner: -
	--

	COMMENT ON COLUMN metadata_provider.metadata IS 'Other metadata about provider';


	--
	-- Name: metadata_provider_id_seq; Type: SEQUENCE; Schema: public; Owner: -
	--

	CREATE SEQUENCE metadata_provider_id_seq
	AS integer
	START WITH 1
	INCREMENT BY 1
	NO MINVALUE
	NO MAXVALUE
	CACHE 1;


	--
	-- Name: metadata_provider_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
	--

	ALTER SEQUENCE metadata_provider_id_seq OWNED BY metadata_provider.id;


	--
	-- Name: metadata_provider id; Type: DEFAULT; Schema: public; Owner: -
	--

	ALTER TABLE ONLY metadata_provider ALTER COLUMN id SET DEFAULT nextval('metadata_provider_id_seq'::regclass);


	--
	-- Name: metadata_provider metadata_provider_pkey; Type: CONSTRAINT; Schema: public; Owner: -
	--

	ALTER TABLE ONLY metadata_provider
	ADD CONSTRAINT metadata_provider_pkey PRIMARY KEY (id);


	--
	-- Name: metadata_provider_provider_name_provider_url_idx; Type: INDEX; Schema: public; Owner: -
	--

	CREATE INDEX metadata_provider_provider_name_provider_url_idx ON metadata_provider USING btree (provider_name, provider_url);


	--
	-- PostgreSQL database dump complete
	--

File Metadata

Mime Type: text/plain
Expires: Jun 4 2025, 6:58 PM (10 w, 4 d ago)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 3375522

public.metadata_provider.sqlNo OneTemporaryActions

public.metadata_provider.sqlView Options

File Metadata

Event Timeline

public.metadata_provider.sql
No OneTemporary
Actions

public.metadata_provider.sql
View Options