Purchase-Book Table

The purchase-book tables hold the purchased goods intended for resale of each client. Each client has its own purchase-book table named “purchasebook” prefixed with the client ID.

The id value is provided by the system by means of auto increment. txtID is the ID, txtName the name or description of the purchased goods provided by the user.

txtVendor holds the data (name & address) of the vendor, and numAmount the price.

year, month, and day provide the purchase date.

who and lastModified provide a minimal log holding the email address and date of the last change.

<?xml version="1.0"?>
<schema version="0.3">
  <table name="purchasebook">
	<field name="id" type="I" size="8">
	  <KEY/>
	  <AUTOINCREMENT/>
	  <UNSIGNED/>
	</field>
	<field name="txtID" type="C" size="32">
	  <NOTNULL/>
	</field>
	<field name="txtName" type="C" size="255">
	  <NOTNULL/>
	</field>
	<field name="txtVendor" type="C" size="255">
	  <NOTNULL/>
	</field>
	<field name="numAmount" type="N" size="12.6">
	  <NOTNULL/>
	</field>
	<field name="year" type="C" size="32">
	  <NOTNULL/>
	</field>
	<field name="month" type="C" size="32">
	  <NOTNULL/>
	</field>
	<field name="day" type="C" size="32">
	  <NOTNULL/>
	</field>
	<field name="who" type="C" size="255">
	  <NOTNULL/>
	</field>
	<field name="lastModified" type="T">
	  <NOTNULL/>
	</field>
	<index name="year">
	  <col>year</col>
	</index>
	<index name="month">
	  <col>month</col>
	</index>
	<index name="day">
	  <col>day</col>
	</index>
  </table>
</schema>