Questions tagged [schema]
A schema of a database system is its structure described in a formal language supported by the database management system (DBMS) and refers to the organization of data to create a blueprint of how a database will be constructed (divided into database tables).
1,068 questions
0 votes
0 answers
30 views
Location Hierarchy representing production rooms or first-class entity?
I'm struggling to figure out the best way to model Production Rooms in our manufacturing ERP app. Currently, we have a Locations model which is a hierarchical, materialized-path (Ancestry Gem) ...
- 103
0 votes
0 answers
28 views
Hierarchical structure, one table with child relationship vs multiple tables
I have a hierarchical structure like this: store - dept - sub_dept (optional) and most inner level is connected to a "workers" table current table setup looks like this: create table ...
- 179
0 votes
1 answer
64 views
Again EAV - flexible DB design to allow user added properties
What is the problem? I want to make a material database. The User should be able to create different material types and create materials of this type. But different material types have different ...
0 votes
1 answer
244 views
SQL Server Permissions to synonym and underlying objects
I have DatabaseX_2024 and DatabaseY on same SQL Server. My app works with DatabaseY but need some data from DatabaseX_2024. Because name of DatabaseX_2024 is changing (will be DatabaseX_2025 next year)...
Condottiero
0 votes
1 answer
99 views
Could a Tool Like ChartDB Work for MongoDB Schema Visualization?
I’m one of the developers behind ChartDB, an open-source tool for database schema visualization, particularly useful for relational databases (RDBMS). Our tool helps users generate ER diagrams to map ...
- 11
3 votes
2 answers
1k views
How can I run sp_refreshview across all views in my SQL Server database
I'm using SQL Server, and I received an error indicating that one or more of my SQL views is out of sync with its underlying SQL table. 'MySQLServerName' returned data that does not match expected ...
- 349
-3 votes
1 answer
87 views
Are there mnemonics in the database design space that you find helpful when communicating database design concerns? [closed]
A popular and useful mnemonic in the software development space is SOLID. Single responsibility Open–closed Liskov substitution Interface segregation Dependency inversion Are there mnemonics in the ...
- 135
0 votes
1 answer
233 views
Is there any disadvantage to putting join tables in their own schema?
Is there any disadvantage to putting join tables in their own schema? Title, I could have a few schemas: app user permission app_join user_permission If I’m working with sql I’d have to include the ...
- 105