A database table to save the Magento 2 store data can be created using two methods. One of the methods to create a new database table in Magento 2.3 is with the db_schema.xml file.
The post shows how to create schema file to create new database table in Magento 2.3.
Apart from the below code, you can refer DB schema structure for Magento 2.
Method to Create Schema File To Create New Database Table in Magento 2.3:
Create db_schema.xml file at app/code/Vendor/Extension/etc/ directory
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | <?xml version="1.0"?> <schema xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Setup/Declaration/Schema/etc/schema.xsd"> <table name="my_custom_table" resource="default" engine="innodb" comment="Custom New Table"> <column xsi:type="int" name="entity_id" padding="10" unsigned="true" nullable="false" identity="true" comment="Entity Id"/> <column xsi:type="varchar" name="fullname" nullable="true" length="50" comment="Full name"/> <column xsi:type="varchar" name="email" nullable="true" length="255" comment="Email"/> <column xsi:type="smallint" name="store_id" padding="5" unsigned="true" nullable="true" identity="false" default="0" comment="Store Id"/> <column xsi:type="timestamp" name="created_at" on_update="false" nullable="false" default="CURRENT_TIMESTAMP" comment="Created At"/> <column xsi:type="timestamp" name="updated_at" on_update="true" nullable="false" default="CURRENT_TIMESTAMP" comment="Updated At"/> <column xsi:type="smallint" name="is_active" padding="5" unsigned="true" nullable="false" identity="false" default="1" comment="Is Active"/> <column xsi:type="date" name="dob" comment="Date of Birth"/> <column xsi:type="text" name="description" nullable="true" comment="Description"/> <constraint xsi:type="primary" referenceId="PRIMARY"> <column name="entity_id"/> </constraint> </table> </schema> |
That’s it.
The next step is to create a new database table in Magento 2.3.
The doubts in the implementation of creating a schema file for creating a new database table in your Magento 2.3 store can be mentioned in the Comments section below. I’d be happy to help.
Do share the solution with fellow developers of Magento community via social media.
Thanks.
