buzzing

Tables (19)

ban

  • ban_id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • ban_ended_at — datetime(6)
  • ban_started_at — datetime(6)
  • content — varchar(300)
  • is_banned — bit
  • title — varchar(50)
  • banned_user_id — bigint

comment

  • comment_id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • content — varchar(300) — NOT NULL
  • presence — bit — NOT NULL
  • parent_comment_id — bigint
  • spot_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL

congestion

  • congestion_id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • congestion_level — int — NOT NULL
  • observed_at — datetime(6)
  • location_id — bigint — NOT NULL

daily_congestion_statistic

  • daily_congestion_statistic_id — bigint
  • content — json — NOT NULL
  • created_at — datetime(6)
  • location_id — bigint — NOT NULL

location

  • location_id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • api_id — int — NOT NULL
  • name — varchar(255) — NOT NULL
  • location_category_id — bigint — NOT NULL

location_bookmark

  • location_bookmark_id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • location_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL

location_category

  • location_category_id — bigint
  • icon_image_url — varchar(255)
  • name — varchar(45) — NOT NULL

notification

  • notification_id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • content — varchar(255)
  • is_read — bit — NOT NULL
  • redirect_target_id — bigint
  • title — varchar(255)
  • type — varchar(255)
  • user_id — bigint

refresh_token

  • refresh_token_id — bigint
  • refresh_token — varchar(1000)
  • user_id — bigint

report

  • report_id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • content — varchar(300)
  • report_target — varchar(255)
  • target_id — bigint
  • ban_id — bigint
  • reported_user_id — bigint
  • reporter_user_id — bigint

revoke_user

  • revoke_user_id — bigint
  • revoked_at — datetime(6)
  • social_email — varchar(255)

sleeping_user

  • sleeping_user_id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • email — varchar(255)
  • last_login_date — datetime(6)
  • nickname — varchar(255)
  • original_id — bigint
  • password — varchar(255)
  • profile_image_url — varchar(255)
  • role — varchar(255)
  • social_email — varchar(255)
  • social_type — varchar(255)
  • user_status — varchar(255)

spot

  • spot_id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • address — varchar(500)
  • content — varchar(1500) — NOT NULL
  • road_name_address — varchar(255)
  • title — varchar(50) — NOT NULL
  • location_id — bigint — NOT NULL
  • spot_category_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL

spot_bookmark

  • spot_bookmark_id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • spot_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL

spot_category

  • spot_category_id — bigint
  • name — varchar(45) — NOT NULL

spot_image

  • spot_image_id — bigint
  • image_url — varchar(255) — NOT NULL
  • spot_id — bigint — NOT NULL

user_block_user

  • user_block_user_id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • blocked_user_id — bigint
  • blocker_user_id — bigint

users

  • user_id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • email — varchar(255)
  • fcm_token — varchar(255)
  • last_login_date — datetime(6)
  • nickname — varchar(20)
  • password — varchar(255)
  • profile_image_url — varchar(500)
  • role — varchar(255)
  • social_email — varchar(255)
  • social_type — varchar(255)
  • user_status — varchar(255)

weekly_congestion_statistic

  • weekly_congestion_statistic_id — bigint
  • average_congestion_level — float — NOT NULL
  • created_at — datetime(6)
  • location_id — bigint — NOT NULL