catalog_payers


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
name VARCHAR 255 null
shedlock.name Implied Constraint R
description TEXT 65535 √ null
email VARCHAR 255 √ null
phone VARCHAR 50 √ null
fax VARCHAR 50 √ null
website VARCHAR 255 √ null
external_id VARCHAR 100 √ null
trading_partner_id VARCHAR 100 √ null
address_line1 VARCHAR 255 √ null
address_line2 VARCHAR 255 √ null
city VARCHAR 100 √ null
state VARCHAR 50 √ null
zip_code VARCHAR 20 √ null
country VARCHAR 100 √ USA
logo_url VARCHAR 500 √ null
is_active BIT 1 1
created_at TIMESTAMP 19 √ CURRENT_TIMESTAMP
updated_at TIMESTAMP 19 √ CURRENT_TIMESTAMP
created_by VARCHAR 255 √ null
updated_by VARCHAR 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_catalog_payers_active Performance Asc is_active
idx_catalog_payers_external_id Performance Asc external_id
idx_catalog_payers_name Performance Asc name
idx_catalog_payers_trading_partner_id Performance Asc trading_partner_id

Relationships

Close relationships within degrees of separation