1,100 reputation
415
bio website
location
age
visits member for 2 years, 6 months
seen Oct 17 at 16:22

Jun
14
asked Errors keeping stored procedures through restore from backup
May
13
awarded  Caucus
Apr
23
awarded  Yearling
Apr
16
comment Referencing multiple tables from a single table and store additional data
Do parts and tunings apply to specific cars at specific times? Do certain parts and tunings exist only in certain games, but cars exist across multiple games? I don't fully understand the system you are trying to describe. At first blush it seems like you might want a table that puts together a car with its tunings and parts on a specific date, record that date in TimeSet, and that should handle it. I rather suspect I'm missing something, though.
Apr
3
comment Why should an application not use the sa account
I'd be hesitant to buy anything from a bunch of guys who think it's OK to leave the keys to the kingdom sitting in a config file in plain text. I know it's not your call, but if you can get The Deciders to see what a terrible idea that is, and what it says about the vendor, that might help your case.
Mar
20
comment big db for managing user files and settings
Each file gets a new record added to user_file table. There's no issue with multiple users having files recorded in the same table, because each record has the user's unique ID number in it.
Mar
19
comment Best relational database structure for this data
For something like Word, isn't "execute" a permission? But I see your point if for some reason executing or accessing an application isn't considered a permission.
Mar
19
revised Best relational database structure for this data
grammar, wording
Mar
19
answered Best relational database structure for this data
Mar
19
comment Best relational database structure for this data
Sure, give me a minute or so.
Mar
19
comment big db for managing user files and settings
That is not even close to following to the relational model. If you intend to implement this in MySQL, you certainly aren't going to want millions of tables, all but one of them with one record each. You shouldn't have any issue with the three tables in my answer, each having millions of records each.
Mar
19
comment big db for managing user files and settings
Per-user tables? So adding a new user means adding two new tables?
Mar
19
comment Best relational database structure for this data
I'm not convinced that Roles_Applications is a real thing. Given that all permissions are application-specific, it seems there are Applications_Permissions (what you have labeled Permissions), which may then be assigned to specific roles via a record in Applications_Permissions_Roles. Roles_Applications, in fact, seems to be describing the most basic application permission--simple access. Or, it is asserting that a role has some level of permissions for an application, but you have to look elsewhere to determine which ones.
Mar
19
comment big db for managing user files and settings
Three separate databases? No, I wouldn't do that. I would just use the three tables above in a single database.
Mar
18
comment Best relational database structure for this data
I'm not sure I've wrapped my mind around the interplay of roles, applications, and permissions. Each role/application has a specific permission that is independent of a role's other applications? For example, a CEO/Topdesk might have only read permission, while a CEO/Calendar might have write?
Mar
18
revised how to set a row's value from a certain row's value?
added per first comment
Mar
18
answered big db for managing user files and settings
Mar
18
answered how to set a row's value from a certain row's value?
Mar
8
answered Update Table A row if Table B row is changed
Mar
8
comment Does this query make sense?
I believe you are correct. I jumped to the conclusion that the first was correct because that way the query makes sense. If the behavior really is MAX(start_date) OVER (PARTITION BY person_id) then the original query seems to be just a tortuous way of getting DISTINCT person_id for that group in the table.