Tagged Questions

-1
votes
2answers
40 views

Database table design for situation dependent data

Let's say you have a table that will contain data that is very situation dependent. An example would be a collection of games where the player makes a selection to win. This selection should be ...
2
votes
1answer
126 views

Fetching rows from multiple tables with UNION ALL or using one table in production?

I know that for relational database like Postgresql using separated tables would be more efficient but I'm concerning for performance issues because the most executed query will fetch rows from ...
1
vote
1answer
134 views

Ruby on Rails database and application design

We have to create rather large Ruby on Rails application based on large database. This database is updated daily, each table has about 500 000 records (or more) and this number will grow over time. We ...
0
votes
1answer
21 views

How to revoke right to a usergroup on a certain date in postgresql?

I'm currently creating a DB with Postgresql. First time, be gentle. ;) I have a table project that stores submission date among other things. I have 2 groups of users. One can only consult the ...
0
votes
1answer
75 views

How do I implement circular constraints in PostgreSQL?

I want to enforce that a row in one table must have a matching row in another table, and vice versa. I'm currently doing it like this to work around the fact that you can't REFERENCE a table that ...
0
votes
1answer
75 views

New schema to store crucial data?

I'm trying to find solution to mark crucial data in application. One obvious idea is to create a flag like 'not removable', but I want to avoid adding the same column to many tables in db. So I have ...
-1
votes
1answer
54 views

One table from many source(One to One) - Database Design

I have a 'Text' table, the text table may came from different source, like Tweet, SMS, Email, etc. and each source have their own log, and Text is came from the source. so i came with some solution, ...