ShortenURL

Tables (3)

access_log

  • id — BIGSERIAL — Primary key
  • url_id (id2) — BIGSERIAL — Foreign key → url.id
  • accessed_at — TIMESTAMP — NOT NULL
  • ip_address — VARCHAR(45)
  • user_agent — TEXT
  • referer — VARCHAR(600)

url

  • id — BIGSERIAL — Primary key
  • slug — VARCHAR(6) — NOT NULL
  • original_url — VARCHAR(600) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

url_metadata

  • id — BIGSERIAL — Primary key
  • url_id (id2) — BIGSERIAL — Foreign key → url.id
  • url_id — BIGINT — NOT NULL
  • title — VARCHAR(6)
  • description — TEXT
  • image_url — VARCHAR(600)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL