| erx_ans_id | int(11) | NO | | PRI | auto_increment | |
| erx_ans_config_id | int(11) unsigned | YES | | MUL | | ERX Ans Configuration ID |
| erx_ans_practice_name | varchar(40) | NO | | MUL | | |
| erx_ans_web_browser_url | varchar(128) | NO | | | | |
| erx_ans_pda_browser_url | varchar(128) | NO | | | | |
| erx_ans_win_upload_url | varchar(128) | NO | | | | |
| erx_ans_win_download_url | varchar(128) | NO | | | | |
| erx_ans_engine_download_url | varchar(128) | NO | | | | |
| erx_ans_engine_upload_url | varchar(128) | NO | | | | |
| erx_ans_link_download_url | varchar(128) | NO | | | | |
| erx_ans_link_upload_url | varchar(128) | NO | | | | |
| erx_ans_ac_web_browser_url | varchar(128) | NO | | | | |
| erx_ans_ac_engine_download_url | varchar(128) | NO | | | | |
| erx_ans_ac_engine_upload_url | varchar(128) | NO | | | | |
| erx_ans_ac_link_download_url | varchar(128) | NO | | | | |
| erx_ans_ac_link_upload_url | varchar(128) | NO | | | | |
| erx_ans_payer_engine_url | varchar(128) | NO | | | | |
| erx_ans_registration_url | varchar(128) | NO | | | | |
| erx_ans_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| erx_ans_created | timestamp | YES | CURRENT_TIMESTAMP | | | |