| pref_id | int(11) | NO | | PRI | auto_increment | |
| pref_cus_id | int(11) | NO | 0 | MUL | | customer id |
| pref_cli_id | int(11) | NO | 0 | MUL | | client id |
| pref_pat_id | int(11) | NO | 0 | MUL | | patient id |
| pref_apt_id | int(11) | YES | | MUL | | Appointment ID |
| pref_enc_id | int(11) | NO | 0 | MUL | | encounter id |
| pref_ccp_id | int(11) | NO | | MUL | | |
| pref_reason | text | YES | | | | Reason for referral. |
| pref_inbound | tinyint(1) | NO | 0 | | | Indicates referral is inbound. False for outbound. |
| pref_from_phy_id | int(11) | YES | | MUL | | Referring Provider ID |
| pref_to_phy_id | int(11) | YES | | MUL | | Target Provider ID |
| pref_referred_dt | datetime | YES | | | | date of referral |
| pref_start_ts | varchar(12) | NO | | | | start/sent datetime of referral |
| pref_start_dt | datetime | YES | | | | start/sent datetime of referral |
| pref_completed_dt | datetime | YES | | | | date completed |
| pref_report_requested | tinyint(1) | YES | 0 | | | report requested |
| pref_received | char(1) | NO | | | | |
| pref_received_by | int(11) | NO | | | | |
| pref_received_ts | varchar(12) | NO | | | | |
| pref_disabled | tinyint(1) | NO | 0 | | | Indicates if referral is disabled |
| pref_priority | int(11) | YES | 0 | | | priority |
| pref_referral_status | varchar(20) | YES | pending | | | status of referral |
| pref_assigned_usr_id | int(11) | YES | | | | id of assigned user |
| pref_assigned_grp_id | int(11) | YES | | MUL | | id of assigned group |
| pref_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| pref_created | timestamp | YES | CURRENT_TIMESTAMP | | | |