Ygthkb

Notes in a lick that don't fit in the scale associated with the chord

Why avoid shared user accounts?

Broken patches on a road

How to avoid being sexist when trying to employ someone to function in a very sexist environment?

A starship is travelling at 0.9c and collides with a small rock. Will it leave a clean hole through, or will more happen?

Chess tournament winning streaks

What's a good word to describe a public place that looks like it wouldn't be rough?

If I delete my router's history can my ISP still provide it to my parents?

What's the most convenient time of year to end the world?

Why did other German political parties disband so fast when Hitler was appointed chancellor?

Check if the digits in the number are in increasing sequence in python

How should I handle players who ignore the session zero agreement?

Why is working on the same position for more than 15 years not a red flag?

What to do when being responsible for data protection in your lab, yet advice is ignored?

How would an AI self awareness kill switch work?

Can you earn endless XP using a Flameskull and its self-revival feature?

How to prevent users from executing commands through browser URL

Groups acting on trees

How can animals be objects of ethics without being subjects as well?

Contest math problem about crossing out numbers in the table

Why did the villain in the first Men in Black movie care about Earth's Cockroaches?

Caruana vs Carlsen game 10 (WCC) why not 18...Nxb6?

Can we use the stored gravitational potential energy of a building to produce power?

Does Windows 10's telemetry include sending *.doc files if Word crashed?

Percentage sharing for N number of users

0

I have table like following

Id UserName PercentSharing ParentId

1  one      20             0

2  two      80             1

3  three    40             2

4  four     50             2

5  five     20             3

6  six      30             3

I want to calculate that all level should not exceed above 100%

If I change PercentSharing for Id 2 as 70 it's parent should be updated to 30 and If any percent sharing users Id 3 or 4 to any other values then it should maintain percent sharing to 100% for all parent users. e.g. user Ids 3,2,1 total should not exceed beyond 100%

I want to maintain 100% ratio for N number or level.

Please suggest do I need to change table structure?

mysql relational-theory hierarchy

share

asked 1 min ago

Kalpesh JoshiKalpesh Joshi

1

New contributor

Kalpesh Joshi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I have table like following

Id UserName PercentSharing ParentId

1  one      20             0

2  two      80             1

3  three    40             2

4  four     50             2

5  five     20             3

6  six      30             3

I want to calculate that all level should not exceed above 100%

If I change PercentSharing for Id 2 as 70 it's parent should be updated to 30 and If any percent sharing users Id 3 or 4 to any other values then it should maintain percent sharing to 100% for all parent users. e.g. user Ids 3,2,1 total should not exceed beyond 100%

I want to maintain 100% ratio for N number or level.

Please suggest do I need to change table structure?

mysql relational-theory hierarchy

share

asked 1 min ago

Kalpesh JoshiKalpesh Joshi

1

New contributor

Kalpesh Joshi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I have table like following

Id UserName PercentSharing ParentId

1  one      20             0

2  two      80             1

3  three    40             2

4  four     50             2

5  five     20             3

6  six      30             3

I want to calculate that all level should not exceed above 100%

If I change PercentSharing for Id 2 as 70 it's parent should be updated to 30 and If any percent sharing users Id 3 or 4 to any other values then it should maintain percent sharing to 100% for all parent users. e.g. user Ids 3,2,1 total should not exceed beyond 100%

I want to maintain 100% ratio for N number or level.

Please suggest do I need to change table structure?

mysql relational-theory hierarchy

share

asked 1 min ago

Kalpesh JoshiKalpesh Joshi

1

New contributor

Kalpesh Joshi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

Id UserName PercentSharing ParentId

1  one      20             0

2  two      80             1

3  three    40             2

4  four     50             2

5  five     20             3

6  six      30             3

share

asked 1 min ago

Kalpesh JoshiKalpesh Joshi

1

New contributor

Kalpesh Joshi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 1 min ago

Kalpesh JoshiKalpesh Joshi

1

New contributor

Kalpesh Joshi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 1 min ago

Kalpesh JoshiKalpesh Joshi

1

New contributor

Kalpesh Joshi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 1 min ago

Kalpesh JoshiKalpesh Joshi

1