Welcome Guest, Not a member yet? Register   Sign In
Need your suggestions on a project's "thinking".

You need a unique PIN (at least 10 digit alpha-numeric value) for each user. It will be stored in the User table (#1).

It is not sufficient to match only the email address before writing information to the Contact_info table. Someone could submit a fictitious set of information if all they need is the email address. I would reject any NEW registration if it uses an email address which is already in your Contact_info table. Only one registration allowed for each email address.

Table #3 is probably some other name than "Users" because that is your name for table #1. Perhaps you meant "Pets" as the name for table #3?

This is how I would configure these three tables

-id unique, auto-increment primary key
-PIN unique

-user_id link pointing to Users:id
-name encrypted
-email encrypted

-user_id link pointing to Users:id
CI 3.1 Kubuntu 19.04 Apache 5.x  Mysql 5.x PHP 5.x PHP 7.x
Remember: Obfuscation is a bad thing.
Clarity is desirable over Brevity every time.

Messages In This Thread
RE: Need your suggestions on a project's "thinking". - by twpmarketing - 08-16-2018, 06:44 PM

Theme © iAndrew 2016 - Forum software by © MyBB