| SchemaSpy Analysis of arcasys posper-schema:20180923103000 backoffice-schema:20180925124234 |
Generated by SchemaSpy |
| Generated by SchemaSpy on Do Apr 25 17:50 MESZ 2019 | |
| Database Type: MySQL - 5.5.60-0+deb7u1-log |
|
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
| Table / View | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| account_conversion_rules | 7 | 0 | |||
| bo_invoices | 4 | 0 | |||
| bo_languages | 3 | 0 | |||
| bo_new_prices | 1 | 5 | 0 | ||
| bo_price_labels | 1 | 6 | 2 | ||
| bo_translations | 6 | 0 | |||
| bo_trcolumns | 4 | 7 | |||
| bo_trtables | 2 | 6 | |||
| bo_uitranslations | 4 | 0 | |||
| DATABASECHANGELOG | 14 | 63 | |||
| DATABASECHANGELOGLOCK | 4 | 1 | |||
| employees | 2 | 1 | 43 | 0 | |
| goldberg_content_pages | 13 | 16 | |||
| goldberg_controller_actions | 5 | 109 | |||
| goldberg_menu_items | 8 | 65 | |||
| goldberg_permissions | 4 | 26 | |||
| goldberg_roles | 13 | 11 | |||
| goldberg_roles_permissions | 3 | 39 | |||
| goldberg_site_controllers | 4 | 48 | |||
| goldberg_system_settings | 21 | 1 | |||
| goldberg_users | 13 | 6 | |||
| holidays | 3 | 224 | |||
| locations | 6 | 0 | |||
| log4j_audit_logs | 5 | 0 | |||
| memberaccounts | 13 | 0 | |||
| plugin_schema_info | 2 | 1 | |||
| positions | 1 | 4 | 5 | ||
| posper_cashregister | 2 | 14 | 2 | Defines a cashregister period | |
| posper_category | 2 | 2 | 11 | 2 | Define Categories |
| posper_course | 5 | 0 | For restaurant use with Enjoy | ||
| posper_currency | 5 | 2 | Defines an additional currency. | ||
| posper_customer | 1 | 2 | 40 | 1 | Kundendaten |
| posper_customerdiscounts | 1 | 6 | 0 | Define customer specific pricing | |
| posper_customergroup | 2 | 7 | 1 | Define customer groups. | |
| posper_discountreason | 3 | 1 | This table is not used by POSper. | ||
| posper_floor | 1 | 1 | 5 | 2 | A group of restaurant places. |
| posper_image | 5 | 4 | 6 | Images used by POSper. | |
| posper_imageresource | 1 | 2 | 2 | Links resource keys to images | |
| posper_location | 2 | 5 | 1 | Defines a warehouse - sorry. | |
| posper_logintime | 1 | 6 | 2 | Records posper user lgin and logout | |
| posper_payment | 2 | 14 | 1 | Payments made for a ticket. One ticket can have multiple payments. | |
| posper_paymentserialgenerator | 3 | 0 | Generator for posper_payment.serial | ||
| posper_permission | 2 | 1 | 2 | 113 | Name and link permissions |
| posper_place | 1 | 2 | 9 | 8 | Defines restaurant places for the restaurant map. |
| posper_product | 8 | 4 | 40 | 3 | Define products |
| posper_product_category | 2 | 3 | Link products to categories | ||
| posper_product_tax | 2 | 6 | Only used for multiple taxes, not relevant for Germany | ||
| posper_productean | 4 | 1 | Used to assign multiple EANs | ||
| posper_productlocation | 2 | 6 | 3 | Links products to warehouses | |
| posper_property | 2 | 10 | POSper configuration properties | ||
| posper_reservation | 14 | 0 | Used when erpmode=true (customer specific function: eligible products can have a reservation assigned to the ticketline |
||
| posper_resource | 3 | 35 | Text resources like templates | ||
| posper_role | 2 | 2 | 4 | Define roles and their alias names | |
| posper_role_permission | 2 | 2 | 243 | Assign permissions to roles | |
| posper_specialprice | 1 | 10 | 6 | Define prices for special sales, e.g. happy hour, seasonal, etc. | |
| posper_stockdiary | 2 | 11 | 5 | Record a stock movement | |
| posper_tare | 5 | 1 | Predefined tare values for weighables | ||
| posper_tax | 4 | 5 | 3 | Tax rates. Can also be zero tax for special items like coupon sales. | |
| posper_ticket | 2 | 4 | 25 | 2 | Sales ticket if number>0, utility ticket if number=0 |
| posper_ticketcreationgenerator | 1 | 2 | Generator for the ticket visibleId (also used as delivery number | ||
| posper_ticketidgenerator | 2 | 1 | Generator for the ticket number | ||
| posper_ticketline | 1 | 3 | 27 | 2 | Sales lines per ticket |
| posper_ticketline_tax | 2 | 2 | 0 | Only used for multiple taxes, not relevant for Germany | |
| posper_user | 3 | 2 | 9 | 4 | POSper register users |
| posper_valuecard | 13 | 0 | Registrered value cards | ||
| posper_web_info | 1 | 4 | 0 | Can link to a URL with additional product information currently only usede by Enjoy client |
|
| rosters | 1 | 38 | 0 | ||
| sales_all | 20 | view | |||
| schema_migrations | 1 | 74 | |||
| sessions | 5 | 7 | |||
| speps_suporderlines | 2 | 6 | 0 | ||
| speps_suporders | 1 | 1 | 5 | 0 | |
| speps_suppliers | 2 | 15 | 1 | ||
| timeaccounts | 1 | 11 | 0 | ||
| 73 Tables | 632 | 1.190 | |||
| 1 View | 20 |