Here with a ForeignKey constraint then [Sep 01]

Discord-Discussions
21

:raising_hand_man: Eric replied

e.g. i will have many “parent” records with an attribute pointing to a primary key in another table representing a domain of valid values.

22

:person_tipping_hand: o1lab replied

for this you go to another table to create hasMany :smile: ?

23

:person_tipping_hand: o1lab replied

will not that solve it

24

:raising_hand_man: Eric replied

no… that then makes it so that the keys in the “another table” can only be references by a single entity in the related

25

:raising_hand_man: Eric replied

firefox_QoQtNbWjjs.mp4

26

:person_tipping_hand: o1lab replied

LifeCycle_State

LifeCycle2

There are two columns - are those columns coming from same table ? (looks like)

27

:person_tipping_hand: o1lab replied

can u help describe this is in an github issue

28

:person_tipping_hand: o1lab replied

a fullscreen video will make it really clear

29

:raising_hand_man: Eric replied

sure. will do.

30

:person_tipping_hand: o1lab replied

thank you

31

:raising_hand_man: Eric replied

question.

32

:raising_hand_man: Eric replied

if a sqllite db implements the relationship correctly, will the user interface respect it?

33

:raising_hand_man: Eric replied

i’ll provide the equivalent DDL for the sqllite as well.

34

:person_tipping_hand: o1lab replied

should work

35

:person_tipping_hand: o1lab replied

we infer from existing databases as well

36

Autogenerated from discord

Join NocoDB’s community

Discord • Twitter • Reddit • Docs