subscription_numberpatterns

4 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
subscription.numberpattern subscription_ibfk_2 N
label VARCHAR 255 null
displayorder INT 10 √ NULL
description MEDIUMTEXT 16777215 √ NULL
numberingmethod VARCHAR 255 null
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

Indexes

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

Relationships

Close relationships within degrees of separation