Table testsql_comments.subscription_numberpatterns 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 int 10  √ 
subscription.numberpattern subscription_ibfk_2 N
fieldmapping.id Implied Constraint R
label varchar 255
displayorder int 10  √  null
description text 65535
numberingmethod varchar 255
label1 varchar 255  √  null
add1 int 10  √  null
every1 int 10  √  null
whenmorethan1 int 10  √  null
setto1 int 10  √  null
numbering1 varchar 255  √  null
label2 varchar 255  √  null
add2 int 10  √  null
every2 int 10  √  null
whenmorethan2 int 10  √  null
setto2 int 10  √  null
numbering2 varchar 255  √  null
label3 varchar 255  √  null
add3 int 10  √  null
every3 int 10  √  null
whenmorethan3 int 10  √  null
setto3 int 10  √  null
numbering3 varchar 255  √  null

Table contained 0 rows at Tue Dec 27 18:01 NZDT 2016

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

Close relationships  within of separation: