First time here? Check out the FAQ!
Ask Your Question
2

How can I get a schema of database models for AskBot?
 
   
  
 
 
I am trying to understand the relationship of all the tables of AskBot and so far I am not getting very far. I don't see for example how exactly a Thread relates to a Post (just to name one relationship). Is there an existing database schema that explains these relationships? Or a tool that would allow me an easy to understand schema? 
Thank you for any help!
 
 
To enter a block of code:
 
     
  • enter empty line after your previous text
    •  
  • paste or type the code
    •  
  • select the code and press the  button above
    •  
 
Preview: (hide)
  
 
 
 
 
 
 BanzaiTokyo's avatar

      61
    
 
 
 
 BanzaiTokyo 
 
 
    asked 8 years ago,
        
    updated 8 years ago 
 
 
 
 
        
 
 
 
Comments
 
 
 
 
1
  
 
 
 
There might be some tool like that, created for Django. Perhaps someone else can give a specific answer.
 
 
 Evgeny's avatar Evgeny (8 years ago)   
 
 
  
 
  see more comments  
 
 
 
 
 
 1 Answer
  
  
  
 
 
 
 
2
 
 
  
 
 
 
 
 
 
I cannot attach images because I don't have enough points. But here's the link to the schema in SVG format that I generated with PyCharm.
 
https://drive.google.com/file/d/0B3jA...
 
But because it is auto-generated it gives too much information. I think it would be so much more helpful for new askbot developers to have a manually created schema that concentrates on the most important objects and their relationships (threads, posts, revisions, users, etc)
 
 
To enter a block of code:
 
     
  • enter empty line after your previous text
    •  
  • paste or type the code
    •  
  • select the code and press the  button above
    •  
 
Preview: (hide)
  
 
 
 
 
 
 BanzaiTokyo's avatar

      61
    
 
 
 
 BanzaiTokyo 
 
 
    answered 8 years ago 
 
 
 
 
     link   
 
 
 
Comments
 
 
 
 
  
 
 
 
There is probably a better tool, maybe even something that inspects the SQL tables directly.
 
 
 Evgeny's avatar Evgeny (8 years ago)   
 
 
  
 
  see more comments