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