# Bug empty releations \[Jul 22\]

**URL:** <https://community.nocodb.com/t/bug-empty-releations-jul-22/617>\
**Category:** Discord-Discussions\
**Created:** [November 3, 2022, 10:32am UTC](https://community.nocodb.com/t/bug-empty-releations-jul-22/617 "2022-11-03T10:32:09Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:32am UTC](https://community.nocodb.com/t/bug-empty-releations-jul-22/617/1 "2022-11-03T10:32:10Z")

</div>

> 🙋‍♂️ **lublak** _asked_

## I have a strange behaviour: empty relations

 ![image0](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/ec04a472e34a34c536232c5f019bfd93e45c791f.png)

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:32am UTC](https://community.nocodb.com/t/bug-empty-releations-jul-22/617/2 "2022-11-03T10:32:11Z")

</div>

> 🙋‍♂️ **lublak** _replied_

#### This is actually a “to many” relationship.

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:32am UTC](https://community.nocodb.com/t/bug-empty-releations-jul-22/617/3 "2022-11-03T10:32:12Z")

</div>

> 🙋‍♂️ **lublak** _replied_

#### If i click on them (also empty):

 ![image0](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/89da18bd3eecbe331b6635c74d2229703272eae6.png)

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:32am UTC](https://community.nocodb.com/t/bug-empty-releations-jul-22/617/4 "2022-11-03T10:32:13Z")

</div>

> 🙋‍♂️ **lublak** _replied_

#### The PurchasingPages table:

 ![image0](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/581702498406f1c4a62635c9907f3ba27d0e679c.png)

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:32am UTC](https://community.nocodb.com/t/bug-empty-releations-jul-22/617/5 "2022-11-03T10:32:14Z")

</div>

> 🙋‍♂️ **lublak** _replied_

#### so the other way round it shows everything ok.

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:32am UTC](https://community.nocodb.com/t/bug-empty-releations-jul-22/617/6 "2022-11-03T10:32:15Z")

</div>

> 🙋‍♂️ **lublak** _replied_

#### The ddls:

#### 

#### ```sql

#### CREATE TABLE purchasing\_pages (

#### purchasing\_id int8 NOT NULL,

#### page\_path varchar(255) NOT NULL,

#### CONSTRAINT purchasing\_pages\_check\_page\_path CHECK (((page\_path)::text ~ ‘^([a-zA-Z0-9-\_]+/)+[a-zA-Z0-9-\_ ~]+.[tT][iI][fF]’::text)),

#### CONSTRAINT purchasing\_pages\_purchasing\_id\_page\_path\_key UNIQUE (purchasing\_id, page\_path)

#### );

#### 

#### ALTER TABLE purchasing\_pages ADD CONSTRAINT purchasing\_pages\_id\_fkey FOREIGN KEY (purchasing\_id) REFERENCES purchasing(id) ON UPDATE CASCADE ON DELETE RESTRICT;

#### ```

#### 

#### ```sql

#### CREATE TABLE purchasing (

#### id int4 NOT NULL GENERATED BY DEFAULT AS IDENTITY,

#### mandant\_id int2 NOT NULL,

#### company\_code int4 NOT NULL,

#### sequence\_number int8 NOT NULL,

#### “year” int2 NOT NULL,

#### “month” int2 NOT NULL,

#### CONSTRAINT purchasing\_check\_month CHECK (((month \>= 1) AND (month \<= 12))),

#### CONSTRAINT purchasing\_check\_year CHECK (((year \>= 2000) AND (year \<= 2100))),

#### CONSTRAINT purchasing\_client\_plant\_sequence\_number\_key UNIQUE (mandant\_id, company\_code, sequence\_number),

#### CONSTRAINT purchasing\_pkey PRIMARY KEY (id)

#### );

#### CREATE INDEX purchasing\_id\_idx ON purchasing USING btree (id);

#### ALTER TABLE purchasing ADD CONSTRAINT purchasing\_company\_code\_fk FOREIGN KEY (company\_code) REFERENCES company\_codes(id);

#### ALTER TABLE purchasing ADD CONSTRAINT purchasing\_mandant\_id\_fkey FOREIGN KEY (mandant\_id) REFERENCES purchasing\_mandant\_names(id) NOT VALID;

#### ```

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:32am UTC](https://community.nocodb.com/t/bug-empty-releations-jul-22/617/7 "2022-11-03T10:32:16Z")

</div>

[Autogenerated from discord](https://discord.com/channels/661905455894888490/999574616810987630)

* * *

#### Join [NocoDB’s](http://www.nocodb.com/) community

[Discord](https://discord.gg/5RgZmkW) • [Twitter](https://twitter.com/nocodb) • [Reddit](https://www.reddit.com/r/NocoDB/) • [Docs](https://docs.nocodb.com/)