<?xml version="1.0" encoding="UTF-8"?>
<!--
    Document   : series.xml
    Author     : Carlos Garcia Gomez
    Description:
        Structure for the series table.
-->
<table>
    <column>
        <name>canal</name>
        <type>integer</type>
    </column>
    <column>
        <name>codserie</name>
        <type>character varying(4)</type>
        <null>NO</null>
    </column>
    <column>
        <name>descripcion</name>
        <type>character varying(100)</type>
    </column>
    <column>
        <name>iddiario</name>
        <type>integer</type>
    </column>
    <column>
        <name>siniva</name>
        <type>boolean</type>
        <null>NO</null>
        <default>false</default>
    </column>
    <column>
        <name>tipo</name>
        <type>character varying(4)</type>
    </column>
    <constraint>
        <name>series_pkey</name>
        <type>PRIMARY KEY (codserie)</type>
    </constraint>
    <constraint>
        <name>ca_series_diarios</name>
        <type>FOREIGN KEY (iddiario) REFERENCES diarios (iddiario) ON DELETE SET NULL ON UPDATE CASCADE</type>
    </constraint>
</table>