title: database design for notification settings
body: <ul>
  <li><p>A user can turn on or off
  notification settings for his
  account, for notifications such as 
  Changed Account Profile Information,
  Received New Message etc</p></li>
  <li><p>Notification can be sent via email or mobile phone (either push or sms), user can have 1 email only and many mobile phone devices.</p></li>
  </ul>
  
  <p><strong>Is there any way you would improve the following database design or would you do it differently?</strong> </p>
  
  <p>let me know thanks</p>
  
  <pre><code>USER_NOTIFICATION_SETTING
  Id
  UserId
  Notification_SettingCode
  NotificationTypeCode
  UserDeviceId -- the mobile deviceid
  IsEnabled -- true (notification is on), false (notification is off)
  
  NOTIFICATION_SETTING
  Code - e.g 1001, 1002
  Name -- e.g Changed Account Profile Information, Received New Message etc
  
  NOTIFICATION_TYPE
  Code - e.g 1001, 1002
  Name -- e.g Email, SMS, Push
  
  
  USER_DEVICE -- the mobile phone device information
  etc...etc...
  </code></pre>