common.vaccines

Field Type Null Default Key Extra Comment
vac_id int(11) NO PRI auto_increment
vac_cvx_code varchar(5) NO
vac_name varchar(100) NO
vac_name_full varchar(255) NO
vac_status varchar(12) NO
vac_notes text NO
vac_last_updated varchar(8) NO
vac_non_vaccine varchar(5) NO
vac_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
vac_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References
vac_id
TableColumn
_1.immunizationsimz_vac_id
_1.patients_immunizationspim_vac_id
_1.patients_immunizations_templatespimt_vac_id
_1188.immunizationsimz_vac_id
_1188.patients_immunizationspim_vac_id
_1188.patients_immunizations_templatespimt_vac_id
_1218.immunizationsimz_vac_id
_1218.patients_immunizationspim_vac_id
_1218.patients_immunizations_templatespimt_vac_id
_1548.immunizationsimz_vac_id
_1548.patients_immunizationspim_vac_id
_1548.patients_immunizations_templatespimt_vac_id
_435.immunizationsimz_vac_id
_435.patients_immunizationspim_vac_id
_435.patients_immunizations_templatespimt_vac_id
_436.immunizationsimz_vac_id
_436.patients_immunizationspim_vac_id
_436.patients_immunizations_templatespimt_vac_id
_436_archive_testing.immunizationsimz_vac_id
_436_archive_testing.patients_immunizationspim_vac_id
_436_archive_testing.patients_immunizations_templatespimt_vac_id
_437.immunizationsimz_vac_id
_437.patients_immunizationspim_vac_id
_437.patients_immunizations_templatespimt_vac_id
_8.immunizationsimz_vac_id
_8.patients_immunizationspim_vac_id
_8.patients_immunizations_templatespimt_vac_id
_81.immunizationsimz_vac_id
_81.patients_immunizationspim_vac_id
_81.patients_immunizations_templatespimt_vac_id
_999.immunizationsimz_vac_id
_999.patients_immunizationspim_vac_id
_999.patients_immunizations_templatespimt_vac_id
common.vaccines_groups_mapvgm_vac_id
common.vaccines_manufacturers_mapvmm_vac_id
template_library.patients_immunizations_templatespimt_vac_id