_1218.health_maintenance

Field Type Null Default Key Extra Comment
hm_id int(11) NO PRI auto_increment
hm_cus_id int(11) NO MUL
hm_cli_id int(11) NO MUL
hm_name varchar(255) NO
hm_desc text NO
hm_age_lower varchar(3) NO
hm_age_upper varchar(3) NO
hm_sex varchar(6) NO
hm_interval int(11) NO
hm_interval_span varchar(8) NO
hm_prior int(11) NO
hm_prior_span varchar(8) NO
hm_reminder_text text NO
hm_deleted char(1) NO
hm_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
hm_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References
hm_id
TableColumn
_1.health_maintenance_associationshma_hm_id
_1.health_maintenance_conditionshmc_hm_id
_1.patients_reminderspr_hm_id
_1188.health_maintenance_associationshma_hm_id
_1188.health_maintenance_conditionshmc_hm_id
_1188.patients_reminderspr_hm_id
_1218.health_maintenance_associationshma_hm_id
_1218.health_maintenance_conditionshmc_hm_id
_1218.patients_reminderspr_hm_id
_1548.health_maintenance_associationshma_hm_id
_1548.health_maintenance_conditionshmc_hm_id
_1548.patients_reminderspr_hm_id
_435.health_maintenance_associationshma_hm_id
_435.health_maintenance_conditionshmc_hm_id
_435.patients_reminderspr_hm_id
_436.health_maintenance_associationshma_hm_id
_436.health_maintenance_conditionshmc_hm_id
_436.patients_reminderspr_hm_id
_436_archive_testing.health_maintenance_associationshma_hm_id
_436_archive_testing.health_maintenance_conditionshmc_hm_id
_436_archive_testing.patients_reminderspr_hm_id
_437.health_maintenance_associationshma_hm_id
_437.health_maintenance_conditionshmc_hm_id
_437.patients_reminderspr_hm_id
_8.health_maintenance_associationshma_hm_id
_8.health_maintenance_conditionshmc_hm_id
_8.patients_reminderspr_hm_id
_81.health_maintenance_associationshma_hm_id
_81.health_maintenance_conditionshmc_hm_id
_81.patients_reminderspr_hm_id
_999.health_maintenance_associationshma_hm_id
_999.health_maintenance_conditionshmc_hm_id
_999.patients_reminderspr_hm_id