text: 
  -- ************************************** "company"
  
  CREATE TABLE "company"
  (
   "id"                   uuid NOT NULL,
   "firebase_user"        varchar(500)[] NOT NULL,
   "settings"             json NOT NULL,
   "created"              timestamp NOT NULL,
   "updated"              timestamp NOT NULL,
    CONSTRAINT "PK_company" PRIMARY KEY ( "id" )
  );
  
  -- ************************************** "location"
  
  CREATE TABLE "location"
  (
   "id"                   bigserial NOT NULL,
   "company"                uuid NOT NULL,
   "name"                 varchar(255) NOT NULL,
   "settings"             json NOT NULL,
   "position"             geometry NOT NULL,
   "address_line_1"       varchar(300) NOT NULL,
   "address_line_2"       varchar(300) NOT NULL,
   "zip"                  varchar(300) NOT NULL,
   "city"                 varchar(300) NOT NULL,
   "country"              varchar(300) NOT NULL,
   "created"              timestamp NOT NULL,
   "updated"              timestamp NOT NULL,
   CONSTRAINT "PK_location"           PRIMARY KEY ( "id" ),
   CONSTRAINT "FK_location_company"     FOREIGN KEY ( "company" ) REFERENCES "company" ( "id" )
  );
  
  
  
  
  