<?xml version="1.0" encoding="UTF-8"?>
<!--
    Document   : cuentasbcocli.xml
    Author     : Carlos Garcia Gomez
    Description:
        Structure for the cuentasbcocli table.
-->
<table>
    <column>
        <name>codcliente</name>
        <type>character varying(10)</type>
        <null>NO</null>
    </column>
    <column>
        <name>codcuenta</name>
        <type>character varying(10)</type>
        <null>NO</null>
    </column>
    <column>
        <name>descripcion</name>
        <type>character varying(100)</type>
    </column>
    <column>
        <name>fmandato</name>
        <type>date</type>
    </column>
    <column>
        <name>iban</name>
        <type>character varying(34)</type>
    </column>
    <column>
        <name>mandato</name>
        <type>character varying(35)</type>
    </column>
    <column>
        <name>principal</name>
        <type>boolean</type>
    </column>
    <column>
        <name>swift</name>
        <type>character varying(11)</type>
    </column>
    <constraint>
        <name>cuentasbcocli_pkey</name>
        <type>PRIMARY KEY (codcuenta)</type>
    </constraint>
    <constraint>
        <name>ca_cuentasbcocli_clientes</name>
        <type>FOREIGN KEY (codcliente) REFERENCES clientes (codcliente) ON DELETE CASCADE ON UPDATE CASCADE</type>
    </constraint>
    <constraint>
        <name>unique_cuentasbcocli_mandato</name>
        <type>UNIQUE (mandato)</type>
    </constraint>
</table>