Table ocum.inventoryview 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 bigint 19  √ 
inventoryviewschedule.viewId InventoryViewSchedule_viewId_FK C
name varchar 255
object varchar 255
category enum 28
style enum 7
filters json 0  √  null
search varchar 255  √  null
sort varchar 100  √  null
columns json 0  √  null
createdTimestamp timestamp 19  √  null
createdBy varchar 255

Table contained 28 rows at Tue Apr 23 05:29 EDT 2019

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY

Close relationships: