Naming Conventions For Newly Created Database Objects
——
V_: View
——
AD:
and
AD_2019: All Data
Data derived from VAERSDATA, that contains All Data from the years 1990 to early 2020.
See:
Loading the 2019 VAERS MDB Access File into SQL Server
——
2019: Data for individual years only
From the yearly CSV files
ie. 2019VAERSDATA, 2019VAERSSYMPTOMS, 2019VAERSVAX
See:
Loading the 2019 VAERS CSV Datasets into SQL Server
——
_NORM: Renormalized data
Data taken from a denormalized table.
Ie. Multiple VAX on a single row, then
Renormalized:
Each VAX is on a separate row. Used for calculations in SQL
—–