| upa_id | int(11) | NO | | PRI | auto_increment | |
| upa_cus_id | int(11) | NO | | MUL | | |
| upa_cli_id | int(11) | NO | | MUL | | |
| upa_usr_id | int(11) | NO | | MUL | | |
| upa_pat_id | int(11) | NO | | MUL | | |
| upa_relationship | varchar(45) | NO | | | | |
| upa_estatements | tinyint(1) | NO | 0 | | | Indicates if the user receives patient portal eStatements for this patient |
| upa_verify_token | varchar(30) | YES | | | | user verification token to check against |
| upa_verified | tinyint(1) | YES | 0 | | | indicates that user has verified identity and now has access |
| upa_disabled | char(1) | NO | | MUL | | |
| upa_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| upa_created | timestamp | YES | CURRENT_TIMESTAMP | | | |