bpiatek / linkshortener Goto Github PK

CREATE TABLE links (
link_id INT AUTO_INCREMENT PRIMARY KEY,
original_link TEXT NOT NULL,
short_link VARCHAR(10) NOT NULL,
user_id INT,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
isActive BOOLEAN,
hits INT DEFAULT 0,
is_custom_alias BOOLEAN,
expiration_date DATE,
FOREIGN KEY (user_id) REFERENCES users(user_id)
);

/api/v1/links

response

{ "shortenedLink" : "http://bpiatek.pl/dsfsdfs" }