Janndhelle Marth Zulueta

Online Street Foods Database
abbreviation: osf(database name)

table name : categories

id = primary key, auto incremental
name - varchar
order - varchar
quantity - int
created_at - current timestamp

table name : comments

id = primary key, auto incremental
post_id - int
slug - varchar
name - varchar
body - varchar 
created_at - current timestamp 

table name : post

id = primary key, auto incremental
category_id - int
user_id - int
title - varchar
slug - varchar
body - varchar 
created_at - current timestamp 

table name : users

id = primary key, auto incremental
name - varchar
zipcode - int
email - varchar
username - varchar
password - varchar
register_date - current timestap