DROP TABLE IF EXISTS link;
DROP TABLE IF EXISTS article;
DROP TYPE IF EXISTS article_status;

CREATE TYPE article_status AS ENUM ('Created', 'Pending', 'Published', 'Rejected');

CREATE TABLE article (
  id serial UNIQUE NOT NULL,
  total_air_time INTEGER default 0,
  expire_date timestamp,
  article_type VARCHAR(50),
  cathegory VARCHAR(50),
  subject VARCHAR(100),
  content_article VARCHAR(1000),
  status VARCHAR(100),
  author VARCHAR(30),
  PRIMARY KEY (id)
);

CREATE TABLE link(
	id serial UNIQUE NOT NULL,
	article_id INTEGER references article(id),
	link VARCHAR(500),
	PRIMARY KEY(id)

);

INSERT INTO article VALUES (2, 13, '2016-01-09 04:05:06', 'ARTICLE', 'Congratulations', 'Congrats!', 'Congrats to Sergiu for passing the ISTQB - BCS Certified Tester Foundation Level Certification', 'PUBLISHED', 'Ioana Pavel');
INSERT INTO article VALUES (1, 12, '2016-01-08 04:05:06', 'ARTICLE', 'Information', 'Happy Easter!', 'We hope you will enjoy the sweet surprises on your desks this morning! This is to mark the beginning of the holidays and to get in the mood of celebration, as well as a sign of appreciation!', 'CREATED', 'Ioana Pavel');
INSERT INTO article VALUES (3, 33, '2016-12-29 12:12:00', 'FILE', 'Information', 'Books', 'Our 5 Voices book order has just arrived in the office and you can find the books in the library starting this morning. Go grab one and make the most out of it; it will change the way you lead and communicate with your teams, colleagues and family.', 'REJECTED', 'Marina');
INSERT INTO article VALUES (4, 11, '2016-12-10 11:11:11', 'FILE', 'Welcome', 'Welcome!', 'Madalina Enache joined Endava in the position of Tester and is working in the WorldPay project/P&MS team located in Palas. Madalina has two and a half years of experience in manual testing within MIND Software. Her experience is enhanced by her Bachelor’s Degree in Computer Science. ', 'PENDING', 'Marina');

INSERT INTO link VALUES (1,1, 'link1');
INSERT INTO link VALUES (2,2, 'link2');
INSERT INTO link VALUES (3,3, 'link3');
INSERT INTO link VALUES (4,2, 'link4');
INSERT INTO link VALUES (5,1, 'link5');


select * from article;