# Foreign key created with NO\_CONSTRAINT in @SecondaryTable

**URL:** <https://discourse.hibernate.org/t/foreign-key-created-with-no-constraint-in-secondarytable/7380>\
**Category:** Hibernate ORM\
**Created:** [March 14, 2023, 11:20pm UTC](https://discourse.hibernate.org/t/foreign-key-created-with-no-constraint-in-secondarytable/7380 "2023-03-14T23:20:50Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![darkjenum](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/darkjenum/32/2315_2.png) [@darkjenum](https://discourse.hibernate.org/u/darkjenum)\
**Post date:** [March 14, 2023, 11:20pm UTC](https://discourse.hibernate.org/t/foreign-key-created-with-no-constraint-in-secondarytable/7380/1 "2023-03-14T23:20:50Z")

</div>

Good evening everyone!

I have 2 entity:

```auto
@Entity
@Table(name = "order")
public class Order {
...
// There are no any links to OrderPlacementProcessStatus
}

```

```auto
@Entity
@Table(name = "order_placement_queue")
@SecondaryTable(
		name = "order",
		pkJoinColumns = @PrimaryKeyJoinColumn(
				name = "id",
				referencedColumnName = "order_id"),
		foreignKey = @ForeignKey(name = "none", value = ConstraintMode.NO_CONSTRAINT))
public class OrderPlacementProcessStatus {
...
	@Column(table = "order", name = "order_v_id", updatable = false, insertable = false)
	private UUID orderIdV;
}

```

When i start application, it is try to create foreign key on table order:

```auto
alter table if exists "order" add constraint "FKbcnbso1dwhkiocq7lqhvphg77" foreign key ("id") references "order_placement_queue"

```

despite on

```auto
@ForeignKey(name = "none", value = ConstraintMode.NO_CONSTRAINT).

```

What am i doing wrong?

---

<div class="post-metadata">

**Author:** ![beikov](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/beikov/32/258_2.png) [@beikov](https://discourse.hibernate.org/u/beikov)\
**Post date:** [March 15, 2023, 8:42am UTC](https://discourse.hibernate.org/t/foreign-key-created-with-no-constraint-in-secondarytable/7380/2 "2023-03-15T08:42:58Z")

</div>

Could be a bug. Please create an issue in the issue tracker([https://hibernate.atlassian.net](https://hibernate.atlassian.net)) with a test case([hibernate-test-case-templates/JPAUnitTestCase.java at main · hibernate/hibernate-test-case-templates · GitHub](https://github.com/hibernate/hibernate-test-case-templates/blob/master/orm/hibernate-orm-6/src/test/java/org/hibernate/bugs/JPAUnitTestCase.java)) that reproduces the issue.