How to create an associated mysql table? what is the book video that is used to operate a single table?

How to create an associated mysql table-PHP, which is usually used for single-table operations, has never made any progress. recently, after reading a few open-source articles, it has become more dynamic. Books and videos that have been read all the time are operations on a single table. Now we need to implement a function to record the field names and tables of some open source CMS data tables. For example, I want to record how ecshop creates an associated mysql table-books and videos that are usually operated on a single table
PHP has been learning little progress. recently I have read a few open-source things, and then I have another dynamics.

Books and videos that have been read all the time are operations on a single table.
Now we need to implement a function to record the field names and tables of some open source CMS data tables.
For example, I want to record all ecshop tables and write the field names, types, and annotations of each table to the database to save them.

Similar to this, I designed such a database in this way. There are two tables.

The first table one (record table information, tabid associated with the tid of the second table)
Auid int (3) auto-increment, primary key
Tabname varchar (30) table name
Tabnote varchar (table comment)
Tabid int (3) associate tid in the two table
Addtime int (10) Add table timestamp


Second table two (record table field information)
Auid int (3) auto-increment, primary key
Tname varchar (30) field name
Ttype varchar (20) field type
Description and comment of the tnote varchar (100) field
Tid int (3) associates tabid of one in the first table

========================================================== =
In this case, how can we automatically associate the database? I just don't know how to implement it. for example, now I insert a piece of data
Table name: article_cat
Table comment: Document category information
Table addition Time: 1395052170
Field: type
Field type: time
Field Description: This is the timestamp.

-----------------------
In this case, how can I insert a database after receiving information through POST?

Insert ......

Is there any problem with the design of the above table? do you have to set the table-related fields to primary keys.

------ Solution --------------------
The auid and tabid in the first table are repeated. you can use one.
If there is no automatic association, you need to write data in the association field.