Changes the structure of the table. You can only edit tables that meet the following rules:
1. The table is in state DRAFT.
2. the table has a single column auto_increment primary key.
You can change the status of a table whenever you want by clicking on "Edit Status & Description".
The data that is stored in the tables are numbers, texts or dates. If you want to link a column with a user or post the field will be a number and will contain the id of the linked user or post. For wordpress titles, emails and links you can choose to create a line of text instead.
This concept is not unique to mysql, but was added to ensure greater data security. A table in DRAFT state can be edited or deleted.
In the PUBLISHED state, a table can no longer be modified or deleted. In addition, the function to delete all data is disabled.
The CLOSE state does not allow either the modification of the table or the insertion of data.
This state is useful for tables whose data must remain unchanged or can only be modified by the administrator.
The indices are mainly of two types:
Unique it is used to indicate that one or a group of columns must not repeat the same on more than one row
INDEX they are used to speed up the queries in which data is filtered for one or more columns
For example, if the table you are building is always filtered for a "category" column, you may want to add a "category" index to improve performance.
The indexes however increase the time it takes for the database to save o modify a data and the space used.