Top "Database-schema" questions

A description of the structure of the database - including the structure of the tables, columns, constraints, views, etc, etc.

Database table design for scheduling tasks

I want to be able to create schedules that can be executed based on a fixed date, repeated daily, repeated …

database-design database-schema
How to duplicate schemas in PostgreSQL

I have a database with schema public and schema_A. I need to create a new schema schema_b with …

postgresql database-schema foreign-key-relationship postgresql-9.1
mysqldump - Export structure only without autoincrement

I have a MySQL database and I am trying to find a way to export its structure only, without the …

mysql export mysqldump database-schema auto-increment
Is there a way to get a schema of a database from within python?

I'm trying to find out a way to find the names of tables in a database(if any exist). I …

python sqlite database-schema
Is it possible to create a column with a UNIX_TIMESTAMP default in MySQL?

I'm trying to do this, but it seems like MySQL isn't allowing me. Is there a solution to this issue …

mysql sql database database-design database-schema
PostgreSQL: Can you create an index in the CREATE TABLE definition?

I want to add indexes to some of the columns in a table on creation. Is there are way to …

postgresql database-schema database-indexes
Replicate a single table

Is it possible to replicate a single table?

mysql replication database-schema
What mysql database tables and relationships would support a Q&A survey with conditional questions?

I'm working on a fairly simple survey system right now. The database schema is going to be simple: a Survey …

sql database-design database-schema erd data-modeling
2 relationships between 2 entities in ER diagram

I'm trying to draw an ER diagram describing the following: -"Department" employs "Employees" -Some "Employees" are "Special" and have …

database database-design entity-relationship database-schema
Dynamically changing schema in Entity Framework Core

UPD here is the way I solved the problem. Although it's likely to be not the best one, it worked …

c# entity-framework asp.net-core database-schema entity-framework-core