shortURL

Tables (3)

short_url

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.id — NOT NULL
  • url — varchar(200) — NOT NULL
  • hash_value — varchar(100) — NOT NULL
  • request_count — bigint
  • expiration_date — datetime(6)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)

users

  • id — bigint — Primary key — NOT NULL
  • password — varchar(128) — NOT NULL
  • last_login — datetime(6)
  • is_superuser — tinyint(1) — NOT NULL
  • email — varchar(255) — NOT NULL
  • is_active — tinyint(1) — NOT NULL
  • is_staff — tinyint(1) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

visit

  • id — bigint — Primary key — NOT NULL
  • short_url_id — bigint — Foreign key → short_url.id — NOT NULL
  • referrer — varchar(200)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL