Grokking the System Design Interview
Ask Author
Back to course home

0% completed

Vote For New Content
Should the URL table UserID column be a UUID instead of int to match other interfaces?

vproman

Sep 10, 2024

The URL table diagram shows the UserID is an int The User table diagram shows the UserID is a UUID

The interface definition shows the user_id parameter is a String, which suggests the id is a UUID and not an int

Given the above, should the table diagram show the URL table's UserID field is also a UUID? If not, why not?

0

0

Comments
Comments

On this page

  1. Why do we need URL shortening?

Try it yourself

Designing URL Shortener (video)

  1. Requirements and Goals of the System
  1. Capacity Estimation and Constraints
  1. System Interface Definition
  1. Create Short URL API
  1. Redirect API
  1. Analytics API
  1. URL Management API
  1. Delete Short URL API
  1. Database Design
  1. Basic System Design and Algorithm

a. Encoding actual URL

b. Generating keys offline

  1. Data Partitioning and Replication
  1. Cache
  1. Load Balancer (LB)
  1. Purging or DB cleanup
  1. Telemetry
  1. Security and Permissions