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