table-structure
How to model Friendship relationships
I have been trying to figure out how to do this, and even with looking at other examples, I can\'t get it figured out, so maybe I can get some personalized help.[详细]
2023-04-10 19:50 分类:问答Is it efficient to have 90 percent of rows to have field set to NULL?
I ha开发者_StackOverflow社区ve a table in my MySQL (InnoDB) full with user items. Basically each row has a user_id field and other item properties like color. Then there is one more field called a lin[详细]
2023-03-14 17:02 分类:问答Question regarding efficient table usage in MySQL
I want my users in my web app to be able to sign up for different \"events\". Each event has things describing it such as name, date of event开发者_如何学Python, the description, and people describing[详细]
2023-02-09 12:17 分类:问答Storing phone numbers in a SQL database
I have a table that stores mobile numbers it stores country network the rest so an example mobile, or masked is[详细]
2023-02-08 03:05 分类:问答how to get table structre of a database in java? [closed]
It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical andcannot be reasonably answered in its current form. For help clari[详细]
2023-01-31 05:22 分类:问答MySQL - Best method to handle this hierarchical data?
This is a followup to: MySQL - Is it possible to get all sub-items in a hierarchy? I have an arbitrary-depth adjacency list model table (I am at the point that I can convert it into a nested set mode[详细]
2023-01-05 05:27 分类:问答MySQL - Structure for Permissions to Objects
What would be an ideal structure for users > permissions of objects. I\'ve seen many related posts for general permissions, or what sections a user can access, which consists of a users, userGroups a[详细]
2023-01-03 13:10 分类:问答Table structure for menus in mySQL
I need a开发者_StackOverflow社区dvices for a table structure. I need to create menus dynamically.[详细]
2022-12-13 05:17 分类:问答How to make tasks double-checked (the way how to store it in the DB)?
I have a DB tha开发者_Python百科t stores different types of tasks and more items in different tables.[详细]
2022-12-09 00:24 分类:问答