Guest User

Untitled

a guest
Jan 21st, 2019
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  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
Add Comment
Please, Sign In to add comment