Field type | AppGini 23.11

Discussions related to customizing hooks. Hooks are documented at http://bigprof.com/appgini/help/advanced-topics/hooks/
Post Reply
Moh Youba
Veteran Member
Posts: 228
Joined: 2017-03-12 09:31

Field type | AppGini 23.11

Post by Moh Youba » 2023-05-12 18:58

Hello
Any help please, what is the best practice to link tables. I have 2 tables.

TableOne
• Id
• Name
• Link2table2
TableTwo
• Id
• Name
• Link2table1
I want to link :
Link2table1 to Link2table2
What is the settings of links field, can I just choose “varchar” or is it necessary to set to another type and set to “unique”?
Thank you

User avatar
jsetzer
AppGini Super Hero
AppGini Super Hero
Posts: 1807
Joined: 2018-07-06 06:03
Location: Kiel, Germany
Contact:

Re: Field type | AppGini 23.11

Post by jsetzer » 2023-05-12 19:18

It depends on what you want to save.
  • id (primary key)?
  • URL (href)?
  • reference as a combination of tablename and primary key for example as string like "notes-122" or as json object?
There are many ways. In most of the mentioned options a varchar field with appropriate length should be fine.

What did you try so far and does it work?
Kind regards,
<js />

My AppGini Blog:
https://appgini.bizzworxx.de/blog

You can help us helping you:
Please always put code fragments inside [code]...[/code] blocks for better readability

AppGini 24.10 Revision 1579 + all AppGini Helper tools

Moh Youba
Veteran Member
Posts: 228
Joined: 2017-03-12 09:31

Re: Field type | AppGini 23.11

Post by Moh Youba » 2023-05-13 10:10

Hello sir

Thank you for your comment. I am just creating simple link, just was curious to know if there are specific way to do.

All my best

Post Reply