What are some patterns for DB table schemas?

Question

I know some patterns to DB table schema:

one-one: same table.
one-many: Having 'many' table's primary key a member of 'one' table.
many-many: Having a new relationship table contains both table's primary key.

What are some other patterns?

The question is "what is the question?" It's all very meta.

Pesto
– Pesto

2009-06-05 16:02:38 +00:00
Commented Jun 5, 2009 at 16:02 — Pesto
– Pesto, Commented Jun 5, 2009 at 16:02
@Pesto: Should we add the meta tag?

Jens Schauder
– Jens Schauder

2009-06-05 16:11:50 +00:00
Commented Jun 5, 2009 at 16:11 — Jens Schauder
– Jens Schauder, Commented Jun 5, 2009 at 16:11

Community · Accepted Answer · 2017-05-23 12:30:27Z

1

How about?:

edited May 23, 2017 at 12:30

CommunityBot

11 silver badge

answered Jun 5, 2009 at 16:18

Corbin March

25.8k6 gold badges77 silver badges100 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jens Schauder · Accepted Answer · 2009-06-05 16:18:42Z

0

I wouldn't consider those 'patterns' since the term patterns are used for more or less complex problem solutions in a given technology, including some notion on the circumstances in which one pattern in superior to another applicable pattern.

The examples you are giving are more the very basic building blocks of relational database schema design. If you want to learn more about this I suggest search for 'database normalization'.

Some terms that could be considered patterns in the database world are:

star schema snowflake schema Entity-attribute-value model

answered Jun 5, 2009 at 16:18

Jens Schauder

82.6k35 gold badges199 silver badges379 bronze badges

Collectives™ on Stack Overflow

What are some patterns for DB table schemas?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related