code_junkie

Tag hierarchies and handling of

Nov 11th, 2011
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. [TagRelations]
  2. tagId integer
  3. closeTagId integer
  4. proximity integer
  5.  
  6. select closeTagId from TagRelations where tagId = :tagID and proximity < 3
  7.  
  8. [Tags]
  9. tagID integer primary key
  10. tagName text
  11.  
  12. [TagRelations]
  13. tagID integer # first part of two-field key
  14. tagID_parent integer # second part of key
  15. trlValue float
Add Comment
Please, Sign In to add comment