All Questions
Tagged with data-modeling sql
8 questions
-1
votes
1
answer
213
views
Modeling a CSV file: What is the standard? Python or SQL?
I have a wide CSV file of about 350mb, and want to load it into a SQL database and properly model the data to make it easier to use for analysis.
I could split the data into tables with python and ...
- 111
0
votes
3
answers
3k
views
Introducing "status" column to an SQL table changes its definition
I saw this pattern in multiple projects I wrote: I create an SQL model for a certain type of entities and at some point, we realize that there's a need to store multiples types of the same entities. ...
- 143
1
vote
1
answer
4k
views
SQL Database schema for Catering/Menu management
Background
I'm building a Private Chef booking service where you can book a Chef to cook you a custom Menu. I'm having trouble creating a SQL db schema that accurately represents the domain while ...
- 111
2
votes
3
answers
1k
views
Database Model Classes in TypeScript
I'm using Knex.js with TypeScript for database access.
Table
uid (UUID, auto-generated by Postgres)
name (varchar)
Model
interface User {
uid: string | null;
name: string;
}
...
1
vote
3
answers
219
views
How can I model IS-A relationship on a ledger, when having different classes of products?
This is a question on how to model database entities and relationships when it comes to storing persistent data and dealing with differently-handled types of products.
Use Case
Company sells various ...
- 8,257
2
votes
4
answers
1k
views
Data Model - How to better model this circular reference
I'm designing the data model for a project where users can create documents, save revisions of that document that can be reverted to, and publish documents. The basic data model I have right now is ...
- 169
3
votes
5
answers
4k
views
Designing pricing table (RDBMS agnostic)
I'm designing a price list table for my database.
It will include Customer, Model, Start_date, End_date, Price, Currency, RRP
When I update a new price list, which is sent every now and then (maybe ...
- 31
2
votes
5
answers
8k
views
Is it Considered Good SQL practice to use GUID to link multiple tables to same Id field?
I want to link several tables to a many-to-many(m2m) table.
One table would be called location and this table would always be on one side of the m2m table.
But I will have a list of several tables ...
- 579