| pinv_id | int(11) | NO | | PRI | auto_increment | |
| pinv_cus_id | int(11) | NO | | MUL | | |
| pinv_cli_id | int(11) | NO | | MUL | | |
| pinv_pat_id | int(11) | NO | | MUL | | |
| pinv_enc_id | int(11) | NO | 0 | MUL | | |
| pinv_pim_id | int(11) | NO | 0 | MUL | | |
| pinv_inv_id | int(11) | NO | 0 | MUL | | |
| pinv_manufacturer | varchar(100) | NO | | | | |
| pinv_lot_number | varchar(32) | NO | | | | |
| pinv_product_number | varchar(32) | NO | | | | |
| pinv_ndc_code | varchar(30) | NO | | | | |
| pinv_refused | char(1) | NO | 0 | | | |
| pinv_refused_id | int(11) | NO | 0 | MUL | | |
| pinv_administered_phy_id | int(11) | NO | 0 | MUL | | |
| pinv_administered_route_id | int(11) | NO | 0 | MUL | | |
| pinv_administered_route_other | varchar(45) | NO | | | | Free text route. |
| pinv_administered_location_id | int(11) | NO | 0 | MUL | | |
| pinv_administered_location_other | varchar(45) | NO | | | | Free text location. |
| pinv_administered_usr_id | int(11) | NO | 0 | MUL | | id of user who administered inventory |
| pinv_administered_amount | varchar(10) | NO | | | | |
| pinv_administered_units | varchar(10) | NO | | | | |
| pinv_administered_multiplier | varchar(5) | YES | 1 | | | The multiplier to apply to the administered amount / units of measure. Example: 1mL (x2). |
| pinv_administered_dt | datetime | YES | | | | |
| pinv_administered_notes | text | NO | | | | |
| pinv_vaccine_funding_program_eligibility_code | varchar(10) | NO | | | | Vaccine Funding Program Eligibility (State and Ins dependent) |
| pinv_deleted | char(1) | NO | 0 | | | |
| pinv_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| pinv_created | timestamp | YES | CURRENT_TIMESTAMP | | | |
| pinv_created_by_usr_id | int(11) | NO | 0 | | | id of user who created inventory |