database-design Archives - Page 2 of 5

MySQL, Programming

IT Nursery

Remove Primary Key in MySQL

I have the following table schema which maps user_customers to permissions on a live MySQL database: mysql> describe user_customer_permission; +------------------+---------+------+-----+---------+----------------+ | Field | ...

May 29, 2022
0 Comments

Programming, sql

IT Nursery

What are best practices for multi-language database design? [closed]

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, ...

May 28, 2022
0 Comments

What’s the longest possible worldwide phone number I should consider in SQL varchar(length) for phone

What’s the longest possible worldwide phone number I should consider in SQL varchar(length) for phone. considerations: + for country code () for area ...

May 25, 2022
0 Comments

Use email address as primary key?

Is email address a bad candidate for primary when compared to auto incrementing numbers? Our web application needs the email address to be ...

May 23, 2022
0 Comments

First-time database design: am I overengineering? [closed]

Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be ...

May 22, 2022
0 Comments

“Prevent saving changes that require the table to be re-created” negative effects

Preamble I was modifying a column in SQL Server 2008 today, changing the datatype from something like currency(18,0) to (19,2). I got the ...

May 20, 2022
0 Comments

Schema for a multilanguage database

I’m developing a multilanguage software. As far as the application code goes, localizability is not an issue. We can use language specific resources ...

May 20, 2022
0 Comments

What’s wrong with foreign keys?

I remember hearing Joel Spolsky mention in podcast 014 that he’d barely ever used a foreign key (if I remember correctly). However, to ...

May 20, 2022
0 Comments

What does principal end of an association means in 1:1 relationship in Entity framework

public class Foo { public string FooId{get;set;} public Boo Boo{get;set;} } public class Boo { public string BooId{get;set;} public Foo Foo{get;set;} } I ...

May 19, 2022
0 Comments

What does ON [PRIMARY] mean?

I’m creating an SQL setup script and I’m using someone else’s script as an example. Here’s an example of the script: SET ANSI_NULLS ...

May 19, 2022
0 Comments