Pinnacle_Avamere_Import

461 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
TableID int identity 4 √ null
company varchar 100 √ null
region varchar 100 √ null
location_name varchar 100 √ null
alias varchar 100 √ null
date date 6 √ null
status varchar 50 √ null
self varchar 50 √ null
overall_satisfaction varchar 10 √ null
personal_care varchar 10 √ null
variety_of_food_menu_choices varchar 10 √ null
quality_of_food varchar 10 √ null
dining_service varchar 10 √ null
cleanliness varchar 10 √ null
response_to_problems varchar 10 √ null
dignity_and_respect varchar 10 √ null
communication varchar 10 √ null
activities varchar 10 √ null
move_in_process varchar 10 √ null
transportation_needs varchar 10 √ null
safety_and_security varchar 10 √ null
recommend_to_others varchar 10 √ null
customerID varchar 25 √ null
location_id varchar 25 √ null
response_id varchar 25 √ null
CA int 4 √ null
CB int 4 √ null
CC int 4 √ null
CD int 4 √ null
CreatedDate datetime 16,3 √ (getdate())

Indexes

Constraint Name Type Sort Column(s)
PK__Pinnacle__7D5F018EE6D29166 Primary key Asc TableID

Diagram producer might be missing

No diagrams were produced please see application output for any errors