Table creation for CRUD

Before creating the table, the definition should be clear for the CRUD. Fields for the Employees are as below:

1. Firstname
2. Last Name
3. Gender 
4. BirthDate
5. Joining Date
6. Image
7. Bio
8. Experience
9. Salary
10. Languages
11. Country
12. Education (option for add multiple)
    1. Title
    2. Start date
    3. End Date
    4. CGPA
    5. University
    6. Roll number

Education field will be used for multiple entries like one employee can have multiple degrees and should fill the details for those degrees, so another table will be created for Education field and link both tables with 1:n relation like one employee will have multiple educations/degrees.

Let’s start to create a custom table with TYPO3.
TYPO3 provides an option to define tables in the ext_tables.sql file.