Radicore Forum: Transaction Patterns

Home » RADICORE development » Transaction Patterns » Tree structure

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Tree structure [message #7561 is a reply to message #7560]

Wed, 13 January 2021 04:10

htManager
Messages: 415
Registered: May 2014

Senior Member

I would like you to ask your advice in the following issue:

I want to show a tree structure existing of several (hierarchical) tables. You can imagine this like a sports team diagram, in football/soccer this would be FIFA -> UEFA/AFC/... -> FA/DFB/... -> ... -> Liverpool -> Saisons -> Team A -> Members/Team mates

For example: I have a table where I store the associations and the clubs like FIFA, Liverpool, FA etc. with Key A, Key B, Key C. Then I have a table where I store the teams of a club with Key A, Key B, Key C and Key D. And I have a few tables more.

I do know on which level I want to insert these nodes but how I can build up this in my table structure. Would you advice to insert a coloumn in the tree_node table where I store the tablename to look for the node_id's? If yes, in which function could I check this? Or would it be better to work with a subclass of the tree_nodes table?

On top of this problem I want to design the tree structure in a virtual private database where I can store the associations and the clubs in the shared account and only the teams and the team members are created in the respective accounts to lower the quantity of records. I implemented this in these tables yet and it works fine. I think this should be only a question of the keys and the SQL queries.

Report message to a moderator

[Message index]

		Tree structure By: htManager on Sat, 05 July 2014 06:17
		Re: Tree structure By: AJM on Sun, 06 July 2014 04:40
		Re: Tree structure By: htManager on Mon, 07 July 2014 05:52
		Re: Tree structure By: htManager on Wed, 11 February 2015 11:05
		Re: Tree structure By: AJM on Thu, 12 February 2015 04:34
		Re: Tree structure By: htManager on Thu, 12 February 2015 08:31
		Re: Tree structure By: AJM on Fri, 13 February 2015 05:10
		Re: Tree structure By: htManager on Thu, 26 February 2015 09:12
		Re: Tree structure By: AJM on Sat, 28 February 2015 06:20
		Re: Tree structure By: htManager on Sat, 28 February 2015 08:31
		Re: Tree structure By: AJM on Sun, 01 March 2015 04:23
		Re: Tree structure By: htManager on Mon, 02 March 2015 04:44
		Re: Tree structure By: htManager on Thu, 23 April 2015 11:49
		Re: Tree structure By: AJM on Fri, 24 April 2015 04:07
		Re: Tree structure By: htManager on Mon, 04 May 2015 11:48
		Re: Tree structure By: AJM on Tue, 05 May 2015 04:30
		Re: Tree structure By: htManager on Mon, 01 June 2015 11:32
		Re: Tree structure By: AJM on Tue, 02 June 2015 05:12
		Re: Tree structure By: htManager on Tue, 02 June 2015 10:46
		Re: Tree structure By: AJM on Tue, 02 June 2015 13:05
		Re: Tree structure By: htManager on Mon, 11 January 2021 12:54
		Re: Tree structure By: AJM on Mon, 11 January 2021 13:50
		Re: Tree structure By: htManager on Mon, 11 January 2021 15:47
		Re: Tree structure By: htManager on Wed, 13 January 2021 04:10
		Re: Tree structure By: AJM on Wed, 13 January 2021 05:25
		Re: Tree structure By: htManager on Wed, 13 January 2021 06:13
		Re: Tree structure By: AJM on Thu, 14 January 2021 05:09
		Re: Tree structure By: htManager on Sat, 16 January 2021 03:43
		Re: Tree structure By: AJM on Sat, 16 January 2021 05:06
		Re: Tree structure By: htManager on Sun, 24 January 2021 14:57

Previous Topic:	List view (List3)
Next Topic:	POPUP3 not working

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Apr 25 06:52:57 EDT 2024

Total time taken to generate the page: 0.01233 seconds