1 more table
referencedColumnNames="id"/>
</changeSet>
+ <changeSet id="Bilonizhka17" author="Oleh Bilonizhka">
+ <createTable tableName="order_employee">
+ <column name="order_id" type="BIGINT">
+ <constraints nullable="false"/>
+ </column>
+ <column name="employee_id" type="BIGINT">
+ <constraints nullable="false"/>
+ </column>
+ </createTable>
+
+ <addForeignKeyConstraint baseTableName="order_employee" baseColumnNames="order_id" constraintName="order_employee_orderId_FC" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION"
+ onUpdate="NO ACTION" referencedTableName="orders"
+ referencedColumnNames="id"/>
+ <addForeignKeyConstraint baseTableName="order_employee" baseColumnNames="employee_id" constraintName="order_employee_employeeID_FC" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION"
+ onUpdate="NO ACTION" referencedTableName="employees"
+ referencedColumnNames="id"/>
+
+ </changeSet>
+
</databaseChangeLog>
\ No newline at end of file
