View ESEC.ESECDBA.EVENTS_ALL_V Generated by
SchemaSpy
Legend: SourceForge.net
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
EVT_ID varchar2 108
EVT_TIME date 7
RV39 varchar2 765  √  null
RES varchar2 765  √  null
SRES varchar2 765  √  null
SEV number 22  √  null
ARCH_ID number 22  √  null
DEVICE_EVT_TIME date 7  √  null
SENTINEL_PROCESS_TIME date 7  √  null
BEGIN_TIME date 7  √  null
END_TIME date 7  √  null
REPEAT_CNT number 22  √  null
DP_INT number 22  √  null
SP_INT number 22  √  null
MSG varchar2 4000  √  null
EVT varchar2 765  √  null
ET varchar2 765  √  null
SN varchar2 765  √  null
ST varchar2 15  √  null
PROTOCOL varchar2 765  √  null
SIP number 22  √  null
SHN varchar2 765  √  null
SP varchar2 96  √  null
DIP number 22  √  null
DHN varchar2 765  √  null
DP varchar2 96  √  null
SUN varchar2 765  √  null
DUN varchar2 765  √  null
FN varchar2 3000  √  null
EI varchar2 3000  √  null
RN varchar2 765  √  null
PN varchar2 765  √  null
CT1 varchar2 765  √  null
CT2 varchar2 765  √  null
CT3 number 22  √  null
RT1 varchar2 765  √  null
RT2 varchar2 765  √  null
RT3 number 22  √  null
SRC_ID varchar2 108  √  null
PORT varchar2 192  √  null
AGENT varchar2 192  √  null
VULN number 22  √  null
CRIT number 22  √  null
RV01 number 22  √  null
RV02 number 22  √  null
RV03 number 22  √  null
RV04 number 22  √  null
RV05 number 22  √  null
RV06 number 22  √  null
RV07 number 22  √  null
RV08 number 22  √  null
RV09 number 22  √  null
RV10 number 22  √  null
RV11 date 7  √  null
RV12 date 7  √  null
RV13 date 7  √  null
RV14 date 7  √  null
RV15 date 7  √  null
RV16 date 7  √  null
RV17 date 7  √  null
RV18 date 7  √  null
RV19 date 7  √  null
RV20 date 7  √  null
RV21 varchar2 108  √  null
RV22 varchar2 108  √  null
RV23 varchar2 108  √  null
RV24 varchar2 108  √  null
RV25 varchar2 108  √  null
RV26 varchar2 765  √  null
RV27 varchar2 765  √  null
RV28 varchar2 765  √  null
RV29 varchar2 765  √  null
RV30 varchar2 765  √  null
RV31 varchar2 765  √  null
RV32 varchar2 765  √  null
RV33 varchar2 765  √  null
RV34 varchar2 765  √  null
RV35 varchar2 765  √  null
RV36 varchar2 765  √  null
RV37 varchar2 765  √  null
RV38 varchar2 765  √  null
RV40 varchar2 765  √  null
RV41 varchar2 765  √  null
RV42 varchar2 765  √  null
RV43 varchar2 765  √  null
RV44 varchar2 765  √  null
RV45 varchar2 765  √  null
RV46 varchar2 765  √  null
RV47 varchar2 765  √  null
RV48 varchar2 765  √  null
RV49 varchar2 765  √  null
RV50 varchar2 300  √  null
RV51 varchar2 300  √  null
RV52 varchar2 300  √  null
RV53 varchar2 300  √  null
CV01 number 22  √  null
CV02 number 22  √  null
CV03 number 22  √  null
CV04 number 22  √  null
CV05 number 22  √  null
CV06 number 22  √  null
CV07 number 22  √  null
CV08 number 22  √  null
CV09 number 22  √  null
CV10 number 22  √  null
CV11 date 7  √  null
CV12 date 7  √  null
CV13 date 7  √  null
CV14 date 7  √  null
CV15 date 7  √  null
CV16 date 7  √  null
CV17 date 7  √  null
CV18 date 7  √  null
CV19 date 7  √  null
CV20 date 7  √  null
CV21 varchar2 765  √  null
CV22 varchar2 765  √  null
CV23 varchar2 765  √  null
CV24 varchar2 765  √  null
CV25 varchar2 765  √  null
CV26 varchar2 765  √  null
CV27 varchar2 765  √  null
CV28 varchar2 765  √  null
CV29 varchar2 765  √  null
CV30 varchar2 4000  √  null
CV31 varchar2 4000  √  null
CV32 varchar2 4000  √  null
CV33 varchar2 4000  √  null
CV34 varchar2 4000  √  null
CV35 varchar2 765  √  null
CV36 varchar2 765  √  null
CV37 varchar2 765  √  null
CV38 varchar2 765  √  null
CV39 varchar2 765  √  null
CV40 varchar2 765  √  null
CV41 varchar2 765  √  null
CV42 varchar2 765  √  null
CV43 varchar2 765  √  null
CV44 varchar2 765  √  null
CV45 varchar2 765  √  null
CV46 varchar2 765  √  null
CV47 varchar2 765  √  null
CV48 varchar2 765  √  null
CV49 varchar2 765  √  null
CV50 varchar2 765  √  null
CV51 varchar2 765  √  null
CV52 varchar2 765  √  null
CV53 varchar2 765  √  null
CV54 varchar2 765  √  null
CV55 varchar2 765  √  null
CV56 varchar2 765  √  null
CV57 varchar2 765  √  null
CV58 varchar2 765  √  null
CV59 varchar2 765  √  null
CV60 varchar2 765  √  null
CV61 varchar2 765  √  null
CV62 varchar2 765  √  null
CV63 varchar2 765  √  null
CV64 varchar2 765  √  null
CV65 varchar2 765  √  null
CV66 varchar2 765  √  null
CV67 varchar2 765  √  null
CV68 varchar2 765  √  null
CV69 varchar2 765  √  null
CV70 varchar2 765  √  null
CV71 varchar2 765  √  null
CV72 varchar2 765  √  null
CV73 varchar2 765  √  null
CV74 varchar2 765  √  null
CV75 varchar2 765  √  null
CV76 varchar2 765  √  null
CV77 varchar2 765  √  null
CV78 varchar2 765  √  null
CV79 varchar2 765  √  null
CV80 varchar2 765  √  null
CV81 varchar2 765  √  null
CV82 varchar2 765  √  null
CV83 varchar2 765  √  null
CV84 varchar2 765  √  null
CV85 varchar2 765  √  null
CV86 varchar2 765  √  null
CV87 varchar2 765  √  null
CV88 varchar2 765  √  null
CV89 varchar2 765  √  null
CV90 varchar2 765  √  null
CV91 varchar2 765  √  null
CV92 varchar2 765  √  null
CV93 varchar2 765  √  null
CV94 varchar2 765  √  null
CV95 varchar2 765  √  null
CV96 varchar2 765  √  null
CV97 varchar2 765  √  null
CV98 varchar2 765  √  null
CV99 varchar2 765  √  null
CV100 varchar2 765  √  null
DATE_CREATED date 7  √  null
DATE_MODIFIED date 7  √  null
CREATED_BY number 22  √  null
MODIFIED_BY number 22  √  null

