Database-design Questions

I know that a sql server full text index can not index more than one table. but, i have relationships in tables that i would like to implement

Here we go again, the old argument still arises... would we better have a business key as a primary key, or would we rather have a

There are several types of objects in a system, and each has it's own table in the database. a user should be able to comment on any of them. how

I want to let users specify a date that may or may not include a day and month (but will have at least the year.) the problem is when it is stored

A lot of contact management programs do this - you type in a name (e.g., "john w. smith") and it automatically breaks it up internally

I'm working on database designs for a project management system as personal project and i've hit a snag. i want to implement a ticket

What are some strategies that people have had success with for maintaining a change history for data in a fairly complex database. one of the

I have a new database table i need to create... it logically contains an id, a name, and a "value".

I am planning to create a pricing matrix for a project in rails. it's supposed to be a table of destinations and departure locations, and prices

I have a personal project i'm planning and i came to a small hurdle. i want to have an item with price that will be the default for all

I'm about to enter the 1st phases of designing a commodities trading application. a major function of this application is the capture and

Whenever i design a database, i always wonder if there is a best way of naming an item in my database. quite often i ask myself the following

Right now what i'm doing is: write some data in 3 different tables perform some reads to check if new values

Yesterday, i asked this question regarding best

We building big web application and we use mysql, we want to make mysql database more fast. some of us think if we will put message html body

I'm designing this collection of classes and abstract (mustinherit) classes…

I'm writing an app that contains the following tables: (1) employee_type, (2) employee and (3) employee_action. employee_action is

So this is something that we've been struggling to try and figure out how to optimize. in a simple world, this might be solved by a

I infrequently (monthly/quarterly) generate hundreds of crystal reports reports using microsoft sql server 2005 database views. are those views

I need some help with a school project. we are doing tourism management. we have 3 actors (customer, advertiser, tour leader). 1. the customer

I'm running sequelize on node.js. for table generation there is a

Let me explain with the help of a example. i have a transaction class (realm table) which extends realmobject. i want to

I have two processes: 1) scraper - take info from another website, do the needfull calculations and put results in db 2) web app

While modeling with firebase readtime db, stuck with deciding unique key. my users collection is identified as email id. so my aim is

I want to create the database schema for following query 1)it will have one entity(column) category which will have multiple subcategories

What do i mean by multi-tenant? users can belong to an organization. a user who signs up without any

I'm confused creating laravel model classes for my database schema. how to create relationships? the tables: table_phone

