User Registration Table Structure In Mysql Database.

Registration Table Structure

As a programmer point of view almost each and every project start with this module i.e. registration process. 

In registration process a mini or big html form is displayed on web page. A user fill that form and web script process it for further storage in database.

Although a basic registration process contains email address and password from user and store it into database table. 

The below image is a snapshot of registration table. Image is self explained . There are 10 columns in this table. 

Although above image is self explained but for clarity of field need we have to understand one by one. 

First column is table id. It is used as primary key for this table.

Second one is email address of user.

Third column is password . The password , generally given by user at the time of registration. But it may be auto generated. Generally banking sites uses auto generated passwords for security reasons. 

Fourth one is column, name. It is simply user name.

Fifth column is  date of registration.

Sixth column is time of registration.

Seventh column is IP address of user .

Eight number is address of user.

Ninth column is mobile number of user.

And last one is second or additional mail id.

So this was the registration table structure.