Question : I’m creating the following table: CREATE TABLE fund_identifier ( id BIGSERIAL PRIMARY KEY NOT NULL, identifier TEXT NOT […]
Tag: application-design
Division Email Template DB Design [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Comma List vs Multiple Records
Question : I am currently building out an application that will contain many users, two roles and two groups. Logically […]
Inserting data into multiple tables
Question : For my system, students are required to create a user account by completing a registration form (personal, contact […]
Help with schema design [duplicate]
Question : This question already has answers here: Best way to capture historical changes between levels in a dimensional hierarchy […]
Single-entry accounting schema
Question : I’ve already built a double-entry accounting schema on a previous app, and it was very complicated. For a […]
Avoiding foreign key repetition on related tables in a relational DB
Question : I have a simple DB schema describing certain objects that belong to a historical time period of a […]
Permission for business logic layer & application
Question : I’m very new into db development and currently working on my first production app. I learned that I […]
How to handle removing ASP.NET users where their UserID is tied to rows that should be maintained even after a user is deleted?
Question : I have a website that uses ASP.NET membership and so there are multiple aspnet_… tables in our database. […]
Is it possible to execute queries in random order?
Question : I have a list of INSERTs, UPDATEs and DELETEs queries. My problem is that I always receive them […]