//// – LEVEL 1 //// – Tables and References

// Creating tables Table users as U{ id int [pk, increment] // auto-increment username varchar [unique] email varchar [unique] nickname varchar [unique] categories varchar count int comment_count int level int introduce int point int big3 int created_at timestamp }

Table normal_Article { id int [pk, increment] // auto-increment title varchar content text user_id int [ref:> users.id] article_categories varchar created_at timestamp }

table column { id int [pk, increment] // auto-increment title varchar content text user_id int [ref:> users.id] comment_id int created_at timestamp }

Table article_files { id int [pk, increment] url varchar article_id int [ref:> normal_Article.id] }

table column_files{ id int [pk, increment] url varchar column_id int [ref:> column.id] }

Table comments { id int [pk, increment] // auto-increment user_id int article_id int [ref:> normal_Article.id] content text created_at timestamp }

Table like { like_target int [ref:> column.id] liker int [ref:> users.id] }

Table article_like { like_target int [ref:> normal_Article.id] liker int [ref:> users.id] }

Table following { following int [ref:> users.id] follower int [ref:> users.id] }

Table medal { id int [pk, increment] title varchar content text userid int [ref:> users.id] }

Table challenge { id int [pk, increment] title varchar content text userid int [ref:> users.id] }

//Ref: “users”.”username” < “users”.”id”

// Ref: “challenge”.”id” < “challenge”.”title”

실행 컨텍스트, 이벤트 루프, 스코프, 프로미스, 프로토타입