database-design

相关标签：javascript jquery android 多少钱 iPhone

What is the best database schema for an availability calendar that allows scheduling appointments(reoccurring and single))

In my application I have a provider that has a schedule and clients that book appointment from the schedule. I need the following features.[详细]

2023-04-10 17:05 分类：问答
Handling a table with a lot of fields

I have a table to track a production there\'s so much details to store in the table like 50 different pieces of info.[详细]

2023-04-10 16:00 分类：问答
Database Pick List in CakePHP?

I\'m designing the database for a mental health agency where the clinicians choose from a list of pre-formatted choices for a lot of categories (employment status, housing status, relationship status,[详细]

2023-04-10 11:19 分类：问答
MySQL / Searching Two Tables

I have two tables, \'photos\' and \'videos\'. Together they are almost identical, except one column, \'photoID\' in \'photos\' and \'videoID\' in \'videos\'.[详细]

2023-04-10 09:58 分类：问答
history table and 2nf

Users table and Group users table are history tables (they cannot be moved to archived tables cause that would mess up foreign keys related to those tables. If a group user made a post and left the gr[详细]

2023-04-10 09:06 分类：问答
Mysql design for a user with several items of data

I want to store notes, bookmarks, videos and images that belong to a user: The simplified user table is as follows:[详细]

2023-04-10 07:36 分类：问答
Postgres constraints order of writing to and deleting from tables

I am working in a postgresQL database that has 200+ plus开发者_JAVA技巧 tables, some with many (15+) constraints that are references to other tables.I was able to list all of the constraints from the[详细]

2023-04-10 03:51 分类：问答
high score database

This is a high level/design type question rather than anything specific. In this game http://koreanwordgame.com/ users have to get as many correct answers as possible in a minute (though its set to 5[详细]

2023-04-10 02:54 分类：问答
Social Network Database Design - Friend/Block Relationships

I\'m working on a social networking site and need users to be able to friend each other and/or block each other. The way I see it, 2 users can either be Friend, Pending, Block, or 开发者_如何学JAVANUL[详细]

2023-04-09 19:05 分类：问答
Query optimization using primary key

I have a database with two tables: one that keeps information about each user and one that keeps information about the games each user is currently playing. Each user row and each game row has a uniqu[详细]

2023-04-09 18:47 分类：问答