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