The database-structure tag has no wiki summary.
0
votes
0answers
38 views
InnoDB errors after having deleted “ibdata1”
By accident, I have deleted the ibdata1 file in the MySQL directory because MySQL wasn't functioning correctly.
After reading so many forums, I found a post that recommended deleting the 3 files ...
3
votes
1answer
169 views
Schema design: Use of association (aka: bridge/junction) table vs foreign key constraint with composite index containing a non-key field
This is an inventory database for IT assets. The models used are trimmed in order to focus on the problem at hand. Using SQL Server 2008. Thanks for taking the time to read and for any input you can ...
1
vote
1answer
41 views
Structuring data in MongoDB for a to-do list type application
This is a fairly high level question as I am in the initial stages of planning this application, and am also very new to MongoDB and document-based databases in general. Disclaimer aside, I am ...
0
votes
1answer
31 views
Refer to a table with all rows or to the table which restricts allowed rows?
There are some discounts:
CREATE TABLE `discounts` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`value` decimal(4,2) NOT NULL,
`titleru` text COLLATE utf8_bin NOT NULL,
`titlehe` text ...
5
votes
3answers
2k views
Inventory database structure when inventory items have varying attributes
I'm building an inventory database to store enterprise hardware information. The devices the database keeps track of range from workstations, laptops, switches, routers, mobile phones, etc. I'm using ...
1
vote
2answers
65 views
How to Handle Database for Application which Starts from Scratch Annually
I am working on an application which will be used by an organisation annually, however each year they will be starting from a clean sheet. Which of the following two approaches (or any other approach) ...
1
vote
1answer
30 views
Stroring a type of an entry
There is a table estate with numeric fields districtru and districthe (for a name of a district in Russian and Hebrew), which refer to primary keys of the table districts. The districts table has the ...
0
votes
1answer
54 views
Several variants of a string in tables
I need:
a table containing keyword phrases;
a table containing URLs;
a table (or maybe a view) with keyword-URL pairs (referring to IDs of the two previous tables);
tables holding keywords/URLs for ...
0
votes
1answer
127 views
Users database to store access levels, can I move the non-essential information to another table?
I would like some advice on the best database structure for my system.
I have different kinds of users with different access levels, and different information of course. I created a users table with ...
0
votes
1answer
322 views
Db design for a quiz with variable number of answer choices, and each worth different score in a different category?
I'm working on a question/answer project and having a hard time coming up with a suitable database structure.
Each question can have from 1 - "n" answers, and each answer is associated with one of ...
4
votes
1answer
71 views
How do you manage a list for particular object. for eg. user comments on specific object(user post etc.)
I am new to database and web application development. I want to know how to store a list for a particular object in a database. For example, user comments for a particular post(object), or the ...
2
votes
1answer
228 views
Under what conditions are polymorphic associations used? What are the alternatives?
As I understand it, polymorphic relationships among tables in a database allow one table to have one foreign key that references many tables.
I have found that tags are a common application of this ...
2
votes
1answer
79 views
One table or several tables?
I have several types of writings: articles, projects, reviews, etc.
I have a table containing paragraphs (fields id (INT) and partext (TEXT)).
Each writing consists of several (ordered) paragraphs. ...
1
vote
1answer
256 views
Stock management - needs suggestions
I need to create a database which will have below modules:
Items [Food items, stationary]
Items Stock Management [stock in out]
Customers
Items Sale Management
Issue:
The system will have ...
6
votes
2answers
156 views
Am I violating any NF rule on my database design?
I am a newbie on creating database... I need to create it for my recruitment web application.
My application needs to schedule screenings, exams and interviews of applicants and save result in the ...
