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