location_business_lines


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
antecedents.location_business_line_id fk_antecedents_location_business_line R
billing_codes.location_business_line_id fk_billing_codes_location_business_line R
catalog_intensity_keys.location_business_line_id fk_catalog_intensity_keys_location R
clearinghouses.location_business_line_id clearinghouses_ibfk_1 R
client_moods.location_business_line_id fk_client_moods_location_business_line R
cpt_codes.location_business_line_id fk_cpt_codes_location_business_line R
encounter_cpt_codes.location_business_line_id fk_encounter_cpt_codes_location R
encounter_participants.location_business_line_id fk_encounter_participants_location R
encounter_rule_types.location_business_line_id fk_encounter_rule_types_location R
encounter_rules.location_business_line_id fk_encounter_rules_location R
encounter_rules.scope_location_id fk_encounter_rules_scope_location C
encounter_type_cpts.location_business_line_id fk_encounter_type_cpts_location R
encounter_type_sub_events.location_business_line_id fk_encounter_type_sub_events_location R
encounter_types.location_business_line_id fk_encounter_types_location R
encounters.location_business_line_id fk_encounters_location R
encounters.location_id fk_encounters_service_location N
environmental_changes.location_business_line_id fk_environmental_changes_location_business_line R
hr_documents.location_business_line_id fk_hr_documents_location C
intervention.location_business_line_id fk_intervention_location_business_line R
invoices.location_business_line_id fk_invoices_location_business_line R
maladaptive_behaviors.location_business_line_id maladaptive_behaviors_ibfk_1 C
payers.location_business_line_id payers_ibfk_1 R
service_plan_maladaptive_behaviors.location_business_line_id fk_sp_maladaptive_behaviors_location R
session_outcomes.location_business_line_id fk_session_outcomes_lbl C
sp_maladaptive_behavior_barriers.location_business_line_id fk_sp_mb_barriers_location R
treatment_targets.location_business_line_id fk_treatment_targets_location R
user_rates.location_business_line_id user_rates_ibfk_1 C
users.location_business_line_id fk_users_location_business_line R
location_id VARCHAR 36 null
business_line_id VARCHAR 36 null
name VARCHAR 255 null
shedlock.name Implied Constraint R
address VARCHAR 500 √ null
city VARCHAR 100 √ null
state VARCHAR 50 √ null
phone VARCHAR 20 √ null
fax VARCHAR 20 √ null
website VARCHAR 255 √ null
description TEXT 65535 √ null
avatar 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
hr_expiring_days_in_advance INT 10 √ 15
hr_notification_emails TEXT 65535 √ null
clinical_expiring_days_in_advance INT 10 √ 15
clinical_notification_emails TEXT 65535 √ null
client_chart_prefix VARCHAR 10 √ ABA
user_chart_prefix VARCHAR 10 √ EMP
case_prefix VARCHAR 10 √ CAS
auth_low_units_threshold_percent INT 10 √ 20
auth_expiring_days_threshold INT 10 √ 30
email VARCHAR 255 √ null
zip_code VARCHAR 20 √ null
npi VARCHAR 20 √ null

National Provider Identifier
mpi VARCHAR 50 √ null

Medicaid Provider Identifier
taxonomy_code VARCHAR 20 √ null

Healthcare provider taxonomy code
ein VARCHAR 20 √ null

Employer Identification Number
trade_name VARCHAR 255 √ null
shedlock.name Implied Constraint R

DBA or trade name for this location
ai_api_key VARCHAR 500 √ null
timezone VARCHAR 64 √ null
is_default BIT 1 0

The one business line representing this tenant as an organization (at most one row = 1)
default_flag_unique BIT 1 √ null

Uniqueness helper for is_default - MySQL has no partial indexes; NULL rows are unconstrained

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_location_business_line_active Performance Asc is_active
idx_location_business_line_business_line Performance Asc business_line_id
idx_location_business_line_location Performance Asc location_id
uk_location_business_line_default Must be unique Asc default_flag_unique
uk_tenant_location_business_line Must be unique Asc/Asc location_id + business_line_id

Relationships

Close relationships within degrees of separation