daily pastebin goal
44%
SHARE
TWEET

Untitled

a guest Jan 21st, 2019 59 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Table person {
  2.   id int PK
  3.   name varchar
  4.   parent_id int
  5. }
  6.  
  7. Table club {
  8.   id int PK
  9.   person_id int
  10.   class_id int
  11.   name varchar
  12. }
  13.  
  14. Table team {
  15.   id int PK
  16.   club_id int
  17.   children_id int
  18.   num_of_children int
  19.   name varchar
  20. }
  21.  
  22.  
  23. Ref: person.id < club.person_id
  24. Ref: club.id < team.club_id
  25. Ref: team.children_id < person.id
  26. Ref: person.parent_id > person.id
RAW Paste Data
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
 
Top