<?xml version="1.0" encoding="UTF-8"?>
<!--
    Document   : logs.xml
    Author     : Carlos Garcia Gomez
    Description:
        Structure for the logs table.
-->
<table>
    <column>
        <name>channel</name>
        <type>character varying(40)</type>
    </column>
    <column>
        <name>context</name>
        <type>text</type>
    </column>
    <column>
        <name>id</name>
        <type>serial</type>
        <null>NO</null>
    </column>
    <column>
        <name>idcontacto</name>
        <type>integer</type>
    </column>
    <column>
        <name>ip</name>
        <type>character varying(40)</type>
    </column>
    <column>
        <name>level</name>
        <type>character varying(15)</type>
        <null>NO</null>
    </column>
    <column>
        <name>message</name>
        <type>text</type>
        <null>NO</null>
    </column>
    <column>
        <name>model</name>
        <type>character varying(30)</type>
    </column>
    <column>
        <name>modelcode</name>
        <type>character varying(40)</type>
    </column>
    <column>
        <name>nick</name>
        <type>character varying(50)</type>
    </column>
    <column>
        <name>time</name>
        <type>timestamp</type>
        <null>NO</null>
    </column>
    <column>
        <name>uri</name>
        <type>character varying(200)</type>
    </column>
    <constraint>
        <name>logs_pkey</name>
        <type>PRIMARY KEY (id)</type>
    </constraint>
</table>