_1.non_patients

Field Type Null Default Key Extra Comment
npat_id int(11) NO PRI auto_increment
npat_cus_id int(11) NO
npat_cli_id int(11) NO
npat_fname varchar(40) NO First Name
npat_mname varchar(40) NO Middle Name
npat_lname varchar(40) NO Last Name
npat_ssn varchar(11) NO
npat_email varchar(80) NO
npat_address1 varchar(40) NO
npat_address2 varchar(40) NO
npat_city varchar(30) NO
npat_state varchar(2) NO
npat_zip varchar(5) NO
npat_zip_plus4 varchar(4) NO
npat_phone varchar(20) NO
npat_sex char(1) NO
npat_disabled int(11) NO
npat_modified datetime YES CURRENT_TIMESTAMP
npat_created datetime YES CURRENT_TIMESTAMP

References

Local Column References
npat_id
TableColumn
_1.non_patients_documentsnpd_npat_id
_1.patients_relatives_mapprm_npat_id
_1.poapoa_npat_id
_1.portal_withheld_datapwd_npat_id
_1188.non_patients_documentsnpd_npat_id
_1188.patients_relatives_mapprm_npat_id
_1188.poapoa_npat_id
_1188.portal_withheld_datapwd_npat_id
_1218.non_patients_documentsnpd_npat_id
_1218.patients_relatives_mapprm_npat_id
_1218.poapoa_npat_id
_1218.portal_withheld_datapwd_npat_id
_1548.non_patients_documentsnpd_npat_id
_1548.patients_relatives_mapprm_npat_id
_1548.poapoa_npat_id
_1548.portal_withheld_datapwd_npat_id
_435.non_patients_documentsnpd_npat_id
_435.patients_relatives_mapprm_npat_id
_435.poapoa_npat_id
_435.portal_withheld_datapwd_npat_id
_436.non_patients_documentsnpd_npat_id
_436.patients_relatives_mapprm_npat_id
_436.poapoa_npat_id
_436.portal_withheld_datapwd_npat_id
_436_archive_testing.non_patients_documentsnpd_npat_id
_436_archive_testing.patients_relatives_mapprm_npat_id
_436_archive_testing.poapoa_npat_id
_436_archive_testing.portal_withheld_datapwd_npat_id
_437.non_patients_documentsnpd_npat_id
_437.patients_relatives_mapprm_npat_id
_437.poapoa_npat_id
_437.portal_withheld_datapwd_npat_id
_8.non_patients_documentsnpd_npat_id
_8.patients_relatives_mapprm_npat_id
_8.poapoa_npat_id
_8.portal_withheld_datapwd_npat_id
_81.non_patients_documentsnpd_npat_id
_81.patients_relatives_mapprm_npat_id
_81.poapoa_npat_id
_81.portal_withheld_datapwd_npat_id
_999.non_patients_documentsnpd_npat_id
_999.patients_relatives_mapprm_npat_id
_999.poapoa_npat_id
_999.portal_withheld_datapwd_npat_id
common.ahi_auditsaud_npat_id