_437.patients_payment_methods

Field Type Null Default Key Extra Comment
patpm_id int(11) NO PRI auto_increment
patpm_cus_id int(11) YES Customer ID#
patpm_cli_id int(11) YES Client ID#
patpm_pat_id int(11) YES MUL Patient ID#
patpm_usr_id int(11) YES User ID#
patpm_token_id varchar(40) NO
patpm_nickname varchar(40) NO MUL
patpm_desc varchar(40) NO MUL
patpm_exp_date date NO Payment method Expiration Date
patpm_card_type varchar(20) NO
patpm_disabled tinyint(1) NO 0 Disabled
patpm_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
patpm_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References
patpm_id
TableColumn
_1.patients_payments_ledger_mappplm_patpm_id
_1.patients_payments_schedulespps_patpm_id
_1188.patients_payments_ledger_mappplm_patpm_id
_1188.patients_payments_schedulespps_patpm_id
_1218.patients_payments_ledger_mappplm_patpm_id
_1218.patients_payments_schedulespps_patpm_id
_1548.patients_payments_ledger_mappplm_patpm_id
_1548.patients_payments_schedulespps_patpm_id
_435.patients_payments_ledger_mappplm_patpm_id
_435.patients_payments_schedulespps_patpm_id
_436.patients_payments_ledger_mappplm_patpm_id
_436.patients_payments_schedulespps_patpm_id
_436_archive_testing.patients_payments_ledger_mappplm_patpm_id
_436_archive_testing.patients_payments_schedulespps_patpm_id
_437.patients_payments_ledger_mappplm_patpm_id
_437.patients_payments_schedulespps_patpm_id
_8.patients_payments_ledger_mappplm_patpm_id
_8.patients_payments_schedulespps_patpm_id
_81.patients_payments_ledger_mappplm_patpm_id
_81.patients_payments_schedulespps_patpm_id
_999.patients_payments_ledger_mappplm_patpm_id
_999.patients_payments_schedulespps_patpm_id