Databse Schema - saulack/uisge GitHub Wiki
Database Schema
Users
| Colum name | data type | details |
|---|---|---|
id |
integer | not null,primary key |
username |
string | not null, indexed, uniqe |
email |
string | not null, indexed, uniqe |
password_digest |
string | not null, indexed, unique |
timestamp |
datetime | not null |
Posts
| column name | data tpe | details |
|---|---|---|
id |
integer | not null, primary key |
rating |
integer | not null |
body |
text | not null, |
author_id |
integer | not null, indexed, foreign key |
drink_Id |
integer | not null, indexed foreign key |
timestamp |
datetime | not null |
Drinks
| column name | data type | details |
|---|---|---|
id |
integer | not null, primary key |
bottle_name |
string | not null, indexed, unique |
type_id |
integer | not null, foreign key |
description |
text | not null |
user_id |
integer | not null |
timestamp |
datetime | not null |
Types
| column name | data type | details |
|---|---|---|
type |
string | not null |