shedlock


Columns

Column Type Size Nulls Auto Default Children Parents Comments
name VARCHAR 255 null
activities.name Implied Constraint R
ai_generation_templates.template_name Implied Constraint R
ai_prompt_profiles.name Implied Constraint R
ai_rule_sets.name Implied Constraint R
announcement_recipients.recipient_name Implied Constraint R
antecedent_interventions.name Implied Constraint R
antecedents.name Implied Constraint R
assessment_templates.name Implied Constraint R
assessment_tools.name Implied Constraint R
assistance_levels.name Implied Constraint R
availity_payer_capability.payer_name Implied Constraint R
boilerplate_templates.name Implied Constraint R
boilerplate_variables.name Implied Constraint R
business_entities.name Implied Constraint R
business_lines.name Implied Constraint R
business_lines.trade_name Implied Constraint R
caregiver_training_topics.name Implied Constraint R
caregivers.status_changed_by_name Implied Constraint R
cases.insurance_name Implied Constraint R
cases.name Implied Constraint R
catalog_activities.name Implied Constraint R
catalog_antecedent_interventions.name Implied Constraint R
catalog_antecedents.name Implied Constraint R
catalog_assessment_tools.name Implied Constraint R
catalog_assistance_levels.name Implied Constraint R
catalog_caregiver_training_topics.name Implied Constraint R
catalog_clearinghouses.name Implied Constraint R
catalog_clinical_documents.name Implied Constraint R
catalog_competency_options.name Implied Constraint R
catalog_consequence_interventions.name Implied Constraint R
catalog_consequences.name Implied Constraint R
catalog_credentials.name Implied Constraint R
catalog_credentials.organization_name Implied Constraint R
catalog_discriminative_stimuli.name Implied Constraint R
catalog_environmental_changes.name Implied Constraint R
catalog_focus_interventions.name Implied Constraint R
catalog_hr_documents.name Implied Constraint R
catalog_hypothesized_functions.name Implied Constraint R
catalog_interventions.name Implied Constraint R
catalog_maladaptive_behaviors.name Implied Constraint R
catalog_medical_concerns.name Implied Constraint R
catalog_participation_justifications.name Implied Constraint R
catalog_payers.name Implied Constraint R
catalog_prompts.name Implied Constraint R
catalog_protocol_modification_categories.name Implied Constraint R
catalog_protocols.name Implied Constraint R
catalog_reinforcers.name Implied Constraint R
catalog_replacement_behaviors.name Implied Constraint R
catalog_scheduled_reinforcements.name Implied Constraint R
catalog_teaching_materials.name Implied Constraint R
catalog_teaching_objectives.name Implied Constraint R
catalog_teaching_procedures.name Implied Constraint R
catalog_treatment_targets.name Implied Constraint R
clearinghouses.name Implied Constraint R
client_files.original_file_name Implied Constraint R
client_files.uploaded_by_name Implied Constraint R
client_pharmacies.name Implied Constraint R
client_status_change_history.changed_by_name Implied Constraint R
clients.emergency_contact_name Implied Constraint R
clinical_documents.name Implied Constraint R
competency_options.name Implied Constraint R
consequence_interventions.name Implied Constraint R
consequences.name Implied Constraint R
contact_organizations.name Implied Constraint R
credentials.name Implied Constraint R
credentials.organization_name Implied Constraint R
daily_operation_logs.related_entity_name Implied Constraint R
datasheet_initials_audit_log.changed_by_user_name Implied Constraint R
datasheet_initials_audit_log.new_user_name Implied Constraint R
datasheet_initials_audit_log.old_user_name Implied Constraint R
datasheets.ioa_observer_name Implied Constraint R
datasheets.locked_by_user_name Implied Constraint R
datasheets.signed_by_user_name Implied Constraint R
discriminative_stimuli.name Implied Constraint R
documents.name Implied Constraint R
documents.uploaded_by_name Implied Constraint R
eligibility_check.plan_name Implied Constraint R
encounter_note_narratives.custom_section_name Implied Constraint R
focus_interventions.name Implied Constraint R
hr_documents.name Implied Constraint R
hypothesized_functions.name Implied Constraint R
insurances.insurance_name Implied Constraint R
insurances.plan_name Implied Constraint R
location_business_lines.name Implied Constraint R
location_business_lines.trade_name Implied Constraint R
locations.name Implied Constraint R
maladaptive_behaviors.name Implied Constraint R
medical_concerns.name Implied Constraint R
medications.name Implied Constraint R
note_templates.template_name Implied Constraint R
participation_justifications.name Implied Constraint R
payers.name Implied Constraint R
physicians.first_name Implied Constraint R
physicians.last_name Implied Constraint R
prior_authorization_documents.file_name Implied Constraint R
prompts.name Implied Constraint R
protocol_modification_categories.name Implied Constraint R
protocols.name Implied Constraint R
provider_master_list.dba_name Implied Constraint R
provider_master_list.provider_name Implied Constraint R
reinforcers.name Implied Constraint R
replacement_behaviors.name Implied Constraint R
report_definitions.name Implied Constraint R
required_documents.name Implied Constraint R
scheduled_job.name Implied Constraint R
scheduled_reinforcements.name Implied Constraint R
service_plan_caregiver_competencies.name Implied Constraint R
service_plan_categories.name Implied Constraint R
service_plan_category_definitions.name Implied Constraint R
service_plan_custom_categories.name Implied Constraint R
service_plan_maladaptive_behaviors.name Implied Constraint R
service_plan_rbt_competencies.name Implied Constraint R
service_plan_replacement_behaviors.name Implied Constraint R
service_plans.name Implied Constraint R
signature_recipients.name Implied Constraint R
sp_maladaptive_behavior_measure_history.created_by_user_name Implied Constraint R
sp_maladaptive_behavior_protocol_modifications.protocol_name Implied Constraint R
sp_measure_version_audit_log.user_name Implied Constraint R
sp_replacement_behavior_field_history.changed_by_name Implied Constraint R
sp_replacement_behavior_protocol_modifications.protocol_name Implied Constraint R
teaching_materials.name Implied Constraint R
teaching_objectives.name Implied Constraint R
teaching_procedures.name Implied Constraint R
treatment_targets.name Implied Constraint R
user_credentials.document_name Implied Constraint R
users.company_name Implied Constraint R
lock_until TIMESTAMP 23 null
locked_at TIMESTAMP 23 null
locked_by VARCHAR 255 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc name

Relationships

Close relationships within degrees of separation