text: -- Sequences
  CREATE SEQUENCE SEQ_COMPANY;
  CREATE SEQUENCE SEQ_JOB_OFFER;
  CREATE SEQUENCE SEQ_TAG;
  CREATE SEQUENCE SEQ_TAG_FK;
  CREATE SEQUENCE SEQ_SW_LOCATIONS;
  CREATE SEQUENCE SEQ_SW_REGEX;
  CREATE SEQUENCE SEQ_SW_STOPWORD;
  
  
  -- Tables
  
  CREATE TABLE "COMPANY"
  (
  	"ID"             BIGINT DEFAULT nextval('SEQ_COMPANY') NOT NULL,
  	"CITY"           CHARACTER VARYING(255),
  	"CONTACT_PERSON" CHARACTER VARYING(255),
  	"CRAWLER_NAME"   CHARACTER VARYING(255),
  	"LOCATION_CODE"  CHARACTER VARYING(255),
  	"NAME"           CHARACTER VARYING(255)                NOT NULL,
  	"PHONE"          CHARACTER VARYING(255),
  	"STREET"         CHARACTER VARYING(255),
  	"LAST_UPDATE"    TIMESTAMP,
  
  	CONSTRAINT COMPANY_PKEY PRIMARY KEY ("ID")
  );
  
  CREATE TABLE "JOB_OFFER"
  (
  	"ID"                    BIGINT DEFAULT nextval('SEQ_JOB_OFFER') NOT NULL,
  	"COMPANY_ID"            BIGINT,
  	"COMPANY_NAME"          CHARACTER VARYING(255),
  	"JOB_ANNOUNCEMENT_TIME" TIMESTAMP,
  	"JOB_TITLE"             CHARACTER VARYING(255),
  	"JOB_LOCATION"          CHARACTER VARYING(255),
  	"JOB_URL"               CHARACTER VARYING(255),
  	"OBSOLETE"              BOOLEAN                                 NOT NULL,
  	"DESCRIPTION"           TEXT,
  
  	CONSTRAINT JOB_OFFER_PKEY PRIMARY KEY ("ID")
  );
  
  CREATE TABLE "TAG"
  (
  	"ID"        BIGINT DEFAULT nextval('SEQ_TAG') NOT NULL,
  	"TAG_FIELD" CHARACTER VARYING,
  
  	CONSTRAINT "TAG_PKEY" PRIMARY KEY ("ID"),
  	CONSTRAINT "TAG_FIELD_UNIQUE" UNIQUE ("TAG_FIELD")
  );
  
  CREATE TABLE "TAG_FK"
  (
  	"ID"           BIGINT DEFAULT nextval('SEQ_TAG_FK') NOT NULL,
  	"COMPANY_ID"   BIGINT,
  	"JOB_OFFER_ID" BIGINT,
  	"TAG_ID"       BIGINT,
  	"TFIDF"        DOUBLE PRECISION,
  
  	CONSTRAINT "TAG_FK_PKEY" PRIMARY KEY ("ID")
  );
  
  CREATE TABLE "SW_LOCATIONS"
  (
  	"ID"       BIGINT DEFAULT nextval('SEQ_SW_LOCATIONS') NOT NULL,
  	"LOCATION" VARCHAR(255),
  
  	CONSTRAINT "SW_LOCATIONS_PKEY" PRIMARY KEY ("ID")
  );
  
  CREATE TABLE "SW_REGEX"
  (
  	"ID"          BIGINT DEFAULT nextval('SEQ_SW_REGEX') NOT NULL,
  	"REGEX"       VARCHAR(255),
  	"DESCRIPTION" VARCHAR(222),
  
  	CONSTRAINT "SW_REGEX_PKEY" PRIMARY KEY ("ID")
  );
  
  CREATE TABLE "SW_STOPWORD"
  (
  	"ID"       BIGINT DEFAULT nextval('SEQ_SW_STOPWORD') NOT NULL,
  	"STOPWORD" VARCHAR(255),
  
  	CONSTRAINT "SW_STOPWORD_PKEY" PRIMARY KEY ("ID")
  );
  
  
  -- INDEXES
  CREATE INDEX IX_JOB_ID_HASH
  ON "JOB_OFFER"
  USING BTREE ("JOB_ID_HASH");
  
  CREATE INDEX IX_TAG_FK_JOB_OFFER_ID
  ON "TAG_FK"
  USING BTREE ("JOB_OFER_ID");
  