API tools faq
paste
Advertisement
gfg9

db_table

gfg9
Apr 12th, 2023
28
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
raw download clone embed print report
  1. -----------------------
  2. User
  3.  
  4. pk fk
  5. user_id team_id
  6.  
  7. 186 p1
  8. 179 p1
  9. 170 p2
  10.  
  11. --------------------
  12. Team
  13.  
  14. pk
  15. team_id
  16. p1
  17. p2
  18.  
  19. ------------------------------
  20. Team_User
  21.  
  22. fk fk -> composite key
  23. team_id user_id
  24. p1 186
  25. p1 179
  26. p2 170
  27.  
  28. -----------------------------
  29. Project
  30.  
  31. pk fk
  32. p_id owner_id
  33.  
  34. pr1 186
  35.  
  36. ---------------------------
  37. Epic
  38.  
  39. pk fk
  40. e_id p_id
  41.  
  42. -----------------------
  43. Issue
  44.  
  45. pk fk fk fk fk fk fk
  46. issue_id assigne_id reporter_id type_id status_id priority_id epic_id
  47.  
  48. ---------------------
  49. Status
  50.  
  51. pk
  52. Status_id status_name
  53.  
  54. --------------------
  55. Priority
  56.  
  57. pk
  58. Priority_id priority
  59.  
  60. --------------------
  61. Type
  62.  
  63. pk
  64. Type_id type_name
  65.  
  66. ---------------------
  67. Audit
  68.  
  69. pk
  70. aud_id auditUser entityId statusCode
  71.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!