Main Tables Views Indexes Constraints Triggers Procedures Functions Packages Sanity check Index

ACS3 Data Model

Description Columns Query Constraints Triggers

SURVSIMP_RESPONSES_UNIQUE

Columns

NameTypeNullableInsertableUpdatableDeletableComment
RESPONSE_IDNUMBER(38)NYESYESYES 
SURVEY_IDNUMBER(38)NYESYESYES 
SCOPEVARCHAR2(20.0)YYESYESYES 
USER_IDNUMBER(38)YYESYESYES 
GROUP_IDNUMBER(38)YYESYESYES 
TITLEVARCHAR2(100.0)YYESYESYES 
SUBMISSION_DATEDATENYESYESYES 
IP_ADDRESSVARCHAR2(50.0)YYESYESYES 
NOTIFY_ON_COMMENT_PCHAR(1.0)YYESYESYES 
PROPOSAL_STATEVARCHAR2(30.0)YYESYESYES 

Query:

select r1.* from survsimp_responses r1
where r1.response_id=(select max(r2.response_id)
                        from survsimp_responses r2
                       where r1.survey_id=r2.survey_id
                         and r1.user_id=r2.user_id)


Generated by OraSchemaDoc, (c) Aram Kananov, 2002