ETL_Medicare

148 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
file_key varchar 100 null
Medicare_StateAverages.AVA_FileKey Medicare_StateAverages_FKR
yyyymm_key int 4 null
Medicare_StateAverages.AVA_YYYYMMKey Medicare_StateAverages_FKR
first_of_month date 6 null
source_url varchar 500 √ null
download_path varchar 500 √ null
csv_path varchar 500 √ null
csv_name varchar 100 √ null
message varchar 4000 √ null
retrieval_date datetime2 16,3 √ null
load_date datetime2 16,3 √ null
ins_date datetime2 16,3 √ (getdate())

Indexes

Constraint Name Type Sort Column(s)
ETL_Medicare_PK Primary key Asc/Asc file_key + yyyymm_key

Relationships

Close relationships within degrees of separation