Table arcasys.posper_location
Defines a warehouse - sorry.

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_productlocation.location_id FKFD9B9FAEB3B86111 R
posper_stockdiary.location_id FK36C93A23B3B86111 R
version int 10 Used for optimistic locking
visibleId int 10  √  null -
address varchar 255  √  null -
name varchar 255 -

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc PRIMARY  
visibleId Must be unique Asc visibleId This unique column is also nullable

Close relationships  within of separation: