Default - The DEFAULT constraint is used to provide a default value for a column.
Index - Indexes are used to retrieve data from the database more quickly than otherwise. The users cannot see the indexes; they are just used to speed up searches/queries.
Auto Increment - Auto-increment allows a unique number to be generated automatically when a new record is inserted into a table.
