pseudonymized_transactions

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
pseudonymized_metadata_values.transaction_id pseudonymized_metadata_values_ibfk_1 C
hashed_borrowernumber VARCHAR 60 null
has_cardnumber TINYINT 3 0
title LONGTEXT 2147483647 √ NULL
city LONGTEXT 2147483647 √ NULL
state MEDIUMTEXT 16777215 √ NULL
zipcode VARCHAR 25 √ NULL
country MEDIUMTEXT 16777215 √ NULL
branchcode VARCHAR 10 ''
categorycode VARCHAR 10 ''
categories.categorycode Implied Constraint R
dateenrolled DATE 10 √ NULL
sex VARCHAR 1 √ NULL
sort1 VARCHAR 80 √ NULL
sort2 VARCHAR 80 √ NULL
datetime DATETIME 19 √ NULL
transaction_branchcode VARCHAR 10 √ NULL
transaction_type VARCHAR 16 √ NULL
itemnumber INT 10 √ NULL
itemtype VARCHAR 10 √ NULL
itemtypes.itemtype Implied Constraint R
holdingbranch VARCHAR 10 √ NULL
homebranch VARCHAR 10 √ NULL
location VARCHAR 80 √ NULL
itemcallnumber VARCHAR 255 √ NULL
ccode VARCHAR 80 √ NULL

Indexes

Constraint Name Type Sort Column(s)
pseudonymized_transactions_s_pk Primary key Asc id
PRIMARY Must be unique Asc id
pseudonymized_transactions_borrowers_ibfk_2 Performance Asc branchcode
pseudonymized_transactions_borrowers_ibfk_3 Performance Asc transaction_branchcode
pseudonymized_transactions_ibfk_1 Performance Asc categorycode
pseudonymized_transactions_ibfk_5 Performance Asc transaction_type
pseudonymized_transactions_ibfk_6 Performance Asc datetime
pseudonymized_transactions_items_ibfk_4 Performance Asc itemnumber

Relationships

Close relationships within degrees of separation