First time here? Check out the FAQ!
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!

BanzaiTokyo's avatar
61
BanzaiTokyo
asked 2016-06-01 14:46:50 -0600, updated 2016-06-01 16:19:26 -0600
edit flag offensive 0 remove flag close merge delete

Comments

1

There might be some tool like that, created for Django. Perhaps someone else can give a specific answer.

Evgeny's avatar Evgeny (2016-06-13 05:53:07 -0600) edit
add a comment 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)

BanzaiTokyo's avatar
61
BanzaiTokyo
answered 2016-06-13 15:11:56 -0600
edit flag offensive 0 remove flag delete link

Comments

There is probably a better tool, maybe even something that inspects the SQL tables directly.

Evgeny's avatar Evgeny (2016-06-15 05:50:34 -0600) edit
add a comment see more comments