Database Schema - m3ghdad/Architekt GitHub Wiki
User
| Column Name | Data Type | Details |
|---|---|---|
| id | integer | not null, primary key |
| string | not null, unique, indexed | |
| password_digest | string | not null |
| session_token | string | not null, unique, indexed |
Story
| Column Name | Data Type | Details |
|---|---|---|
| id | integer | not null, primary key |
| author_id | integer | not null, foreign key, indexed |
| title | string | not null |
| body | string | not null |
Follow
| Column Name | Data Type | Details |
|---|---|---|
| id | integer | not null, primary key |
| follower_id | integer | not null, foreign key, indexed |
| followee_id | integer | not null, foreign key, indexed |
Like
| Column Name | Data Type | Details |
|---|---|---|
| id | integer | not null, primary key |
| user_id | integer | not null, foreign key, indexed |
| story_id | integer | not null, foreign key, indexed |
Comment
| Column Name | Data Type | Details |
|---|---|---|
| id | integer | not null, primary key |
| user_id | integer | not null, foreign key, indexed |
| story_id | integer | not null, foreign key, indexed |
| body | string | not null |