Canvas Data Model

bfcoder

unread,

Jan 9, 2013, 11:59:28 PM1/9/13

to canvas-l...@googlegroups.com

Howdy,

Before I attempt creating something, does Instructure have readily available a schema diagram or any documentation of the data model used by Canvas? It would be much appreciated.

-Thanks

-James Carbine

Jacob Fugal

unread,

Jan 11, 2013, 11:56:16 AM1/11/13

to canvas-l...@googlegroups.com

None that I'm aware of, but it would certainly be a valuable asset. If you start something before we do, let us know about it and we'll do what we can to assist, polish, etc.

-- Jacob Fugal

instructure.com

--

bfcoder

unread,

Jan 11, 2013, 12:11:30 PM1/11/13

to canvas-l...@googlegroups.com

I ended up running railroady on it, and created an svg of the models. It's very large. haha. Well the file size isn't too large, only 700k but while viewing it, that is large. I need a 82 inch retina monitor with 100k X 100k resolution to view it all at once. :] Though I would rather have a data file that I could view inside mysql workbench or pgModeler. For now the svg will have to do.

Here is a link to the file on dropbox: https://dl.dropbox.com/u/24489957/tatemae/models.svg

What also would be nice, is an explanation of what each field in each of the tables was for. I've done a lot of guess work while working on the code as to what each field is for.

-James Carbine

tatemae.com