| ppr_id | int(11) | NO | | PRI | auto_increment | |
| ppr_cus_id | int(11) | NO | | MUL | | |
| ppr_cli_id | int(11) | NO | | MUL | | |
| ppr_usr_id | int(11) | NO | | MUL | | Source user for patient portal request update |
| ppr_org_id | int(11) | YES | | | | Organization responsible for this request |
| ppr_update_data | text | NO | | | | Patient Portal Requests update content, json format |
| ppr_mdl_id | int(11) | NO | | MUL | | Patient Portal Requests Type, References Models table |
| ppr_mdl_key_val | int(11) | NO | 0 | MUL | | Model key value |
| ppr_pat_id | int(11) | NO | | MUL | | Id to filter by patient if needed in patient record |
| ppr_pprs_id | int(11) | NO | | MUL | | Patient Portal Requests Status |
| ppr_source | varchar(256) | NO | | | | Source of patient portal request |
| ppr_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| ppr_created | timestamp | YES | CURRENT_TIMESTAMP | | | |