self_registration_form_sierra

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
name VARCHAR 100 null
selfRegistrationTemplate VARCHAR 25 √ 'default'
selfRegEmailBarcode TINYINT 3 0
termsOfServiceSetting INT 10 -1
selfRegPatronType INT 10 √ NULL
selfRegNoticePref CHAR 1 √ '-'
selfRegTelephoneField VARCHAR 5 √ NULL
selfRegExpirationDays INT 10 √ 30
selfRegPcode1 VARCHAR 25 √ NULL
selfRegPcode2 VARCHAR 25 √ NULL
selfRegPcode3 INT 10 √ NULL
selfRegPcode4 INT 10 √ NULL
selfRegPatronMessage VARCHAR 35 √ NULL
selfRegAgency INT 10 √ NULL
selfRegBarcodePrefix VARCHAR 10 √ NULL
selfRegBarcodeSuffixLength INT 10 √ 7
selfRegGuardianField VARCHAR 10 √ NULL
selfRegNoDuplicateCheck TINYINT 3 √ 0
selfRegUseAgency TINYINT 3 √ 0
selfRegUsePatronIdBarcode TINYINT 3 √ 0
selfRegNoticePrefOptions VARCHAR 255 √ ''
addSelfRegNote TINYINT 3 √ 1

Indexes

Constraint Name Type Sort Column(s)
self_registration_form_sierra_s_pk Primary key Asc id
name Must be unique Asc name
PRIMARY Must be unique Asc id

Relationships

Close relationships within degrees of separation