C# SQL Server - save information about user on item when user has been deleted -


i have database need advice on how proceed in situation. assuming have table called tasks. each task has property called createdby need store information user created task.

i can store example id of user , when fetch task fetch info user specific task createdby field value john smith example instead of id. far. or how should handle scenario let's user john smith has been removed/deleted system , task still exists, how show name of user created task? still need show john smith in there rather id.

in situation, use 'soft deletes' user table. add column user table , name 'active' default value of 1. when wish delete user, set value 0. allow continue enforcing referential integrity users.


Comments

Post a Comment

Popular posts from this blog

sql - can we replace full join with union of left and right join? why not? -

can replace full join union of left , right join? if no,why? 'yes' if t1 , t2 sets (no duplicated rows), otherwise answer 'no'. create table t1 (i int); create table t2 (i int); insert t1 values (1); insert t1 values (2); insert t1 values (2); insert t2 values (3); full join select * t1 full join t2 on t1.i=t2.i order 1,2 1 (null) 2 2 2 2 (null) 3 union select * t1 left join t2 on t1.i=t2.i union select * t1 right join t2 on t1.i=t2.i order 1,2 1 (null) 2 2 (null) 3 union all select * t1 left join t2 on t1.i=t2.i union select * t1 right join t2 on t1.i=t2.i order 1,2 1 (null) 2 2 2 2 2 2 2 2 (null) 3
Read more

javascript - Parallax scrolling and fixed footer code causing width issues -

i bolted bits of code. 1 parallax scrolling, , other piece of fixed footer code found here: http://codepen.io/madshaakansson/pen/cgjch though after bolting , fixing few issues, have problem different widths. header different width footer, , main content doesnt span whole width of page. have tried adjusting width of content css 100%, made main content span whole width, ended breaking footer. i not sure need change make these different bits of code work together. advice appreciated. my attempt: http://codepen.io/dingerzat/pen/qgbwkk html /*global define: false */ function init() { window.addeventlistener('scroll', function(e) { var distancey = window.pageyoffset || document.documentelement.scrolltop, shrinkon = 300, header = document.queryselector("header"); if (distancey > shrinkon) { classie.add(header, "smaller"); } else { if (classie.has(header, ...
Read more

swift3 - Value of "String" has no member 'indices' - moving to Swift 3.0 -

i'm moving swift 2 (probably, 2.3) 3.0 , have hard time correcting following code : now, know string not collection anymore. how correct particular code? let separator = anyword.indexof("-")! anyword.substring(with: (anyword.indices.suffix(from: anyword.index(anyword.startindex, offsetby: separator + 1)))) as possible improvement @dfri's first solution , use upperbound of string 's range(of:) method (which bridged nsstring ) – give index after (first occurrence of the) dash in string. import foundation let anyword = "foo-bar" if let separator = anyword.range(of: "-")?.upperbound { let bar = anyword.substring(from: separator) print(bar) // bar } or compacted crazy single binding using optional 's map(_:) method: if let bar = (anyword.range(of: "-")?.upperbound).map(anyword.substring(from:)) { print(bar) // bar } although note general solution problem of 'string not being collection anymo...
Read more