<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE table PUBLIC "-//iptel.org//DTD DBSchema V1.0//EN"
  "http://iptel.org/dbschema/dtd/1.0/dbschema.dtd" [

<!ENTITY % entities SYSTEM "entities.xml">
%entities;

]>

<table role="serweb">
  <name>customers</name>
  <version>1</version>

  <description>
	Customers - domain owners (among others that's the party to be billed for
	having a domain).  Customers are entities that describe the commercial
	owners of domains.
  </description>
  <column id="cu.cid">
	<name>cid</name>
	<type>unsigned int</type>
	<type db="mysql">INT AUTO_INCREMENT</type>
	<type db="postgres">SERIAL</type>
	<type db="dbtext">int,auto</type>
	<description>
	  Unique id of the customer. The value is auto generated by the databsae
	  server.
	</description>
  </column>

  <column>
	<name>name</name>
	<type>string</type>
	<size>128</size>
	<description>
	  Name of the customer.
	</description>
  </column>

  <column>
	<name>address</name>
	<type>string</type>
	<size>255</size>
	<null/>
	<description>
	  Address of the customer.
	</description>
  </column>

  <column>
	<name>phone</name>
	<type>string</type>
	<size>64</size>
	<null/>
	<description>
	  Phone number of the customer.
	</description>
  </column>

  <column>
	<name>email</name>
	<type>string</type>
	<size>255</size>
	<null/>
	<description>
	  Email address of the customer.
    </description>
  </column>
  

  <index>
	<name>cu_idx</name>
	<unique/>
	<colref linkend="cu.cid"/>
  </index>
</table>
