Table arcasys.posper_category
Define Categories

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id varchar 255
posper_category.parent_id FK_posper_category_2 R
posper_product.category_id FK_posper_product_3 R
version int 10 0 Used for optimistic locking
visibleId int 10  √  null -
category_name varchar 255 -
parent_id varchar 255  √  null
posper_category.id FK_posper_category_2 R
-
image_id varchar 255  √  null
posper_image.id FK51140234BEC833C3 R
-
prep_time smallint 5  √  null Preparation time. For restaurant use with Enjoy
displayOrder int 10  √  null -
timed_availability varchar 255  √  null
updated_at datetime 19  √  null -
erp_updated_at datetime 19  √  null Last sync update from ERP system

Table contained 2 rows at Do Apr 25 17:50 MESZ 2019

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
parent_id Performance Asc FK511402349FE67545
image_id Performance Asc FK51140234BEC833C3
visibleId Performance Asc visibleId

Close relationships  within of separation: