Using POSper/Developer guide/Database-Table descriptions/posper cashregister

From Wikibooks, open books for an open world
Jump to navigation Jump to search

posper_cashregister[edit | edit source]


This table describes a specific cash session, opened and closed at specific times, for a specific host.

Column Name Data Type Null Allowed? Key? Comments
id VARCHAR(255) No Primary UUID instead of int
version INT(11) No This is used by hibernate to track table versions
dateOpen DATETIME No The start date/time of the cash session
dateClose DATETIME Yes the end date/time of the cash session
host VARCHAR(255) No The host that this cash session applies to