Analyzed at Tue May 04 17:09 EDT 2010

View SQL:
SELECT EVENTS.EVT_ID, EVENTS.EVT_TIME, CUST.CUST_NAME as RV39, EVENTS.RES, EVENTS.SRES,
EVENTS.SEV, EVENTS.ARCH_ID, EVENTS.DEVICE_EVT_TIME, EVENTS.SENTINEL_PROCESS_TIME, EVENTS.BEGIN_TIME, EVENTS.END_TIME, EVENTS.REPEAT_CNT,
EVENTS.DP_INT, EVENTS.SP_INT, EVENTS.MSG, EVENTS.EVT, EVENTS.ET, EVT_AGENT.SN, EVT_AGENT.ST,
EVT_PRTCL.PRTCL_NAME as PROTOCOL, EVENTS.SIP, EVENTS.SHN, EVENTS.SP, EVENTS.DIP, EVENTS.DHN, EVENTS.DP, EVENTS.SUN,
EVENTS.DUN, EVENTS.FN, EVENTS.EI, EVT_AGENT.RN, EVT_AGENT.PN, EVENTS.CT1, EVENTS.CT2,
EVENTS.CT3, EVENTS.RT1, EVENTS.RT2, EVENTS.RT3, EVT_AGENT.SRC_ID, EVT_AGENT.PORT,
EVT_AGENT.AGENT, EVENTS.VULN, EVENTS.CRIT, EVENTS.RV01, EVENTS.RV02, EVENTS.RV03, EVENTS.RV04, EVENTS.RV05,
EVENTS.RV06, EVENTS.RV07, EVENTS.RV08, EVENTS.RV09, EVENTS.RV10, EVENTS.RV11, EVENTS.RV12, EVENTS.RV13,
EVENTS.RV14, EVENTS.RV15, EVENTS.RV16, EVENTS.RV17, EVENTS.RV18, EVENTS.RV19, EVENTS.RV20, EVENTS.RV21,
EVENTS.RV22, EVENTS.RV23, EVENTS.RV24, EVENTS.RV25, EVENTS.RV26, EVENTS.RV27, EVENTS.RV28, EVENTS.RV29,
EVENTS.RV30, EVENTS.RV31, EVT_AGENT.DEVICE_CTGRY as RV32, EVENTS.RV33, EVENTS.RV34, EVENTS.RV35, EVENTS.RV36,
EVENTS.RV37, EVENTS.RV38,
EVENTS.RV40,EVENTS.RV41, EVENTS.RV42, EVENTS.RV43, EVENTS.RV44,
EVENTS.RV45, EVENTS.RV46, EVENTS.RV47, EVENTS.RV48, EVENTS.RV49,
EVT_TXNMY.TXNMY_LVL_1 as RV50, EVT_TXNMY.TXNMY_LVL_2 as RV51, EVT_TXNMY.TXNMY_LVL_3 as RV52, EVT_TXNMY.TXNMY_LVL_4 as RV53,
EVENTS.CV01, EVENTS.CV02, EVENTS.CV03, EVENTS.CV04, EVENTS.CV05, EVENTS.CV06, EVENTS.CV07, EVENTS.CV08,
EVENTS.CV09, EVENTS.CV10, EVENTS.CV11, EVENTS.CV12, EVENTS.CV13, EVENTS.CV14, EVENTS.CV15, EVENTS.CV16,
EVENTS.CV17, EVENTS.CV18, EVENTS.CV19, EVENTS.CV20, EVENTS.CV21, EVENTS.CV22, EVENTS.CV23, EVENTS.CV24,
EVENTS.CV25, EVENTS.CV26, EVENTS.CV27, EVENTS.CV28, EVENTS.CV29, EVENTS.CV30, EVENTS.CV31, EVENTS.CV32,
EVENTS.CV33, EVENTS.CV34, EVENTS.CV35, EVENTS.CV36, EVENTS.CV37, EVENTS.CV38, EVENTS.CV39, EVENTS.CV40,
EVENTS.CV41, EVENTS.CV42, EVENTS.CV43, EVENTS.CV44, EVENTS.CV45, EVENTS.CV46, EVENTS.CV47, EVENTS.CV48,
EVENTS.CV49, EVENTS.CV50, EVENTS.CV51, EVENTS.CV52, EVENTS.CV53, EVENTS.CV54, EVENTS.CV55, EVENTS.CV56,
EVENTS.CV57, EVENTS.CV58, EVENTS.CV59, EVENTS.CV60, EVENTS.CV61, EVENTS.CV62, EVENTS.CV63, EVENTS.CV64,
EVENTS.CV65, EVENTS.CV66, EVENTS.CV67, EVENTS.CV68, EVENTS.CV69, EVENTS.CV70, EVENTS.CV71, EVENTS.CV72,
EVENTS.CV73, EVENTS.CV74, EVENTS.CV75, EVENTS.CV76, EVENTS.CV77, EVENTS.CV78, EVENTS.CV79, EVENTS.CV80,
EVENTS.CV81, EVENTS.CV82, EVENTS.CV83, EVENTS.CV84, EVENTS.CV85, EVENTS.CV86, EVENTS.CV87, EVENTS.CV88,
EVENTS.CV89, EVENTS.CV90, EVENTS.CV91, EVENTS.CV92, EVENTS.CV93, EVENTS.CV94, EVENTS.CV95, EVENTS.CV96,
EVENTS.CV97, EVENTS.CV98, EVENTS.CV99, EVENTS.CV100, EVENTS.DATE_CREATED, EVENTS.DATE_MODIFIED, EVENTS.CREATED_BY,
EVENTS.MODIFIED_BY
FROM EVENTS, CUST, EVT_AGENT, EVT_PRTCL, EVT_TXNMY
WHERE EVENTS.CUST_ID = CUST.CUST_ID
AND EVENTS.AGENT_ID = EVT_AGENT.AGENT_ID
AND EVENTS.PRTCL_ID = EVT_PRTCL.PRTCL_ID
AND EVENTS.TXNMY_ID = EVT_TXNMY.TXNMY_ID