Cacher is the code snippet organizer for pro developers

CREATE TABLE students(
	student_id SERIAL PRIMARY KEY,
	first_name VARCHAR(100) NOT NULL,
	last_name VARCHAR(100) NOT NULL,
	homeroom_number INTEGER NOT NULL,
	phone VARCHAR(50) NOT NULL,
	email VARCHAR(255) UNIQUE NOT NULL,
	graduation_year INTEGER CONSTRAINT sensible_graduation_year CHECK(graduation_year > 1900)
);

CREATE TABLE teachers(
	teacher_id SERIAL PRIMARY KEY,
	first_name VARCHAR(100) NOT NULL,
	last_name VARCHAR(100) NOT NULL,
	homeroom_number INTEGER NOT NULL,
	department VARCHAR(50) NOT NULL,	
	phone VARCHAR(50) UNIQUE NOT NULL,
	email VARCHAR(255) UNIQUE NOT NULL
);