common.clients_zuora_physicians_config

Field Type Null Default Key Extra Comment
czp_id int(11) NO PRI auto_increment
czp_cus_id int(11) NO 0 Customer Id
czp_cli_id int(11) NO 0 MUL Client Id
czp_phy_id int(11) NO 0 MUL Physician Id
czp_employ_status varchar(10) NO If Provider is full/part time and id md-do or pa-np
czp_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
czp_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References