Skip to content

Instantly share code, notes, and snippets.

@rickdaalhuizen90

rickdaalhuizen90/db_schema.xml

Created June 25, 2020 16:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rickdaalhuizen90/e11a07e75aedac2ebbfb5fa8a21706be to your computer and use it in GitHub Desktop.
Save rickdaalhuizen90/e11a07e75aedac2ebbfb5fa8a21706be to your computer and use it in GitHub Desktop.
Download ZIP
Magento 2 generated declarative schema
Raw
db_schema.xml
<?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="quote_item_file" resource="default" engine="innodb" comment="Quote Item File Table">
<column xsi:type="int" name="entity_id" padding="11" unsigned="false" nullable="false" identity="true" comment="Entity ID"/>
<column xsi:type="varchar" name="filename" nullable="false" length="255" comment="Filename"/>
<column xsi:type="varchar" name="location" nullable="false" length="255" comment="Location of file"/>
<column xsi:type="int" name="quote_item_item_id" padding="10" unsigned="true" nullable="false" identity="false" comment="Item Id"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="QUOTE_ITEM_FILE_QUOTE_ITEM_ITEM_ID_QUOTE_ITEM_ITEM_ID" table="quote_item_file" column="quote_item_item_id" referenceTable="quote_item" referenceColumn="item_id" onDelete="CASCADE"/>
</table>
</schema>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment