View lawprod.MSCM.OPERATOR_ACTIVITY_CYCLE_C Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
FIRST_SCAN date 7  √  null
LAST_SCAN date 7  √  null
COMPANY_NO number 4
COMPANY.COMPANY_NO Implied Constraint R
SELECT_ID varchar2 5
LINE_ITEMS_COUNTED number 22  √  null
TOTAL_QTY_COUNTED number 22  √  null
USER_ID number 22
USERS.USER_ID Implied Constraint R

Analyzed at Wed May 18 12:10 CDT 2011

View Definition:
SELECT (SELECT MIN(EVENT_TIMESTAMP) FROM EVENT_DETAIL WHERE EVENT_HEADER_ID=EH.EVENT_HEADER_ID) FIRST_SCAN, (SELECT MAX(EVENT_TIMESTAMP) FROM EVENT_DETAIL WHERE EVENT_HEADER_ID=EH.EVENT_HEADER_ID) LAST_SCAN, COMPANY_NO, SELECT_ID, (SELECT COUNT(1) FROM EVENT_DETAIL WHERE EVENT_HEADER_ID=EH.EVENT_HEADER_ID) LINE_ITEMS_COUNTED, (SELECT SUM(QUANTITY) FROM EVENT_DETAIL WHERE EVENT_HEADER_ID=EH.EVENT_HEADER_ID AND QUANTITY IS NOT NULL) TOTAL_QTY_COUNTED, USER_ID FROM EVENT_HEADER EH, COUNTFORM CF WHERE CF.COUNTFORM_ID = EH.EVENT_HEADER_GT_01 AND EVENT_TYPE='CYCLE'
 
Possibly Referenced Tables/Views:
COUNTFORM EVENT_DETAIL EVENT_HEADER 


Close relationships: