python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - data-modeling

SQL foreign key to multiple tables

I am creating a health and safety app for 30 different forms; each form has about 50 questions which are pass or fail questions, and they want to be able to take a few pictures as evidence for each qu...
test-img

Hadi

sql

sql-server

foreign-keys

relational-database

data-modeling

Votes: 0

Answers: 1

Latest Answer

You will need table(s) in the middle. Inspection_Action table - lists all possible actions Inspection_Action_id Inspection_Image table (or just Image )- lists all images Inspection_Image_id (PK) Si...
test-img

dbCoder

SWIFT "3 levels array"

I have a little problem with using arrays and declaring it in swift 5 on OSX: I know an [[String]] is an array of arrays like [["team1", "2 goals"], ["team2", "0 go...
test-img

Pablo Jiménez Revilla

swift

string

data-modeling

Votes: 0

Answers: 1

Latest Answer

You would be much better modelling your problem using structs. Here is a start for you to show how you might start modelling your problem. OK, let's start by creating a game with a name, thumbnail ima...
test-img

Fogmeister

Power BI - If a date is between 2 dates using relationships

I am trying to determine if a date is between 2 other dates that are is 2 different tables using Power BI. For simplicity, here is the model that I have : TableB is the bridge table between TableA an...
test-img

Citrix

powerbi

relationship

reporting

data-modeling

powerbi-desktop

Votes: 0

Answers: 1

Latest Answer

Have you tried using USERELATIONSHIP to force your calculated column to use the inactive relationship to TableA? documentation link So something like CALCULATE( {{created date is >start and <e...
test-img

Samuel Cochrane

Posts

Questions

Blogs

Jobs