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).

Is it possible to create a custom schema in a database such that users that have read-only access in that database for the dbo schema can be set up with the ability to create and modify entities for ...

If I create a new schema and set the schema owner to another schema, for example dbo, what is the meaning of that in regards to my new schema?
Does my new schema inherit the same permissions from it'...

Lets say I have the following existing tables (both with a primary key column named Id):
TableA
TableB
Now, I need to create a new table that groups together 1 record from TableA with either 1 or 2 ...

I have a Person with columns like name, address and bio.
How do I store data in order to know the "freshness" of these columns?
For instance, "for the Person Y, the name has changed 2 days ago, and ...

I'm learning Oracle and did some testing. I used the sys user and created a table t in the scott schema and I found t's owner is scott, and scott has full access to t. I want to confirm, does scott ...

Background
I'm designing some tables to allow dates to be assigned to an object so progress can be tracked on that object, along with functionality to store emails sent pertaining to these contracts ...

Being my first database-driven and SQL powered program, I'd created this more or less on-the-fly, learning as I go.. trying to be cautious- but more or less created with the intent of simply working.....

When creating a user defined table function, or a user defined procedure, you can call the function or procedure as named.
However, a user defined scalar function requires that you call it with the ...

I'm trying to create an interactive story telegram bot on Node-red. To store the story I'm using SQLite.
How it works: Bot shows you a piece of the story, then shows some answers (buttons) regarding ...

Suppose that I have a mini-world consisting of three types of entities, A, B, and C, subject to the following constraints:
each A is associated with 0 or more B's, and each B must be associated with ...

I'm trying to set the default schema to a user in Redshift with alter option, because I do not want it to write to the public schema by default. I am using the following order:
alter user user_1234 ...

We're using Mysql 5.7
We have an index over a varchar(255) column in a table of ~ 500M rows.
select distinct varchar_column from table yields seven results, with the max length 21.
A DBA consultant ...

Drawing an EER Schema for a consulting firm, a process involves a Performance Manager (PM) evaluating the work of a Consultant on a Project.
The evaluation tracks the name of the consultant, PM, and ...

I have a large text corpus that I am storing in Postgres. A table articles has all of the metadata for each article, about 19 million rows. It's primary key is articles.doc_id. Another table (texts) ...

I am trying to create a calendar application that can support multiple calendars, for instance Indian, Nepali, Russian etc. Users can enable or disable the calendars according to their needs.
I have ...

I'm trying to create two users in a Postgres database—one with read-write access to all tables in two schemas, and one with read-write-create (i.e., able to make DDL changes) to the same schemas.
I ...

We have a large database with client data, with many entities, but we dont allow connections to the production db (mysql) due to security. Only option remaining is to move some data to development db (...

My database attempts to describe some items, their sources and a variety of restrictions on who may use them as well as a number of intrinsic properties about the items.
It looks a little bit like:
...

I am building a website that allows users to retrieve a bunch of open source chart (eg UN data). I don't need to be able to query the data itself. I will instead extract certain meta data (keywords, ...

Please help. There is a problem I have tried to resolve for some time now. I want to come up with a pattern where i have a table with advertisements on a web platform. These advertisements shall be ...