Table arcasys.memberaccounts 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  √ 
customer_id varchar 255  √  null
amount double 22  √  null
balance double 22  √  null
created_at datetime 19  √  null
updated_at datetime 19  √  null
transaction_id varchar 255  √  null
trans_type varchar 10  √  null
customer smallint 5  √  null
location smallint 5  √  null
register smallint 5  √  null
card_string varchar 45  √  null
card_type varchar 20  √  null

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

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