fog of war
Tables (15)
Alert
- alert_id — SERIAL — Primary key — NOT NULL
- alert_post_id — INTEGER
- alert_comment_id — INTEGER
- alert_region_id — INTEGER
- alert_place_id — INTEGER
- alert_created_at — TIMESTAMP(3) — NOT NULL
- alert_type — "AlertType" — NOT NULL
Badge
- badge_id — SERIAL — Primary key — NOT NULL
- badge_name — TEXT — NOT NULL
- badge_category_id — INTEGER — NOT NULL
- badge_criteria — INTEGER — NOT NULL
- badge_points — INTEGER
- badge_image_url — TEXT — NOT NULL
Category
- category_id — SERIAL — Primary key — NOT NULL
- category_name — TEXT — NOT NULL
- category_points — INTEGER
- category_created_at — TIMESTAMP(3) — NOT NULL
- category_updated_at — TIMESTAMP(3) — NOT NULL
Comment
- comment_id — SERIAL — Primary key — NOT NULL
- comment_text — TEXT — NOT NULL
- comment_created_at — TIMESTAMP(3) — NOT NULL
- comment_updated_at — TIMESTAMP(3) — NOT NULL
- comment_author_id — INTEGER — NOT NULL
- commented_post_id — INTEGER — NOT NULL
- comment_is_deleted — BOOLEAN — NOT NULL
Level
- level_id — SERIAL — Primary key — NOT NULL
- level_level — INTEGER — NOT NULL
- level_points — INTEGER — NOT NULL
- level_description — TEXT — NOT NULL
- level_created_at — TIMESTAMP(3) — NOT NULL
- level_updated_at — TIMESTAMP(3) — NOT NULL
MapPlaceCategory
- placeId — INTEGER — Primary key — NOT NULL
- categoryId — INTEGER — Primary key — NOT NULL
Place
- place_id — SERIAL — Primary key — NOT NULL
- place_created_at — TIMESTAMP(3) — NOT NULL
- place_updated_at — TIMESTAMP(3) — NOT NULL
- place_name — TEXT — NOT NULL
- place_star_rating — DOUBLE
- place_points — INTEGER
- place_address — TEXT
- place_region_id — INTEGER
- place_latitude — DOUBLE
- place_longitude — DOUBLE
PlaceVisit
- visited_id — SERIAL — Primary key — NOT NULL
- visited_date — TIMESTAMP(3) — NOT NULL
- visited_place_id — INTEGER — NOT NULL
- visited_user_id — INTEGER — NOT NULL
Post
- post_id — SERIAL — Primary key — NOT NULL
- post_created_at — TIMESTAMP(3) — NOT NULL
- post_updated_at — TIMESTAMP(3) — NOT NULL
- post_description — TEXT
- post_image_url — TEXT — NOT NULL
- post_author_id — INTEGER — NOT NULL
- post_star_rating — DOUBLE
- post_place_id — INTEGER
- post_is_deleted — BOOLEAN — NOT NULL
Region
- region_id — SERIAL — Primary key — NOT NULL
- region_name — TEXT — NOT NULL
- region_english_name — TEXT — NOT NULL
SearchHistory
- search_history_id — SERIAL — Primary key — NOT NULL
- search_keyword — TEXT — NOT NULL
- search_time — TIMESTAMP(3) — NOT NULL
- search_user_id — INTEGER — NOT NULL
User
- user_id — SERIAL — Primary key — NOT NULL
- user_email — TEXT
- user_providerId — TEXT — NOT NULL
- user_image_url — TEXT
- user_nickname — TEXT
- user_points — INTEGER — NOT NULL
- user_level — INTEGER — NOT NULL
- user_is_admin — "Role" — NOT NULL
- user_selected_badge_id — INTEGER — NOT NULL
- user_is_deleted — BOOLEAN — NOT NULL
- user_created_at — TIMESTAMP(3) — NOT NULL
- user_updated_at — TIMESTAMP(3) — NOT NULL
- user_delete_at — TIMESTAMP(3) — NOT NULL
- user_refresh_token — TEXT
UserActivities
- activity_id — SERIAL — Primary key — NOT NULL
- activity_user_id — INTEGER
- activity_type — TEXT — NOT NULL
- activity_details — JSONB — NOT NULL
- activity_created_at — TIMESTAMP(3) — NOT NULL
UserRanking
- user_id — INTEGER — Primary key — NOT NULL
- user_points — INTEGER — NOT NULL
- rank — INTEGER — NOT NULL
_BadgeToUser
- A — INTEGER — NOT NULL
- B — INTEGER — NOT NULL