CREATE SEQUENCE  "T_HISTORY_ID_SEQ" INCREMENT BY 1 START WITH 1;

CREATE TABLE T_HISTORY
(
  ÈÄ NUMBER NOT NULL CONSTRAINT "T_HISTORY_PK" PRIMARY KEY,
  ËÞÄÈ_ÈÄ NUMBER NOT NULL CONSTRAINT "T_HISTORY_PEOPLE_ID_FK" REFERENCES T_PEOPLE(ÈÄ),
  ÎÒÄÅË_ÈÄ NUMBER NOT NULL CONSTRAINT "T_HISTORY_DEPART_ID_FK" REFERENCES T_DEPARTMENT_INFO(ÈÄ),
  ÄÎËÆÍ_ÈÄ NUMBER NOT NULL CONSTRAINT "T_HISTORY_POST_ID_FK" REFERENCES T_POSTS(ÈÄ),
  ÑÎÑÒ_ÈÄ NUMBER NOT NULL CONSTRAINT "T_HISTORY_COND_ID_FK" REFERENCES T_CONDITION(ÈÄ),
  ÄÀÒÀ DATE NOT NULL,
  ÊÎÌÌÅÍÒÀÐÈÉ LONG NOT NULL
);

CREATE OR REPLACE TRIGGER T_HISTORY_ID_TRIGGER
BEFORE INSERT ON T_HISTORY
FOR EACH ROW
BEGIN
  :NEW.ÈÄ := T_HISTORY_ID_SEQ.nextval;
END;
/