DROP TABLE IF EXISTS Department;

CREATE TABLE Department (
	dept_id SERIAL,
	name VARCHAR(255) NOT NULL,
	description VARCHAR(255) NOT NULL

);

DROP TABLE IF EXISTS Content_Type;

CREATE TABLE Content_Type (
	type_id SERIAL,
	name VARCHAR(255) NOT NULL

);

DROP TABLE IF EXISTS Content;

CREATE TABLE Content (
	content_id 	SERIAL,
	dept_id 	INT NOT NULL,
	content_type 	INT NOT NULL,
	title 		VARCHAR(255) NOT NULL,
	description 	TEXT NOT NULL,
	create_date 	TIMESTAMP
			DEFAULT now() NOT NULL,
	created_by 	VARCHAR(255) NOT NULL,
	last_upd_date 	TIMESTAMP NOT NULL,
	last_upd_by 	VARCHAR(255) NOT NULL	

);

DROP TABLE IF EXISTS Dept_User;

CREATE TABLE Dept_User (
	user_name 	VARCHAR(255)
	UNIQUE NOT NULL,
	dept_id INT NOT NULL,
	contact_name VARCHAR(255) NOT NULL,
	password VARCHAR(255) NOT NULL,
	create_date TIMESTAMP
	DEFAULT now() NOT NULL,
	email VARCHAR(255),
	contact_phone VARCHAR (255)

);

DROP TABLE IF EXISTS Content_Download;

CREATE TABLE Content_Download (
	download_id SERIAL,
	content_id INT(6) NOT NULL,
	file_name VARCHAR(255) NOT NULL
);