SQL 2016.03.31 CREATE TABLES APPSERV

/*ΔΗΜΙΟΥΡΓΙΑ ΠΙΝΑΚΩΝ [APPSERV]*/

CREATE TABLE students (id INTEGER PRIMARY KEY, name VARCHAR(15), surname VARCHAR(15));

CREATE TABLE teachers (id INTEGER PRIMARY KEY, name VARCHAR(15), surname VARCHAR(15));

CREATE TABLE class  (id INTEGER PRIMARY KEY, name VARCHAR(15), FLOOR INTEGER);

CREATE TABLE link   (id INTEGER PRIMARY KEY, cid INTEGER, sid INTEGER, tid INTEGER);