2.1.1 Auto Counter

DROP TABLE t_example;
DROP SEQUENCE seq_t_example;

CREATE SEQUENCE seq_t_example;
CREATE TABLE t_example (
	"id"     	INTEGER                 DEFAULT NEXTVAL('seq_t_example') , -- autocounter
	"sapnr"         CHARACTER VARYING(255)  NOT NULL ,      -- ...
	"item_id"       INTEGER                 NOT NULL ,
	"lang_code"     CHARACTER VARYING(255)  NOT NULL ,      -- de, fr, it, ...
	"modus_id"      SMALLINT                DEFAULT 1,      -- 1=active, 2=inactive
	"timestamp"     ABSTIME                 DEFAULT now()::abstime
);

CREATE INDEX t_example_sapnr_idx ON t_example USING btree (sapnr);
ALTER TABLE ONLY t_example ADD CONSTRAINT t_example_pkey PRIMARY KEY (id);

-- [EXAMPLE] --
-- INSERT examples:
INSERT INTO t_example (sapnr, item_id, lang_code) VALUES ('000000000000007863', 456, 'de');