" /> Call UUID as primary key in master table - Genesys CTI User Forum
« previous next »
Pages: [1]   Go Down

Author Topic: Call UUID as primary key in master table  (Read 3590 times)

Offline Prithy

  • Newbie
  • *
  • Posts: 14
  • Karma: 0
Call UUID as primary key in master table
« on: January 06, 2016, 10:22:55 AM »
Advertisement
Hi all,

Could we use the Genesys system variable - CallUUID as the primary key for logging in our DB.
Are there any limitations of using the same.

Please share.

Thanks,
Logged

Offline Kubig

  • Hero Member
  • *****
  • Posts: 2755
  • Karma: 44
Re: Call UUID as primary key in master table
« Reply #1 on: January 06, 2016, 01:21:35 PM »
It depends on what you want to log into database. CallUUID is a unique key for interaction, but interaction might have several parts, so in case where you will store all parts as separated row/record, the CallUUID will not be unique for this.
Logged

Offline Prithy

  • Newbie
  • *
  • Posts: 14
  • Karma: 0
Re: Call UUID as primary key in master table
« Reply #2 on: January 07, 2016, 11:10:34 AM »
Hi Kubig,

We wanted to log the CallUUID as a unique key for a customer inbound call. Could you please also help us in the length of the CallUUID to allocate the field length in the table.

Thanks,
Logged

Offline Kubig

  • Hero Member
  • *****
  • Posts: 2755
  • Karma: 44
Re: Call UUID as primary key in master table
« Reply #3 on: January 07, 2016, 12:08:20 PM »
varchar2(50 char) is enough for this type of data
Logged

Offline Prithy

  • Newbie
  • *
  • Posts: 14
  • Karma: 0
Re: Call UUID as primary key in master table
« Reply #4 on: January 07, 2016, 12:22:45 PM »
Many Thanks to you ..
Logged
Pages: [1]   Go Up
« previous next »