Database design

[kratsg]

We should design and flesh out our databases carefully. SX uses the following: https://meta.stackexchange.com/questions/2677/database-schema-documentation-for-the-public-data-dump-and-sede/2678#2678

[kratsg]

Do we want to use a graph database like neo4j?

[meltedspork]

Lets keep it simple for now

Basic schema

Author

• id {int}
• email {String}
• username {String}
• AuthO id?

Sign

• id {int}
• name {String}
• author id {int}
• description {Text}
• terminologies {Array}
  -- id {int}
• categories {Array}
  -- id {int}
• introspects {Array}
  -- id {int}
• path {String}

Category

• id {id}
• name {String}
• description {Text}

Introspect

• id {id}
• name {String}
• description {Text}

Terminology

• id {id}
• name {String}
• description {Text}

[kratsg]

Using #6 - I'll write up this schema in sequelize.

[meltedspork]

Is this done?

[kratsg]

For now. We need to migrate to remove a users table. But that's a new issue.

[meltedspork]

#17 has been created for removing users table.