Entity Definition

Logical Name : CustomerSurvey
Physical Name : DO_SRVY_CT

A collection of questions or other inquiries for soliciting responses from customers (shoppers too?).

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerSurveyID (PK) A unique retailer assigned identifier for the CustomerSurvery. ID_SRVY_CT Identity integer
CustomerSurveyName A short descriptive name for the CustomerSurvey. NM_SRVY_CT Name varchar(40)
SurveyLinkURI A universal resource identifier used to reference an internet survey . UR_SRVY_LNK DescriptionShort varchar(255)
SurveyDescription Short business description of a customer survey. DE_SRVY DescriptionShort varchar(255)


Parent Entity Verb Phrase Child Entity
CustomerSurvey may reference RetailTransaction
CustomerSurvey contains SurveyQuestion

Logical Views containing CustomerSurvey

Logical View
Logical 02300 - Retail Transaction - Macro View
Logical 07010 - Customer Account Information Extended