Questions tagged [table-structure]
59 questions
0
votes
1 answer
Boolean field vs separate table
I have a keyword table where I will store all possible keywords that may be related to events (activities).
I want to allow organisers to enter custom keywords as well that will be uploaded to my database for moderation.
Is it a better idea to…
html_programmer
- 18,126
- 18
- 85
- 158
0
votes
4 answers
Performance in database design
I have to implement a testing platform. My database needs the following tables: Students, Teachers, Admins, Personnel and others. I would like to know if it's more efficient to have the FirstName and LastName in each of these tables, or to have…
Tanatos Daniel
- 558
- 2
- 9
- 27
0
votes
0 answers
Best Table Structure Design for Dynamic SQL statement
I am looking for the best table structure to create a dynamic SQL statement like this below (which is not dynamic yet). I have to choose between
joined tables
a single row with all columns with the content comma-delimted which I then will…
Pierre Cornelissen
- 11
- 5
0
votes
0 answers
managing multiple tables with same table structure in mysql
I am having multiple tables with same structure and a template table which is the master for all of these tables.
Is there a way that whenever i make any changes to master table(in structure), The child tables should get updated to always keep the…
Narayan Singh
- 1,234
- 2
- 13
- 26
0
votes
2 answers
SQL Column Names same as names for data types - causing errors
I am very new to SQL and having problems with creating a table structure.
I want to create a table with four columns - id,text,date and replace. Problem is this is giving me an error in MySQL, I think because the words TEXT and DATE are also names…
Sarah
- 744
- 2
- 9
- 26
0
votes
1 answer
Table Structure and foreign keys
In mysql database, I have a total of 7 tables. Under normal circumstances an instructor belongs to only one academy but an academy can have many instructors. In the same way many courses can be taught in one academy. I am not keeping record of what…
Code_Ed_Student
- 1,180
- 6
- 27
- 67
0
votes
1 answer
What would be the best table structure for user post sharing system?
I am creating an app where users can create content, other users can like, comment those posts, now I want to implement sharing feature. I want to know what would the best way to implement this.
Following is the table structure for posts
| post_id |…
vikas devde
- 11,691
- 10
- 35
- 42
0
votes
2 answers
How to make tasks double-checked (the way how to store it in the DB)?
I have a DB that stores different types of tasks and more items in different tables.
In many of these tables (that their structure is different) I need a way to do it that the item has to be double-checked, meaning that the item can't be 'saved' (I…
Shimmy Weitzhandler
- 101,809
- 122
- 424
- 632
0
votes
2 answers
Single table against multiple tables for similar type of data
I need some suggestion over this approach - please see examples below.
I have table structure as below
data_jobtype
id, identifier (varchar), description (varchar), userid (int)
data_statustype
id, identifier (varchar), description (varchar),…
user1421214
- 909
- 4
- 17
- 24
0
votes
3 answers
How to detect table and stored procedure changes between two databases?
I've got two databases, one for my development system and another which is the productive system.
Is it possible to detect the structure changes between both systems? (no data, only the structure changes should be detected)
At the moment I update a…
Tobias Bambullis
- 736
- 5
- 17
- 45
0
votes
3 answers
"Rebuttals" and "Comments" - Two DB-Tables or One?
I'm working on a project for a friend and I've come across a difficult decision. The project consists of essays, each of which can be challenged, and also commented on. The thing is this, only one person is able to challenge the essay, and then…
Sampson
- 265,109
- 74
- 539
- 565
-1
votes
1 answer
Why are table header and data placed in the same row in HTML?
I'm learning about HTML tables. I've got this example:
html {
font-family: sans-serif;
}
table {
border-collapse: collapse;
border: 2px solid rgb(200, 200, 200);
letter-spacing: 1px;
font-size: 0.8rem;
}
td,
th {
border:…
user3132457
- 789
- 2
- 11
- 29
-2
votes
1 answer
How to store a store opening hours in an SQL database?
I am developing an app for stores (in fact, restaurants) and need to design the PostgreSQL data structure for it.
For instance, the restaurant might have opening hours Mon-Fri from 7:30 to 17:00 and from 20:30 to 1:00 the following day.
The data to…
RdC1965
- 412
- 5
- 8
-2
votes
2 answers
Should I normalize or not? If yes how?
Currently I have a table with a column containing CSVs. I am not sure whether to normalize the whole table or not. The problem is this column, configuration, may contain up to 50 or more different types of values. For example in the table shown…
kross
- 475
- 1
- 11
- 31