Top "Database-schema" questions

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

Private Message Database Design

Alright, so I think I'm pretty close to having what I need, but I'm unsure about a couple of things: …

mysql database-design database-schema
How to include MySQL database schema on GitHub?

Stackoverflow and MySQL-via-command-line n00b here, please be gentle! I've been looking around for answers to my question but could …

mysql github mysqldump database-schema dump
How to get a list of all tables in two different databases

I'm trying to create a little SQL script (in SQL Server Management Studio) to get a list of all tables …

sql-server database-schema
Creating a simple database schema

I'm new to SQL and could use some help in creating a database schema for my program, which manages and …

sql creation database-schema
How to Design a SaaS Database

I have a web app that I built for a trucking company that I would like to offer as SaaS. …

database database-design database-schema
Entity-Attribute-Value Table Design

I am currently designing a database structure for the products section of an ecommerce platform. It needs to be designed …

mysql sql database-design database-schema entity-attribute-value
Database Structure involving dynamic fields

Im working on a project. Its mostly for learning purposes, i find actually trying a complicated project is the best …

mysql database-design relational-database database-schema entity-attribute-value
How to set default schema in Yii2

My Yii2 is setup with PostgreSQL. Instead of using separate database per project, I like to use schema for each …

postgresql migration database-schema yii2 search-path
How to manually set seed value as 1000 in MySQL

I am using MySQL 5. I need to set the seed value as 1000 for my auto increment field. How can I …

mysql database-schema auto-increment
Adding an one-out-of-two not null constraint in postgresql

If I have a table in Postgresql: create table Education ( id integer references Profiles(id), finished YearValue not null, started …

sql postgresql constraints database-schema