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.
Questions tagged [database-schema]
2784 questions
0
votes
1 answer
database table for scheduling system
Please correct me if I design it wrong. I need to design 3 tables as follow:
students : id, name
sections : id, student_id, s_name
schedules: id, section_id, c_name
And here are requirements:
There are students, and each of those student has…
Huynh Do
- 1
0
votes
1 answer
tbl with in_schema returns "Invalid object name" error
After a connection to the SQL server, the databases inside it can be listed.
con = dbConnect(odbc(),
Driver = "ODBC Driver 17 for SQL Server",
Server = "xxxxxxxxxxxx",
UID = "xxxxxxxxxxxx",
PWD…
Cem
- 31
- 7
0
votes
0 answers
How is best to structure a key value pair object inside Mongodb to use with mongoose?
If I need to save data as key:value pairs inside an existent document, where key is a String and value is a Number, as:
users (collection)
//(document 1)
..
notifications: Object
(String) : (Number)
(String) :…
m4tt
- 337
- 3
- 17
0
votes
0 answers
Officemate Database Schema
I am creating some data visualization with Officemate's database(MSSQL) however I am not sure how all these tables are related. If anyone has information on this that would be greatly appreciated.
Faraaz Ali
- 1
- 2
0
votes
0 answers
Do I have one schema or two?
I have an object type, defined in a JSON schema. I now want to support usage of this object type for users of Protocol Buffers. So, I define this schema again in the Protocol Buffer format.
Do I now have two schemas (a JSON schema and a Protocol…
Shuklaswag
- 903
- 9
- 23
0
votes
1 answer
Local Data Cache SyncTable Schema not copied, clientSyncProvider _ CreatingSchema does not fire
I am using the VS2008 Local Data Cache tool to synchronize a SqlServer 2008 Db with a local SQL CE 3.5. At the server I have a table with a PK with datatype uniqueIdentifier and defaultvalue newID(). Upon initial synchronization through the Local…
Winks
- 369
- 1
- 3
- 15
0
votes
10 answers
Is there a tool that will allow me to design a SQL Database, then script it for me?
I am looking for a tool that will allow me to design my SQL 2008 database, including the tables, columns, relationships between tables (PK,FK etc) and then produce scripts for me that I can run to create the database.
The idea here is that rather…
Dan Harris
- 1,320
- 1
- 18
- 40
0
votes
0 answers
Is it possible to use a single table as a dependent table containing one foreign key for multiple principle/parent tables using EF Core 5.0
I am working with an existing database that contains no foreign keys, only primary key constraints. A notes table is being used to store a single string of text as a varchar(max). When a record is inserted into the notes table the primary key is…
JakRuzL
- 73
- 7
0
votes
1 answer
SqlException: Invalid object name Person.Person
I'm following this tutorial to create a sample API in AspNet Core 3.1 using Visual Studio 2019 project templates, but since I'm using the AdventureWorks (2019) database, I've had to make some changes.
Database Context has been scaffolded like…
Overlord
- 2,030
- 1
- 16
- 19
0
votes
0 answers
How to create a database schema in kubernetes cluster
Consider a kubernetes deployment with database statefulset defined with 3 replicas. Also the application pod has 3 replicas.
The database schema creation scripts are invoked by the application container. In this scenario how do I make sure that…
Vivek
- 9,008
- 16
- 71
- 102
0
votes
1 answer
I run heroku run rake db:migrate but I got error PG::UndefinedColumn: ERROR: column "user_id" of relation "tasks" does not exist
Can you help me figure out what else do I need to edit or change here?
I have Task App and has 3 models Category, User and Task they are related already. The app is working fine in my local machine if you want to see my models here:
class User <…
Lovely Joy Figueras
- 31
- 4
0
votes
1 answer
Entity Framework 4.1 - Mapping bad schema
So I have a badly formatted schema that I can't touch right now because of a lot of legacy code dependencies.
Supposed I have a table Test and it has a column IsValid that is declared type int.
I want the poco domain object to have the proper intent…
junkyspace
- 355
- 4
- 15
0
votes
1 answer
Are schemas in PostgreSQL physical objects?
I use schemas in PostgreSQL for organizing my huge accounting database. At the end of every year I make a reconcile process by creating a new schema for the next year.
Are the files of the new schema physically separated from the old schema? Or all…
mbnoimi
- 374
- 3
- 19
0
votes
0 answers
Missing Schemas in MySQL Workbench
I am having an issue in MySQL Workbench, where many of my created schemas are missing. I was in a Coding Bootcamp, and all the schemas that I created during that period vanished. The ones created beforehand are all still there. I'm pretty sure I am…
Robert Smith
- 1
- 1
0
votes
4 answers
Help understand DB Schema/Design
Hello i am facing the following...
Two DB tables (mysql myisam tables - no foreign key constraints) 'MASTER' and 'CHILD'. Rows in 'CHILD' db table reference a single row (1:M) in the 'MASTER' table using the parent_id *column*.
The problem is that…
Andreas
- 5,067
- 4
- 37
- 58