Using POSper/Developer guide/Database-Table descriptions

The information on this page is confirmed up to POSper revision 423

Contents

Generator tables

These tables are simply storehouses for the next available id for other tables that they serve.

• posper_ticketcreationgenerator
• posper_ticketidgenerator

Restaurant specific tables

These tables seem fairly specific to a restaurant setting rather than being generally applicable to any POS.

• posper_reservation

Geographic

These tables are spatial by nature

• posper_floor
• posper_location
• posper_place
• posper_productlocation

Ticket handling

These tables deal with handling tickets

• posper_ticket
• posper_ticketline

User management

These tables manage users including user rights

• posper_user
• posper_role
• posper_role_permission
• posper_permission

The rest

The rest of the tables

• posper_stockdiary
• posper_cashregister
• posper_category
• posper_image
• posper_payment
• posper_product
• posper_property
• posper_resource
• posper_imageresource
• posper_tax