Questions tagged [database-schema]
A description of the structure of the database - including the structure of the tables, columns, constraints, views, etc, etc... that make up the database.Normally defined in the text, generally SQL in an RDBMS, the schema describes the complete blueprint for the database, defining everything about the database except that data itself.
database-schema
2,952
questions
0
votes
0
answers
11
views
Managing Dynamic Forms with 900+ Services in a Laravel Application
I'm working on a Laravel project where each service has a dynamic form layout configured through a backend admin panel. The project has the potential to grow to over 900 services, with each service ...
0
votes
1
answer
27
views
Filtering out rows that don’t fit the schema in pyspark
I have a file named employee.csv with columns empid as integer and empname string. I am reading the files into a dataframe d1 by defining the schema and reading into another dataframe d2 as it is. The ...
-1
votes
0
answers
30
views
Parent-Child relationships where parent and child tables may change based on settings
I am developing a Warehouse Management System. Each Warehouse can specify storage locations by varying degrees of specificity: Zone, Aisle, Row, Rack, Shelf, Bin. While Bin is always required because ...
1
vote
1
answer
52
views
Create Array of Struct with different columns(Structure) in PySpark
I have two structs
email_struct:
|-- email_struct: struct (nullable = true)
| |-- UsageTypeDesc: string (nullable = true)
| |-- ContactInfo: struct (nullable = false)
| | |-- ...
0
votes
0
answers
31
views
How to design SQL Schema for identical product components in product bundles
I'm in the process of designing a schema in our MySQL database to properly link products and product components. This is fairly straightforward using a product and product_components table design. ...
0
votes
1
answer
20
views
Create an object field using Mongoose schema and apply basic Mongoose validations to the fields of the object field in NestJS
I have a 'User' schema which has the 'contact' field of object type. One of the fields of the contact (address) field is also an object. 'address' is also the object type and has some desired fields. ...
1
vote
1
answer
59
views
I don't have "version of the schema included in the schema dump"
I am upgrading my app from Rails 6.1 to Rails 7.0, and in the upgrading instructions they made an important note about:
ensure that the version of the schema is included in the schema dump.
Like in ...
0
votes
0
answers
57
views
Trying to map a Map<Integer, List<Object>> to a postgreSQL JPA database
I'm trying to create a map of students with the key being the period number and value being A list of all students with that period.
The student object is marked as an entity.
@OneToMany(cascade =...
-1
votes
1
answer
72
views
Entity Framework and PostgreSQL Multi-tenancy using multiple schemas
I'm using Entity Framework Core with PostgreSQL, and I plan to implement multi-tenancy with a single database and multiple schemas. I'm interested in learning more about this and have a few questions
...
0
votes
1
answer
83
views
How to achieve many-to-many relationship between entities
I'm not sure if my relations between entitites are correct.
So for example I have an Player entity and a Team entity, one player can be in multiple teams(as long as they don't play the same tournament)...
0
votes
1
answer
20
views
database with lots of columns [duplicate]
I'm trying to plan a database for an RPG game.
Given the character table. The character has a lot of attributes, around 80, all of them are not null numbers. And I'm sure I won't need to increase the ...
2
votes
1
answer
18
views
Avoid automatic table creation when using ILP
If I send data over ILP, QuestDB will automatically create a table if it does not exist. I want to disable this, as I want to make sure my tables are always created beforehand with the right structure ...
0
votes
0
answers
137
views
Grant permission for a user to create objects in a PostgreSQL schema is not working
I have recently upgraded to PostgreSQL 15 and observed that a db user say X (not a owner of schema) is no longer able to create a table in public schema. From the below release notes looks like it is ...
-1
votes
1
answer
95
views
SQL schema for a fill-in-the-blank exercise [closed]
I'd like to create an online quiz application. I have in mind several types of exercises, including those for filling in the blank:
An exercise can require a user to enter the text:
Chemical energy ...
0
votes
0
answers
49
views
Enforce schema on schemaless DynamoDB database
Recently, I experienced a situation where I defined an attribute in DynamoDB as a number (Ex: 4.12334) then while updating the attribute I mistakenly wrote a string data to it (Ex: "4.12334")...