Questions tagged [database-design]

72

votes

8

answers

PostgreSQL JSONB vs normalized tables for multi-tenant event metadata

asked 2026-05-03T11:45:00Z

8

votes

2

answers

Database Design : Is it a good idea to combine two tables with the same columns and too many data?

sql-server sql-server-2008 database-design

asked 2013-07-08T06:04:52.053

20

votes

2

answers

what is different between database clustering and database partitioning

database database-design cluster-computing

asked 2013-06-10T09:57:31.727

12

votes

3

answers

Any reason to still use snake case for database tables and columns?

mysql database database-design relational-database

asked 2013-04-29T21:31:29.870

69

votes

3

answers

Dropping column in Postgres on a large dataset

postgresql database-design ddl database-performance postgresql-9.2

asked 2013-03-29T08:44:38.027

28

votes

2

answers

How to structure and query an appointment system based on time slots where each bookable entity has a different time table daily?

mysql database-design relational-database

asked 2013-03-26T00:41:28.253

33

votes

3

answers

how to pass a null value to a foreign key field?

mysql sql database database-design

asked 2013-02-26T06:36:18.423

8

votes

1

answers

Enterprise Architect: Hide only some Foreign Key Labels to all connectors at once

database database-design enterprise-architect database-diagramming database-diagram

asked 2013-02-08T20:23:21.870

11

votes

1

answers

Grant privileges to all users, current and future

postgresql database-design privileges

asked 2013-01-09T20:56:43.650

9

votes

6

answers

Farmer needs algorithm for looping through self-referencing animal table

c# algorithm design-patterns database-design

asked 2013-01-04T04:57:47.670

15

votes

4

answers

How to determine the functional dependencies

database database-design functional-dependencies

asked 2013-01-02T14:02:24.693

8

votes

2

answers

App Engine: Structured Property vs Reference Property for one-to-many relationship

python database google-app-engine database-design

asked 2012-12-28T16:22:20.980

22

votes

3

answers

SQL history table design

sql database database-design

asked 2012-12-04T19:05:44.063

18

votes

2

answers

Database design for comments and replies

mysql database database-design one-to-many

asked 2012-11-21T09:57:21.500

32

votes

2

answers

why varbinary instead of varchar

mysql sql sql-server database database-design

asked 2012-11-15T08:20:14.613

35

votes

1

answers

Is there a difference between Surrogate key, Synthetic Key, and Artificial Key?

sql oracle-database database-design data-modeling

asked 2012-11-05T04:28:23.633

9

votes

1

answers

How do I add multiplicity values in StarUML

database database-design uml cardinality multiplicity

asked 2012-11-01T18:55:19.797

9

votes

1

answers

Modeling 3 entities with relationships

database database-design entity erd

asked 2012-10-26T01:25:47.283

14

votes

1

answers

How to store 800 billion GPS markers in database

mysql database database-design gps nosql

asked 2012-10-10T18:19:16.113

12

votes

2

answers

Change varchar to boolean in PostgreSQL

postgresql database-design query-optimization storage postgresql-9.1

asked 2012-10-10T16:41:55.960

22

votes

2

answers

What are implications to using "date" as a MySQL column name?

mysql database-design database-schema

asked 2012-10-08T05:14:37.983

12

votes

3

answers

Why would index nodes or an indexed property be better in a graph database?

database-design neo4j graph-databases titan

asked 2012-10-05T22:01:47.907

9

votes

1

answers

Designing tables in Amazon dynamodb

database database-design nosql amazon-dynamodb

asked 2012-10-05T18:02:08.387

15

votes

1

answers

How to structure the tables of a very simple blog in MySQL?

mysql database database-design blogs

asked 2012-09-10T15:36:55.587

29

votes

2

answers

database-design: table of likes?

mysql database postgresql database-design

asked 2012-08-04T12:28:16.930

63

votes

4

answers

Rails naming conventions for join tables

ruby-on-rails join database-design naming-conventions

asked 2012-07-21T07:52:58.317

24

votes

3

answers

How to store bidirectional relationships in a RDBMS like MySQL?

mysql database-design relational-database relationship

asked 2012-05-29T22:58:02.813

28

votes

12

answers

Is there a simpler way to achieve this style of user messaging?

mysql sql database database-design innodb

asked 2012-05-14T17:43:05.270

17

votes

3

answers

Best Way To Build A Multi-Notification System in PHP

php mysql codeigniter database-design database-schema

asked 2012-05-11T01:54:58.460

52

votes

6

answers

In SQL, is it OK for two tables to refer to each other?

mysql database database-design

asked 2012-05-04T09:58:01.353

8

votes

5

answers

Is this a "correct" database design?

sql-server database performance database-design

asked 2012-05-03T08:07:00.440

12

votes

2

answers

Database design for bus reservation

algorithm database-design

asked 2012-04-10T20:48:56.233

11

votes

1

answers

Genealogy Relationship Mapping why base on families

database-schema database-design genealogy

asked 2012-03-25T07:20:43.510

161

votes

8

answers

multiple tables broken down into categories vs one table with many columns

mysql database-design

asked 2012-03-19T17:16:45.107

12

votes

4

answers

How to prevent inserts in the parent table?

postgresql database-design inheritance triggers foreign-key-relationship

asked 2012-03-03T11:32:27.803

9

votes

3

answers

mysql - Mutually dependent foreign keys

mysql database-design foreign-keys

asked 2012-01-24T17:08:21.010

24

votes

4

answers

Adding a non-nullable column to existing table fails. Is the "value" attribute being ignored?

sql postgresql grails database-design liquibase

asked 2012-01-18T02:12:48.623

14

votes

2

answers

What is best performance for Retrieving MySQL EAV results as Relational Table

mysql performance database-design pivot entity-attribute-value

asked 2012-01-06T20:48:31.623

8

votes

0

answers

Database implementation details - per row header overhead

database database-design data-modeling

asked 2012-01-02T14:19:08.710

64

votes

5

answers

Database design: 3 types of users, separate or one table?

mysql database database-design user-interface relational-database

asked 2011-12-12T18:46:26.717

9

votes

3

answers

What is aspnet_Users and aspnet_Membership? Which one should I use? What is the difference?

asp.net sql-server database database-design asp.net-membership

asked 2011-12-09T16:12:54.547

455

votes

6

answers

Create unique constraint with null columns

sql postgresql database-design null referential-integrity

asked 2011-11-27T21:16:12.893

9

votes

5

answers

Storing Enums in MySQL Database

java mysql database-design enums

asked 2011-11-26T13:20:48.507

190

votes

7

answers

Implementing Comments and Likes in database

mysql database design-patterns database-design

asked 2011-11-13T16:11:08.243

14

votes

2

answers

natural key vs surrogate key an innodb foreign key

mysql database database-design foreign-keys relational-database

asked 2011-11-01T19:11:44.013

20

votes

3

answers

Store list of values (such as interests)

mysql list database-design

asked 2011-10-14T10:24:34.960

9

votes

3

answers

Database schema of messaging application

database database-design database-connection

asked 2011-09-27T13:27:03.743

25

votes

5

answers

Using "varchar" as the primary key? bad idea? or ok?

sql-server database sql-server-2008 database-design

asked 2011-09-21T09:21:05.383

55

votes

5

answers

Reason why oracle is case sensitive?

oracle-database database-design case-sensitive

asked 2011-09-15T02:18:26.580

20

votes

2

answers

Unique combination of fields in SQLite?

python sqlite database-design unique-constraint

asked 2011-09-13T19:40:52.510

Questions tagged database-design