All Questions
188
questions
0
votes
1
answer
184
views
Explicit many-to-many relation Prisma schema syntax for MongoDB
The following is my Prisma Schema for 3 models --> User, Cart and Item.
model User {
id String @id @default(auto()) @map("_id") @db.ObjectId
name String
email ...
0
votes
0
answers
41
views
How to connect multiple db tables to users_profiles in laravel
i am starting a new a site in laravel and i would like to use an sql file from the old corydating script since i can't design my own.
what i have done is upload the sql file to my db and used Laravel ...
-1
votes
1
answer
119
views
Database Schema Design for different timesheet format
Could someone help to understand the efficient way of storing the timesheet data (Timesheet_Details)?
The timesheet data can be input in multiple ways
Start time and end time (9am to 5 pm)
Plain ...
- 196
-2
votes
1
answer
195
views
different schemas with different tables refer to identical data file
We have ONE DB which has TWO schemas as follows:
Do the Names from both Customer tables refer to the same data file location?
If not, is it possible to set them into the same point so in case of ...
- 39
0
votes
1
answer
52
views
What is the best way to construct database tables for many to many relationship (with additional condition)?
Business problem: Suppose that we have a few medical centers and doctors, who work in these centers. Obviously, many doctors can work in one center. But also one doctor can work in many centers at the ...
-2
votes
1
answer
36
views
how to set up database
I’m creating an app that tracks attendance of players in amateur football teams. And I’m just not sure how to set up the database. A bit of info: every user has a team and should only see the events ...
- 41
-1
votes
1
answer
72
views
Integrate old / new data sources in SQL Server DB
Are there any best practices someone can share with me about integrating old and new data sources together on a SQL server?
To clarify, my company receives information from vendor A but we are ...
- 25
-1
votes
2
answers
225
views
Does prefixing system or general table names with "Sys" fine in Sql Server?
In Sql Server there's sys Schema. sys.Columns, sys.Tables.
I have a general tables which I need to rename to SysUsers, SysRoles, etc.
Is it fine to do that? I will not use Sys schema. I just will ...
user17562061
-1
votes
1
answer
164
views
Will my BigTable schema result in hotspotting?
Heres my schema
Heres some example data
Rows of this row key structure $PipelineId--$PipelineRunTime will be written less often but with much larger data, not that it would be anywhere close to ...
- 9,705
0
votes
1
answer
111
views
Individual parameter tables vs wrapping them into a single table, which is better?
I've got various settings that need to be looked up and stored according to various parameters.
For example, I need to know the hardware settings, which depend on the computer being used and the type ...
- 3,161
0
votes
1
answer
51
views
How to reference the actual value in a one to many relation
I have two tables, pirates and bounties.
Pirate
Bounties
id
id
name
value
.
pirate_id
One pirate can have a lot of bounties, but one bounty can have only one pirate. The issue is, I need to know ...
- 39
0
votes
2
answers
45
views
chained query on google firestore
Data for one of our application use case is stored in firestore in below format:
"Collection" : "ROOT_COLLECTION"
"Documents" : MAIN_ID_1 : attribute : is_enabled:1
...
- 3,264
1
vote
0
answers
57
views
Why shouldn't you have redundant states represented in a SQL schema?
My colleague recently introduced a state machine into a model in our SQL schema. That is, a column that would represent a state computed from other sources in the database. She would then recompute ...
- 4,813
0
votes
1
answer
446
views
MongoDB should i make another collection or should i embed it
I am making a music app fron node js and i choosed mongodb as database for it. I know basic syntax for mongodb operations but i am new to schema designs. I havent learnt any database software before ...
- 329
0
votes
2
answers
578
views
schema design - best practise for storing survey data
Background:
I want to create a table for storing the questions and user answer in survey for research purpose.
The questions are multiple choices but only one answer can be selected.
The questions can ...
- 6,213