I can retrieve my customer's credit card number and pan hash from a payment solution as follows:
492500******1234
The payment solution I use can generate different pan hashes each time for the same credit card, so this causes multiple records for the same card in my database. To prevent this I am thinking to make the card number column (which stores values as seen above) unique to provide uniqueness. Does this number is unique? At least for each customer?