131 reputation
12
bio website
location Minsk, Belarus
age
visits member for 2 years
seen Sep 17 at 12:15

Oct
1
revised storing arrays or images in a database table
minor formatting
Sep
30
suggested suggested edit on storing arrays or images in a database table
Sep
30
revised partitioning by datetime vs date vs int performance
minor formatting
Sep
30
suggested suggested edit on partitioning by datetime vs date vs int performance
Jul
20
revised Speeding up a NOT IN subquery
text formatting
Jul
20
revised Impoving performance of query by using greater than on a primary key
text formatting
Jul
20
suggested suggested edit on Speeding up a NOT IN subquery
Jul
20
suggested suggested edit on Impoving performance of query by using greater than on a primary key
May
10
awarded  Enthusiast
Mar
24
comment Modeling a ticket system based on a set of disparate kinds of tickets?
@Zach Setting privileges is up to your needs. If you need to restrict access to tickets of particular type, so you can set it for template_type. Having this data structure you are able to set restrictions even on paticular ticket key in all ticket types or in particular ticket type. I only suggest that your authorization system implementation should be 'decouled' from ticket system. In other words your ticket system should not change if you want to change authorization system. Don't integrate authorization columns into ticket tables - keep it separate.
Mar
24
comment Modeling a ticket system based on a set of disparate kinds of tickets?
@Zach Yes, you are absolutely right, I'm sorry - it's my mistake - of course it should reference to template_type. I make edit in my answer. Thank you.
Mar
24
revised Modeling a ticket system based on a set of disparate kinds of tickets?
mistake in the answer corrected according to comment
Mar
24
awarded  Teacher
Mar
23
revised Unique index on 2 columns in mysql
minor formatting
Mar
23
suggested suggested edit on Unique index on 2 columns in mysql
Mar
23
revised MySQL - What exactly does smallint(2) permit?
minor formatting
Mar
23
suggested suggested edit on MySQL - What exactly does smallint(2) permit?
Mar
23
answered Modeling a ticket system based on a set of disparate kinds of tickets?
Mar
22
revised media family on device is incorrectly formed. SQL Server cannot process this media family
minor formatting
Mar
22
suggested suggested edit on media family on device is incorrectly formed. SQL Server cannot process this media family