DB

QuickDBD

users
-----
id PK integer
email string # email -> username field
name string
password string
agree_policy boolean
point integer
created_at datetime
updated_at datetime

points
-------
id PK integer
user_id FK >- users.id integer
pointable_type string
pointable_id integer
amount integer

notifications
-------------
id PK integer
user_id FK >- users.id integer
category integer # enum
notifiable_type string # polymorphic
notifiable_id integer
created_at datetime
updated_at datetime

challenges
-----------
id PK integer
owner_id FK >- users.id integer
challenge_category_id FK >- challenge_categories.id integer
title string
description string
start_at datetime
end_at datetime
address string
thumbnail_url string
total_point integer
tags Tags

challenge_missions
------------------
id PK integer
challenge_id FK >- challenges.id integer
title string
start_at datetime
end_at datetime
address string
point integer
thumbnail_url string

challenge_categories
--------------------
id PK integer
title string

# use django taggit 
tags
-----
id PK integer
name string