client_pharmacies


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
location_business_line_id VARCHAR 36 null
client_id VARCHAR 36 null
clients.id fk_client_pharmacy_client C
name VARCHAR 255 null
shedlock.name Implied Constraint R
phone VARCHAR 20 √ null
fax VARCHAR 20 √ null
street VARCHAR 255 √ null
city VARCHAR 100 √ null
state VARCHAR 50 √ null
zip_code VARCHAR 20 √ null
country VARCHAR 100 √ United States
latitude DECIMAL 10,8 √ null
longitude DECIMAL 11,8 √ null
place_id VARCHAR 255 √ null
is_primary BIT 1 √ 0
is_active BIT 1 √ 1
notes TEXT 65535 √ null
created_at TIMESTAMP 19 CURRENT_TIMESTAMP
updated_at TIMESTAMP 19 √ null
created_by VARCHAR 36 √ null
updated_by VARCHAR 36 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_client_pharmacy_client_id Performance Asc client_id
idx_client_pharmacy_lbl Performance Asc location_business_line_id

Relationships

Close relationships within degrees of separation