Tagged Questions
2
votes
4answers
206 views
How to genericize foreign key references in table?
I am trying to design a table to store references to multiple tables as a "target" of the item in each row.
An example should clarify what I am trying to do:
Imagine you have 4 tables (images, ...
3
votes
3answers
207 views
Design pattern to dynamically create patterns found in a list of links
Can anyone help me think of a way to dynamically generate the patterns section of a tool I am creating? I'm not sure how to store and generate these "patterns" dynamically.
What the program does is ...
1
vote
1answer
238 views
Multi-user Configuration Settings design
I am designing a flexible and extensible way to store configuration settings for users.
Database Table Design:
╔═════════════════════════════╗
║ ConfigurationItemDefinition ║
...
0
votes
1answer
98 views
What is a good design for a container, assignment and items
------------- 1 * -------------- * 1 --------
| Container |--------| Assignment |-----------| User |
------------- -------------- --------
^ ...
2
votes
3answers
212 views
Using a database for each module in a system [duplicate]
I was reading this question:
I was trying to standardize and modularize some functions (Email
Management Module, CMS Module & etc) by implementing a 3-tier
architecture concept where each ...
6
votes
1answer
88 views
Ledger or log design for a point-based system?
Right now creating a new service that will integrate into our company's existing platform. The service will be responsible for tracking "points" that a user can generate over time through certain ...
5
votes
4answers
231 views
Where ORMs blur the lines between code and data, how do you decide what logic should be a stored procedure, and what should be coded?
Take the following pseudocode:
CreateInvoiceAndCalculate(ItemsAndQuantities, DispatchAddress, User);
And say CreateInvoice does the following:
Create a new entry in an Invoices table belonging to ...
0
votes
2answers
283 views
Does there exist a design-pattern for this problem?
I have a big database of data which we can consider today's system. The data has a web front-end which allows my users to update the data. Let's call this "original solution"
When new users come in ...
1
vote
1answer
455 views
Modular Database Structures
I have been examining the code base we use in work and I am worried about the size the packages have grown to. The actual code is modular, procedures have been broken down into small functional (and ...
0
votes
1answer
465 views
Design Pattern for Complex Data Modeling
I'm developing a program that has a SQL database as a backing store. As a very broad description, the program itself allows a user to generate records in any number of user-defined tables and make ...
0
votes
1answer
117 views
Parameterized Django models
In principle, a single Django application can be reused in two or more projects, providing functionality relevent to both. That implies that the same database structure (tables and relations) will be ...
2
votes
2answers
1k views
Booking system (Handle working hours, Get available time slots) [closed]
I'm currently working on a time booking system for a friends hair salon. The plan is to try to keep it as simple as possible.
The user view (where the owner see the booked appointments) is more or ...
5
votes
5answers
1k views
Two database fields for date and time - should they be merged?
In the following question, field and table names have been changed to protect their identities.
If I have two database columns:
MONKEY_DATE DATETIME NULL (with data e.g. 2012-05-14 00:00:00.000)
...
5
votes
4answers
946 views
Design Patterns / Strategies For Custom Fields & Data Types
Are there any common strategies or design patterns for designing applications that have either the ability to add custom fields to data objects, or for creating your own custom definition of objects. ...
2
votes
2answers
115 views
Pattern for group of entities with one required primary member
Given a parent entity with a collection of child entities where there must be exactly one primary child of the group?
To make the question more concrete, I've seen a number of ways that this pattern ...
