Purchase-Book Table

From EA-Geier

Database Config Table Clients Table ClientConfig Table Users Table UserConfig Table Session2 Table SimpleTest Table Cash-Book Table Assets-Book Table Purchase-Book Table Traveling-Expenses Table Balance 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>