text: CREATE TABLE IF NOT EXISTS batchs_laboratoires(
  	id SERIAL NOT NULL,
  	libelle VARCHAR(50) NOT NULL,
  	CONSTRAINT prk_constraint_batchs_laboratoires PRIMARY KEY (id)
  );
  
  CREATE TABLE IF NOT EXISTS batchs_produits(
  	id SERIAL NOT NULL,
  	code07 VARCHAR(50) NOT NULL,
  	code13 VARCHAR(50) NOT NULL,
  	libelle VARCHAR(50) NOT NULL,
  	codeLaboratoire VARCHAR(50) NOT NULL,
  	txTVA VARCHAR(50) NOT NULL,
  	CONSTRAINT prk_constraint_batchs_produits PRIMARY KEY (id)
  );
  
  CREATE TABLE IF NOT EXISTS batchs_ventes(
  	id BIGINT NOT NULL,
  	periode VARCHAR(50) NOT NULL,
  	codeCIP VARCHAR(50) NOT NULL,
  	idArticle VARCHAR(50) NOT NULL,
  	quantite VARCHAR(50) NOT NULL,
  	prixAchatHT VARCHAR(50) NOT NULL,
  	CAHT VARCHAR(50) NOT NULL,
  	CATTC VARCHAR(50) NOT NULL,
  	CONSTRAINT prk_constraint_batchs_ventes PRIMARY KEY (id)
  );
  
  CREATE TABLE IF NOT EXISTS ventes_pharmacies_periodes(
  	id SERIAL NOT NULL,
  	idPharmacie INT NOT NULL,
  	ventes_p1 json,
  	ventes_p2 json,
  	ventes_p3 json,
  	ventes_p4 json,
  	ventes_p5 json,
  	CONSTRAINT prk_constraint_ventes_pharmacies_periodes PRIMARY KEY (id)
  )WITHOUT OIDS;