CREATE TABLE person (
   id serial PRIMARY KEY,
   PID VARCHAR(255) UNIQUE NOT NULL,
   firstname VARCHAR(255) NOT NULL,
   lastname VARCHAR(255) NOT NULL,
   street VARCHAR(255) NOT NULL,
   streetnumber VARCHAR(255) NOT NULL,
   zipcode VARCHAR(255) NOT NULL
);