Data Schema For Stock Control / Multi Source Inventory

I’m working on a project that involves stock control with multiple stock sources and sales channels. The overall hierarchy I’ve got so far looks like this;

Sales Channels <---- Allocated Stock Sources <---- Stock Locations (warehouses) <--- Stock Sub Locations <---- Shelf / Bin Locations 

As far as rules go for how these entities relate to each other I’ve come up with this;

The system must have one or more sales channels, each sales channel must have 1 or more stock sources, a stock source must have 1 or more stock locations (warehouses / buildings / distribution centres ), a stock location may have 1 or more Bin/Shelf locations.

A product may have 1 or more stock locations, may have one or more sub locations in those stock locations and may have one or more Shelf / Bin location.

First off, is this a solved problem where some reference schema exists I could utilise and save myself some headaches?

If there isn’t a reference design for this situation, Am I best to build a 1 to Many relationship to assign stock to a sub location(s) and another 1 to Many relationship for Shelf Locations (if exists)

Database Role based access control design for survey app

I’m going to design the RBAC for a survey app. Each survey has the same role as below and only 1 manager, 1 leader and multiple participants.

Role_ID|Role_Name  | -------|-----------|       1|admin      |       2|manager    |       3|leader     |       4|participant| 

Each user can have multiple roles and this user can choose to be the participant role to join one survey or not when he is the manager or leader of a survey. To make the user only can action the survey he owns, for example, UserA is assigned to be the leader of SurveyA, so he can only has the capability, edit_survey, on SurveyA but not another surveyB which he’s not assigned to, how should I design the database?

I generated two options, can someone check which one is better or there is another better solution?

Option1

I put the role manager and leader column as the FK of User_ID from User table on Survey table as it’s one to one relationship and create a new participant table for participants.

enter image description here

Option2

I create a new user_role_in_survey table to store manager and leader role and this table replaces old user_role table. Survey_ID is the FK of Survey table and participant table for participants.

enter image description here

Could Control Weather stop natural disasters?

Ok, I’m kinda curious about this-provided you had a high enough level caster, could one disperse the Category 5 hurricane heading for the defenseless coastal town? Re-aim or destroy the F4 tornado threatening to shred your little village?

According to the spell description, it says ‘When the spell ends, the weather gradually returns to normal’ (link to Roll20)

So does this mean that the hurricane/tornado/blizzard/sandstorm would only be temporarily stopped according to RAW? Or would the storm be dispersed and not return?

The whirpool application of the Control Water spell leads to several questions regarding creatures caught in it

As written, the whirlpool usage of the Control Water spell says:

Whirlpool. This effect requires a body of water at least 50 feet square and 25 feet deep. You cause a whirlpool to form in the center of the area. The whirlpool forms a vortex that is 5 feet wide at the base, up to 50 feet wide at the top, and 25 feet tall. Any creature or object in the water and within 25 feet of the vortex is pulled 10 feet toward it. A creature can swim away from the vortex by making a Strength (Athletics) check against your spell save DC.

When a creature enters the vortex for the first time on a turn or starts its turn there, it must make a Strength saving throw. On a failed save, the creature takes 2d8 bludgeoning damage and is caught in the vortex until the spell ends. On a successful save, the creature takes half damage, and isn’t caught in the vortex. A creature caught in the vortex can use its action to try to swim away from the vortex as described above, but has disadvantage on the Strength (Athletics) check to do so.

The first time each turn that an object enters the vortex, the object takes 2d8 bludgeoning damage; this damage occurs each round it remains in the vortex.

Are creatures or objects in the water and within 25′ of the vortex automatically pulled 10′ toward it? Do they continue to be pulled 10′ further toward the center of the vortex every round they are in it? Is a creature or object caught in the vortex also pulled down toward the bottom? On a failed save, are they caught for the entire duration of the spell, with no more chance at saves, or until they can swim free of it? On a failed save, does a creature continue to take 2d8 bludgeoning damage every round they are in the vortex? Can the whirlpool be cast so that it is completely underwater? Also, can the whirlpool be cast ‘upside down’ so the widest part is at the bottom?

UE4 MULTIPLAYER: how to Control Multiple Pawns without possesing them (RTS style)?

I am making a multiplayer RTS but i have problem being able to control spawned units (let’s call them Vessels), specifically moving them around with AI MoveTo bp.

Vessels can be created by both Clients and Server and are visible from everyone but neither clients nor Server can move Spanwed Vessels.

Only Vessels placed on map beforehand can be moved and ONLY by the Server.

Also server sees all Client CameraPawn movements and clients see Server CameraPawn movements BUT clients don’t see each other’s CameraPawn Movements (if this is related somehow…)

How can i control a pawn in multiplayer from all clients for starters ? How can i limit control to a specific controller ? Why "preplaced" Vessels work(move) for Server only ? 

FYI: I spend almost all day on the web about it and found nothing close to it. I get the feeling that either i am doing something wrong or understood something wrong…

unity : How to control the tile value of a material when extract material from imported game object (fbx, blend etc)

I import .blend (or .fbx) file into unity and i extract the materials. Sometimes the rusult of the material tiling is 5×5 , sometime 1×1. What makes unity decide what tiling value to be used when extracting material ? Can we control it ? i’m confused because normally it’s 1×1 but at some case the material has tiling of 5×5.

Does Inspiring Leader work on undead you Control?

Inspiring Leader Says:

choose up to six friendly creatures (which can include yourself) within 30 feet of you can can see or hear you and can understand you. Each creature gains temporary hit point equal to your level + your Charisma modifier.

It seems to me that mindless Skeletons and Zombies would be immune to this sort of buff. However I can’t seem to find any rule for that in 5E.

Is there any reason for Inspiring Leader not to affect your zombies and skeletons?

Would Druidcraft predict the use of the Control Weather spell?

If Druidcraft can predict a location’s weather for the next 24 hours, would it note weird weather caused by Control Weather, such as a sudden storm at midday on an otherwise clear and cloudless day? Or would only naturally occurring weather be predicted?

I predict the matter will come up at our next game session (my friends like to exploit loopholes, but in good fun) so I’m hoping to be prepared for the inevitable. I read the answer to “How reliable is Druidcraft weather prediction?”, but my question is more specific than that question answers.