I have two schema vehicle schema : const vehicleschema = new schema({ title: { type: string,

I am making an api using firebase function & firebase cloud firestore. i am trying to use the firestore for storing data about

I'm trying to find a way to properly desing my data model with firestore. i'm looking for something similar to what tinder does, showing you

Suppose that i have a form that contains three 10 fields: field1..field10. i store the form data in one or more database tables, probably using

Given the two tables below, each ball can have one or more colors. what would be the most efficient way to update the

i have a jobs table that holds jobs. i have a tasks table that holds tasks that belong to a job (1:many). i have a

I'm developing an app in laravel. i've models called account and shippingaddress. an account may have one or more shippingaddress, but a

I am trying to design a reports database that allows you to create different types of reports. as such, i have my main reports table (i am

I'm very new to cloud firestore, so please help me. i'm creating an app for teensagers where i want to display a list of very nice locations in

Assume i have an ecommerce app where users can sell their items. this is how my db structure looks like:

I am working on a database which has some types (e.g. user, appointment, task etc.) which can have zero or

I need to trigger a function to send mails to users only during their working hours. the function that sends mails works

I am planning to develop production ready hybrid ionic3 mobile application similar to instagram using firebase.

I need help with database design and tables relationships for my upcoming project with laravel-lumen to reduce the query time as much as possible,

I want to structure a participant-list, which contains keys to other objects. my current structure: - events --

I'm curious what the best way to structure my mongoose schema is. i'm making a movie site with the user schema set like this: let

Are there any best practices someone can share with me about integrating old and new data sources together on a sql server? to clarify, my

I have a schema "questions" it has like a dozen of questions in it, i can add and delete those questions, i need this collection reflected in a

Hey i got the following problem: foods (is a food (egg, milk, etc) or a recipe (bread, which is made out of eggs, flour, etc)

I have come across a database in my current position that needs allot of tlc to say the least, there are many cross reference tables all having

I want to create a database that keeps track of a list of tasks that the users need to do and in the list of tasks there will be subtasks and

Hope you all are well. i have 3 database tables:

I have an access database for which i am the only user. it's the first database i've built. it has 16 related tables, around 40 select queries,

I'm developing an online shop web application with asp.net mvc and ef. one of the requirements is that each product should be categorized, each

When i am creating a database, i'm getting a little bit of a difficulty with creating the "main" table for this database. i thought there

I'm creating a pos like system and i'm not really sure how to do the shopping cart part wherein after the cashier enters all the customer's item

I have a system that takes orders, and an order can have one or many files. the file belongs to one order.

I am planning to build a database where i store a large amount of data about music. i am storing song-specific information in the

I have a form in which i fill following things: nick: sbsnick; item: someitem1; price: priceofitem1 item: someitem2; price:

I am coding an access database as a workshop project. i am using a form to introduce data in a table but i have a little problem. i have two

I have 2 tables users and events. the users table stores information about the users: name, email,

I'm trying to design a database, but not sure how to handle this situation. assume i have a table with geographical locations - hundreds

I am trying to design a database for my app and webservice, lets say the table for view properties is something like this:

I'm working on a classified ads site with 12 categories. e.g. category vehicles has items cars, bikes,

I have a few tables storing their corresponding records for my system. for example, there could be a table called templates and

I have a logical expression say c=a+b*d something like is it possible to achieve this in a relational datamodel

Trying to collect sample 2 pct multi column stats on a vt problem is , it does not sample or i am missing something

My intention here is to have columns("assignedto" , "loggedby" , "completedby" ) to have a reference to multiple records of

So i have two table connecting each other table admin_evaluate evalid int primary key, evalstatus tinyint, userid int (foreign to

I will try to describe what i want to accomplish, a solution i found and would be glad on your input/suggestions. i have these two

I have a database where i want to store multiple items, every item would be unique, but they can have alternatives from other makers. so items

Sqlfiddle link i have following tables for events.

I'm sitting with a little headache about a problem right now. i have two entities payment order and account

Could you help me with designing a mysql query for creating a table with data from other 3 tables? database design:

I'm building a food ordering web application with a standard product/category setup - a category (for example pizza) has many products (pizza

Well, my database is really particular. the part i dunno how to design is the next one : i need to have an entity "scan" which will

I have some products that belongs to the some category. each category can have different properties. for example,

I am a php developer and have basic knowledge of mysql yet i am working on a personal project so have to dig into it. billing details will

This investigation initially began with a test question, where i asserted r ∩ s = r ∩ (r ∩ s) as i

I have a question about performance of my mysql database design. table a has a lot of records, say a million, and table b also has a

I have a table resembling the following structure: city start_date end_date paris 1995-01-01 00:00:00

Suppose i want to create a simple database which lets user create playlists and add multiple songs into it. i just want to be able to find which

I need to design the structure of the tables with the product data to meet the following requirements: 1. a product consists of

I have the table with username and password named 'credentials' table and 'role' table having roles of organization.i want to grant permission to

Currenly, i'm working on an inventory system. i have just started and now gathering user requirements. this is my first time to create a system

I want to create database with recipes. how it should look like? for example let it exist two recipes: first recipe: 2 eggs with

Database beginner here. i've been researching column-store model for a while, i came up to

I have table to check if user with specific ip address rated on an item or not with these columns: rates(ip,item_id,created_at) i can

Hi i am not very good with database design so i would like to know if it's possible to create a table with two foreign key from the same

I am a web developer who's working on an exam generator project. now i am stuck at one point. i have one database with different tables.

We currently update manually each remote database table with changes made on local one. i mean adding tables, tables columns, etc. not the data

I have a vertica database that using projections. i read vertica docs but docs generally talk about how to issue;

I have a question about best practices regarding how one should approach storing complex workflow states for processing tasks in a database. i've

I am currently creating a filesharing system for learning reasons in laravel. currently it is possible to upload files and then to download them

I'm really stuck on this one. ex17 is supposed to be teaching me heap and stack memory allocation by providing a

I have product that have more attribute (for example color,size,material) that each attribute have value (for example color have 4 value or

I try to build website like grou, which is a platform to sell vouchers for some items in merchants. the

I have one entity in room @entity(foreignkeys ={ @foreignkey(entity = label.class, parentcolumns = "_id", childcolumns =

The wiki page and one of my instructors say

I am creating a workout app and would like to model the relationship between users and workout programs. a user can create a program multiple

I have written perl code that parses a text file and uses a hash to tally up the number of times a us state abbreviation appears in each

I'm new to dynamodb (and nosql databases in general) so this is a pretty basic question. i'm working with existing code where a dynamodb

I am hoping someone would be willing to take a look at this many-to-many relationship. this example is for a laravel project, but