MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table YD_TYPE_DOC
      (  YD_ident    integer      auto_increment  primary key
       , YD_code     char(4)      not null        unique
       , YD_libelle  varchar(50)  not null
      )
;
insert into YD_TYPE_DOC (YD_code, YD_libelle)
values ('NOTC', 'Notice')
     , ('PLAN', 'Plan')
     , ('SCHM', 'Schéma')
;    
create table TC_TABL_CHRONO
      (  TC_table    char(20)     not null
       , TC_colonne  char(20)     not null
       , TC_chrono   integer      not null
       , primary key (TC_table, TC_colonne)
      )
;
insert into TC_TABL_CHRONO(TC_table, TC_colonne, TC_chrono)
values ('DO_DOCUMENT', 'DO_numero', 0)
;
create table DO_DOCUMENT
      (  DO_ident    integer      auto_increment  primary key
       , DO_numero   integer      not null        unique
       , DO_titre    varchar(50)  not null 
       , DO_date     date         not null
       , YD_ident    integer      not null
       , constraint DOFK01 
         foreign key(YD_ident)
         references YD_TYPE_DOC(YD_ident)
         on delete restrict on update cascade
      )
;
update TC_TABL_CHRONO
set TC_chrono = TC_chrono + 1
where TC_table   = 'DO_DOCUMENT'
  and TC_colonne = 'DO_numero'
;
-- insertion d'un document de type "notice" dans la table des documents
insert into DO_DOCUMENT (DO_numero, DO_titre, DO_date, YD_ident)
values (  (select max(TC_chrono)
          from TC_TABL_CHRONO
          where TC_table   = 'DO_DOCUMENT'
            and TC_colonne = 'DO_numero')
        , 'mon document'
        , current_date()
        , (select YD_ident
           from YD_TYPE_DOC
           where YD_code = 'NOTC')
       )
;  
commit
;
update TC_TABL_CHRONO
set TC_chrono = TC_chrono + 1
where TC_table   = 'DO_DOCUMENT'
  and TC_colonne = 'DO_numero'
;
-- insertion d'un document de type "plan" dans la table des documents
insert into DO_DOCUMENT (DO_numero, DO_titre, DO_date, YD_ident)
values (  (select max(TC_chrono)
          from TC_TABL_CHRONO
          where TC_table   = 'DO_DOCUMENT'
            and TC_colonne = 'DO_numero')
        , 'mon plan'
        , current_date()
        , (select YD_ident
           from YD_TYPE_DOC
           where YD_code = 'PLAN')
       )
;  
commit
;
select * from DO_DOCUMENT
;

Records: 3  Duplicates: 0  Warnings: 0

Rows matched: 1  Changed: 1  Warnings: 0

Rows matched: 1  Changed: 1  Warnings: 0

DO_ident	DO_numero	DO_titre	DO_date	YD_ident
1	1	mon document	2024-02-07	1
2	2	mon plan	2024-02-07	2