Poniżej plik xml z pliku schema.xml (jest to tylko mała część całej bazy)
<?xml version="1.0" encoding="UTF-8"?> <database defaultIdMethod="native" name="danielcom"> <table name="rekl_towar"> <column name="rekl_towar_id" type="INTEGER" primaryKey="true" required="true" autoIncrement="true"/> <column name="produkt" type="VARCHAR" size="255"/> <column name="sn" type="VARCHAR" size="255"/> <column name="opis_usterki" type="LONGVARCHAR"/> <column name="data_przyjecia" type="TIMESTAMP" description=" "/> <column name="data_zgloszenia" type="TIMESTAMP"/> <column name="data_wysylki" type="TIMESTAMP"/> <column name="data_powrotu" type="TIMESTAMP"/> <column name="uwagi" type="VARCHAR" size="255"/> <column name="klienci_id" type="INTEGER" required="true"/> <foreign-key name="fk_rekl_towar_klienci1" foreignTable="klienci"> <reference local="klienci_id" foreign="klienci_id"/> </foreign-key> </table> <table name="rekl_serwisy"> <column name="rekl_serwisy_id" type="INTEGER" primaryKey="true" required="true" autoIncrement="true"/> <column name="nazwa" type="VARCHAR" size="45"/> <column name="adres" type="CLOB" size="4294967295"/> <column name="nr_tel" type="VARCHAR" size="45"/> <column name="sposob_wysylki" type="VARCHAR" size="45"/> <column name="dane_kuriera" type="LONGVARCHAR"/> <column name="nr_umowy_kuriera" type="VARCHAR" size="45"/> <column name="płatnik" type="VARCHAR" size="45"/> <column name="email" type="VARCHAR" size="45"/> <column name="inne" type="VARCHAR" size="45"/> <column name="uwagi" type="VARCHAR" size="45"/> </table> <table name="rekl_status"> <column name="rekl_status_id" type="INTEGER" primaryKey="true" required="true" autoIncrement="true"/> <column name="status" type="VARCHAR" size="45"/> <column name="rekl_zgloszenia_id" type="INTEGER" required="true"/> <foreign-key name="fk_rekl_status_rekl_zglosz_rma1" foreignTable="rekl_zglosz_rma"> <reference local="rekl_zgloszenia_id" foreign="rekl_zgloszenia_id"/> </foreign-key> </table> <table name="rekl_zglosz_rma"> <column name="rekl_zgloszenia_id" type="INTEGER" primaryKey="true" required="true" autoIncrement="true"/> <column name="wew_rma" type="VARCHAR" size="255"/> <column name="zewn_rma" type="VARCHAR" size="45"/> <column name="zamkniete" type="INTEGER"/> <column name="status" type="INTEGER"/> <column name="decyzja_serwisu" type="LONGVARCHAR"/> <column name="uwagi" type="VARCHAR" size="45"/> <column name="klienci_id" type="INTEGER" required="true"/> <column name="rekl_towar_id" type="INTEGER" required="true"/> <column name="rekl_serwisy_id" type="INTEGER" required="true"/> <foreign-key name="fk_rekl_zglosz_rma_klienci1" foreignTable="klienci"> <reference local="klienci_id" foreign="klienci_id"/> </foreign-key> <foreign-key name="fk_rekl_zglosz_rma_rekl_towar1" foreignTable="rekl_towar"> <reference local="rekl_towar_id" foreign="rekl_towar_id"/> </foreign-key> <foreign-key name="fk_rekl_zglosz_rma_rekl_serwisy1" foreignTable="rekl_serwisy"> <reference local="rekl_serwisy_id" foreign="rekl_serwisy_id"/> </foreign-key> </table> </database>