Jump to: navigation, search

In the Column List:

  • P = Primary key
  • M = Mandatory field
  • F = Foreign key

Table G_SAMPLE_CUST_ADATA


This sample table stores attached call data from a custom attached data dispatcher.

Column List

Legend

Column Data Type P M F Description

ID

NUMERIC(16) X X The unique, autonumbered ID of this record. This is the primary key.

CALLID

VARCHAR(50) X Global unique call ID.

CALL_TS

INTEGER X The timestamp of call creation.

Switch_ID

INTEGER X The DBID of the Switch configuration object in Configuration Server where the call was observed.

Tenant_ID

INTEGER X The DBID of the Tenant where the Switch is configured.

C_INT_1

INTEGER The integer value of attached data key.

C_INT_2

INTEGER The integer value of attached data key.

C_INT_3

INTEGER The integer value of attached data key.

C_INT_4

INTEGER The integer value of attached data key.

C_INT_5

INTEGER The integer value of attached data key.

C_INT_6

INTEGER The integer value of attached data key.

C_INT_7

INTEGER The integer value of attached data key.

C_INT_8

INTEGER The integer value of attached data key.

C_INT_9

INTEGER The integer value of attached data key.

C_INT_10

INTEGER The integer value of attached data key.

C_INT_11

INTEGER The integer value of attached data key.

C_INT_12

INTEGER The integer value of attached data key.

C_INT_13

INTEGER The integer value of attached data key.

C_INT_14

INTEGER The integer value of attached data key.

C_INT_15

INTEGER The integer value of attached data key.

C_INT_16

INTEGER The integer value of attached data key.

C_INT_17

INTEGER The integer value of attached data key.

C_INT_18

INTEGER The integer value of attached data key.

C_INT_19

INTEGER The integer value of attached data key.

C_INT_20

INTEGER The integer value of attached data key.

C_INT_21

INTEGER The integer value of attached data key.

C_INT_22

INTEGER The integer value of attached data key.

C_INT_23

INTEGER The integer value of attached data key.

C_INT_24

INTEGER The integer value of attached data key.

C_INT_25

INTEGER The integer value of attached data key.

C_INT_26

INTEGER The integer value of attached data key.

C_INT_27

INTEGER The integer value of attached data key.

C_INT_28

INTEGER The integer value of attached data key.

C_INT_29

INTEGER The integer value of attached data key.

C_INT_30

INTEGER The integer value of attached data key.

C_INT_31

INTEGER The integer value of attached data key.

C_INT_32

INTEGER The integer value of attached data key.

C_INT_33

INTEGER The integer value of attached data key.

C_INT_34

INTEGER The integer value of attached data key.

C_STR_1

VARCHAR(10) The string value of the call attached data key.

C_STR_2

VARCHAR(10) The string value of the call attached data key.

C_STR_3

VARCHAR(10) The string value of the call attached data key.

C_STR_4

VARCHAR(10) The string value of the call attached data key.

C_STR_5

VARCHAR(10) The string value of the call attached data key.

C_STR_6

VARCHAR(10) The string value of the call attached data key.

C_STR_7

VARCHAR(10) The string value of the call attached data key.

C_STR_8

VARCHAR(10) The string value of the call attached data key.

C_STR_9

VARCHAR(10) The string value of the call attached data key.

C_STR_10

VARCHAR(10) The string value of the call attached data key.

C_STR_11

VARCHAR(10) The string value of the call attached data key.

C_STR_12

VARCHAR(10) The string value of the call attached data key.

C_STR_13

VARCHAR(10) The string value of the call attached data key.

C_STR_14

VARCHAR(10) The string value of the call attached data key.

C_STR_15

VARCHAR(10) The string value of the call attached data key.

C_STR_16

VARCHAR(10) The string value of the call attached data key.

C_STR_17

VARCHAR(10) The string value of the call attached data key.

C_STR_18

VARCHAR(10) The string value of the call attached data key.

C_STR_19

VARCHAR(10) The string value of the call attached data key.

C_STR_20

VARCHAR(10) The string value of the call attached data key.

C_STR_21

VARCHAR(10) The string value of the call attached data key.

C_STR_22

VARCHAR(10) The string value of the call attached data key.

C_STR_23

VARCHAR(10) The string value of the call attached data key.

C_STR_24

VARCHAR(10) The string value of the call attached data key.

C_STR_25

VARCHAR(10) The string value of the call attached data key.

C_STR_26

VARCHAR(10) The string value of the call attached data key.

C_STR_27

VARCHAR(10) The string value of the call attached data key.

C_STR_28

VARCHAR(10) The string value of the call attached data key.

C_STR_29

VARCHAR(10) The string value of the call attached data key.

C_STR_30

VARCHAR(10) The string value of the call attached data key.

C_STR_31

VARCHAR(10) The string value of the call attached data key.

C_STR_32

VARCHAR(10) The string value of the call attached data key.

C_STR_33

VARCHAR(10) The string value of the call attached data key.

C_STR_34

VARCHAR(10) The string value of the call attached data key.

GSYS_DOMAIN

INTEGER Reserved

GSYS_PARTITION

INTEGER A key that is used for partitioning.

GSYS_SYS_ID

INTEGER System ID. Reserved for future use.

GSYS_SEQ

BIGINT Insert Sequence. Not unique.

GSYS_USEQ

BIGINT Update Sequence. Not unique.

GSYS_TS

TIMESTAMP Reserved

GSYS_TC

INTEGER Reserved

GSYS_EXT_VCH1

VARCHAR(255) Reserved

GSYS_EXT_VCH2

VARCHAR(255) Reserved

GSYS_EXT_INT1

INTEGER Reserved

GSYS_EXT_INT2

INTEGER Reserved


Index List

Index Name U C

IDX_G_SAMPLE_CDATA_TS

 

 

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on 31 October 2016, at 16:08.