Database Design Question for a weird use case

I am having trouble figuring out a good database design for an app I am developing. I have included a description of the related use case in the image below.

How would you design the Work Package in the database? A Project is made up of many Work Packages, which is fine, but a Work Package can also be made up of smaller Work Packages, which can be made up of even smaller Work Packages? How do you design such a ‘nested self’ relation in the database?

Thanks for the help!

Detailed Description

Weird Science gizmos with flexible options: how do they work?

In Savage Worlds Deluxe (SWD), the Weird Scientist can select an arcane power and build a gizmo from it.

I’m not exactly sure how exactly those gizmos are expected to work for powers with flexible options. Should the gizmo retains the flexibility of the original power, or should the Weird Scientist stick to one version of the power for their device?

For example, while using Boost/Lower Trait, other casters can select which trait to boost or lower, and can affect more than one target at the price of one Power Point (PP) per extra target. How much of this flexibility should remain in the gizmo? I could imagine the Weird Scientist creating a very specific device for Boost/Lower Trait, for example a Mind Cap that boost the Smarts of the wearer. Or, the gizmo could be something extremely flexible, for example a general purpose Modification Beam that can boost / lower any trait of any target.

Clearly the more flexible the device, the more useful it is. How much flexibility is intended for the gizmos?

From the example in the book, it seems at least some restrictions are intended for the gizmos. On page 121, Doctor Gold creates a “vibroknife” (a knife with the Smite power), which can do +2/+4 to damage. This is a quite restrictive application of the power. A more flexibility power would be to create some “Enhancement Gloves”, able to enhance the power of any weapon they touch.

For this example, should a GM allow the “Enhancement Gloves” idea? Or are “Smite” gizmos intended to combine with a single weapon only?

Unity : Rotate object on touch looks weird

Touch and hold the screen then rotate object continue("Object is unity default cube") that’s my operation, but when object is Rotate then it’s look like weird.

enter image description hereenter image description here

I upload the example for better understand, it’s looks like above image.

public void StartHold() {     pointerDown = true; } public void StopHold() {     pointerDown = false; } void Update() {   if(pointerDown){     Rotator.transform.Rotate(new Vector3(0, 0, 90) * 2f * Time.deltaTime);   } } 

It’s just simple way to rotate object not to much complication then why object rotation look like this, anyone can know then help me and what is the solution of this problem. Thanks.

Weird usernames (hacked site)

The site I am working on has been hacked, and I did solved some of the issues and “anomalies”, however there is a weird thing happened to the users list that I can’t figure out how to fix.

There is a bunch of new users (160 pages) with similar usernames and email addresses. For example, here are the few of them:

a.a.r.o.nh1562 a.a.r.on.h1.5.62     a.a.r.on.h1.56.2 a.a.r.on.h156.2  a.a.ro.n.h156.2  a.a.ronh15.62 

Did anyone had experience with something like this?

Weird DNS queries to messager.xicp.net

A DNS query for this domain (messager.xicp.net) was classified and detected as “Trojan.Generic.DNS” by the FireEye NX in our network.

So, I used both VirusTotal and abuseibdb sites to check this domain. It seems it’s mapped to 127.0.0.1 (localhost) and when I ping this domain it pings my localhost IP. Could you explain this behavior?

I tried using viewDNS to trace route and I got this output:

traceroute to messager.xicp.net (127.0.0.1), 30 hops max, 60 byte packets 1 obfuscated.internal.network.com (0.0.0.0) 0.000 ms 0.000 ms 0.000 ms 2 obfuscated.internal.network.com (0.0.0.0) 1.000 ms 1.000 ms 1.000 m

Could you please explain this behavior, why it’s mapped to 127.0.0.1 (It wasn’t like this according to the results from VirusTotal as it was mapped to this IP 174.128.255.245 on 2018-04-11)

Weird behavior of `Quantile` function

I found a very strange behavior of Quantile function when evaluating the following expression:

Quantile[TruncatedDistribution[{0, \[Infinity]},    MixtureDistribution[{0.5,      0.5}, {NormalDistribution[30.0505043478260844836,       1.6756943154326708889],      NormalDistribution[30.0505043478260844836,       2.8804367798735217576]}]], 0.5] 

Mathematica was freezing after I hit shift+enter, and there seems to be an infinite loop inside because it kept freezing for a couple of hours.

However, if I change the quantile from 0.5 to 0.500001 it gives me the result immediately.

Or if I remove some digits, e.g., the following:

Quantile[TruncatedDistribution[{0, \[Infinity]},    MixtureDistribution[{0.5,      0.5}, {NormalDistribution[30.0505043478260844836, 1.6756],      NormalDistribution[30.0505043478260844836,       2.8804367798735217576]}]], 0.5] 

(note the 1.6756 v.s. 1.6756943154326708889) gives me the result almost immediately as well.

This is so weird as I don’t see any fundamental differences between these numbers. It should always gives the results immediately.

Is this a BUG or there are some tricky things within these numbers?

System versions:

OS: macOS Catalina 10.15

Mathematica: 12.0.0.0

unity weird window

There is a weird window on my desktop that is not going away. It happens occasionally, I think it is triggered by mouse action:

unity desktop

This window does not belong to any application. Window icons are blanked out as well:

icons, white

It appears on all desktops, I have no idea what this is doing. I am using Ubuntu 16.04

Question:

  1. how do I trigger this behaviour?
  2. what is its purpose?

Ubuntu has extra hidden gamma curve? (weird stuff…)

As soon as i loaded my test image i noticed the gradient was no longer smooth but it contained some vertical artifacts. I should point out that the gamma is set to default in Ubuntu: xgamma gamma 1.0

I also have Windblows 10 and OSX and there the gradient is smooth. However in Ubuntu it is brighter and contains vertical artifacts. And each time i take a screenshot, test image becomes brighter. This is driving me crazy.

So here is a test image: https://i.imgur.com/TflxhEi.png

When i open it on Win and OSX it is smooth and contains proper black. Here is a screenshot from Win10: https://i.imgur.com/uInvTgS.png

Here is a screenshot from Ubuntu (notice vertical artifact, less blacks, make sure to zoom in): https://i.imgur.com/9ZVoxnN.png

Here is a screenshot of a screenshot: https://i.imgur.com/avmdSmK.png

Here is a screenshot of a screenshot of a screenshot: https://i.imgur.com/kC8EF8a.png

The test image in the last example has become stupidly bright indicating there is another layer of gamma control present in the display settings that is just hidden from access.

Please keep in mind before you mention i should change gamma, this is all happening at gamma 1.0.