database-design Questions
1
I'm redesigning the database for one of our apps, to normalise and restructure some of the more gigantic tables.
Our service offers various plans (Personal, Family, Business etc.) that come w...
Ogdon asked 4/9, 2018 at 0:46
7
Solved
I have 3 MySQL tables for a membership system.
users: Minimum requirement to be a user, only related to account info (email, password, is_activated, etc)
user_profiles: Personal information provi...
Bursarial asked 27/4, 2011 at 21:20
9
Solved
I have a database in MySQL created by someone. I don't have any documentation of the database.
How can I know the relationship between the tables?
Is there any query or a procedure to generate ...
Crinoline asked 15/2, 2016 at 12:0
6
Solved
Consider a data structure such as the below where the user has a small number of fixed settings.
User
[Id] INT IDENTITY NOT NULL,
[Name] NVARCHAR(MAX) NOT NULL,
[Email] VNARCHAR(2034) NOT NULL
...
Andean asked 27/6, 2014 at 10:29
4
Solved
I have been using int(10) and just noticed that Wordpress uses bigint(20) - What is different to use bigint(20) and int(10) for id auto increment? Which one should I use for id column?
`id` bigint...
Guanine asked 22/1, 2011 at 17:38
4
Solved
Background: we have a Grails 1.3.7 app and are using Liquibase to manage our database migrations.
I am trying to add a new column to an existing table which is not empty.
My changeset looks like ...
Succulent asked 18/1, 2012 at 2:12
3
Solved
I'm working on an application that tracks and handles work orders/tickets. Each ticket is linked to the user who creates/owns the ticket via a foreign key that cascades any changes in MySQL. Obviou...
Tunis asked 21/12, 2011 at 18:18
11
Solved
I'm developing a multilanguage software. As far as the application code goes, localizability is not an issue. We can use language specific resources and have all kinds of tools that work well with ...
Padding asked 25/11, 2008 at 9:13
2
Solved
I am trying to design a notification system similar to facebook and I have reached a bit of a brick wall. My requirement is to be able to support an infinite number of notification types that may h...
Bullhead asked 21/2, 2013 at 22:47
23
Solved
Bearing in mind that I'll be performing calculations on lat / long pairs, what datatype is best suited for use with a MySQL database?
Goodfellowship asked 1/10, 2008 at 19:18
8
Solved
I know that this sort of goes against the principles of a relational database but let me describe the situation.
I have a page where the user will place a number of items.
________________
| -It...
Distorted asked 2/3, 2012 at 15:51
7
Solved
My question is about what should be go first in software developing: database model or domain model? Or these notion are parallels?
Thanks.
Emulous asked 22/4, 2011 at 13:52
10
Solved
In a slightly heated discussion on TDWTF a question arose about the size of varchar columns in a DB.
For example, take a field that contains the name of a person (just name, no surname). It'...
Ricciardi asked 11/8, 2009 at 16:18
4
Solved
Consider that there is a bunch of tables which link to "countries" or "currencies" tables.
For making data easier to read I'd like make CHAR field with country code (eg US, GB, AU) and currency co...
Miletus asked 14/9, 2009 at 0:26
3
Solved
I have a MySQL table with more than a billion rows hosted on Google Cloud SQL.
>> SHOW CREATE TABLE depth
CREATE TABLE `depth` (
`date` date DEFAULT NULL,
`receive_time` datetime(3) DEFAU...
Dawndawna asked 15/12, 2017 at 9:45
4
Computer science student trying to get my feet wet with android development. I am trying to build an app where I am pretty sure a graph database is going to be required (its an app the creates rela...
Attain asked 2/2, 2016 at 19:12
3
I want to make a database of recipes with at least two tables:
Recipe (description, ingredients, directions, ...)
Ingredients (ingredient type, other attributes, ...)
What would be a way to assoc...
Progression asked 12/7, 2010 at 2:37
4
Solved
Given a PostgreSQL table named requests with a column named status and a constraint like this:
ALTER TABLE requests ADD CONSTRAINT allowed_status_types
CHECK (status IN (
'pending', -- request h...
Rorry asked 27/1, 2016 at 0:57
6
Solved
I suppose everyone runs into this problem once in a while: you have two tables that have autonumber primary keys that need to be merged. There are many good reasons why autonumber primary keys are ...
Parody asked 29/9, 2010 at 18:19
9
Solved
Seems like Money type is discouraged as described here.
My application needs to store currency, which datatype shall I be using? Numeric, Money or FLOAT?
Nisse asked 31/3, 2013 at 5:6
13
Solved
I have the following table schema which maps user_customers to permissions on a live MySQL database:
mysql> describe user_customer_permission;
+------------------+---------+------+-----+-------...
Misgive asked 21/1, 2010 at 17:20
12
Solved
I am building a custom events system, and if you have a repeating event that looks like this:
Event A repeats every 4 days starting on March 3, 2011
or
Event B repeats every 2 weeks on Tuesday ...
Fabri asked 3/3, 2011 at 16:35
2
Solved
I want to convert a JSON file I created to a SQLite database.
My json file is like this (containing traffic data from some crossroads in my city):
{
"2011-12-17 16:00": {
"local&quo...
Dorella asked 10/1, 2012 at 22:59
7
Solved
What's the longest possible worldwide phone number I should consider in SQL varchar(length) for phone.
considerations:
+ for country code
() for area code
x + 6 numbers for Extension extension (...
Occiput asked 6/4, 2009 at 23:4
2
Solved
I have two columns, both int's, Wins and Losses. I have a calculated column WinPercentage as a decimal(14,3), I want this to be:
WinPercentage = (Wins + Losses) / Wins
What's the syntax for that...
Searle asked 4/11, 2010 at 0:50
1 Next >
© 2022 - 2025 — McMap. All rights reserved.