Is ticket_qrcode or registration_code always unique?

  • Russell Noble
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
3 years 10 months ago #134629 by Russell Noble
Hi Tuan,
we need to create a plugin which provides access for a registrant to print out certain documents from a website.
I want to include in the URL an identifier so we know who it is. Is the ticket_qrcode or registration_code guaranteed to be unique and can be published via email to a registrant so we can use that as the identifier?

In the database they allow NULLs and are not set as a unique by INDEX. I checked and we have some NULL ticket_qrcode (older entries) but both fields appears to be unique, but not sure if that is always true.

Thanks,
Russell

Please Log in or Create an account to join the conversation.

More
3 years 10 months ago #134630 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Is ticket_qrcode or registration_code always unique?
Hi Russell

Both are unique. However, I suggest to use registration_code, it's generated for each registration record. ticket_qrcode as you can guess, could be null for registration records not not have PDF tickets generated

Tuan

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc