video_schema

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: video; Type: TABLE; Schema: public; Owner: verbetes
--

CREATE TABLE video (
    id integer DEFAULT nextval('video_seq'::regclass) NOT NULL,
    verid integer,
    tipo character varying(1),
    titulo character varying(120),
    link character varying(200),
    ordem smallint,
    arquivo bytea,
    tipoimg character varying(20),
    tamanho integer,
    tipovideo character varying(1)
);


ALTER TABLE video OWNER TO verbetes;

--
-- Name: video video_pkey; Type: CONSTRAINT; Schema: public; Owner: verbetes
--

ALTER TABLE ONLY video
    ADD CONSTRAINT video_pkey PRIMARY KEY (id);