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 #7562 is a reply to message #7561]

Wed, 13 January 2021 05:25

AJM
Messages: 2369
Registered: April 2006
Location: Surrey, UK

Senior Member

My Tree Structure is not a universal design for all possible hierarchical structures, so may not be the most optimal solution in all circumstances. For example, in my ERP system I have a PRODUCT subsystem which needs to include a Bill Of Materials (BOM) which can go down many levels. For this I have a single table which holds the entire hierarchy using just 3 columns - product_id_snr, product_id_jnr and quantity.

You should start by drawing a structure diagram which shows all the levels in your hierarchy and identify which are nodes and which are leaves. Remember that an outside table, such as PLAYER, could include a node_id column as a foreign key which points to one of the entries, at any level, in the tree structure.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

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: Mon Nov 25 06:00:40 EST 2024

Total time taken to generate the page: 0.01394 seconds