1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| with AR_article(AR_ident, AR_ref, AR_lib) as
(select 001, 'A120C400', 'perceuse électrique 500W' union all
select 002, 'R650G002', 'clef à pipe débouchée 15mm' union all
select 003, 'G610120V', 'jeux de clefs Allen'
)
, PL_plan (AR_ident, PL_ident, PL_date) as
(select 001, 001, '2020-07-10' union all
select 001, 002, '2020-11-14' union all
select 002, 001, '2020-06-15' union all
select 003, 001, '2021-01-20' union all
select 003, 002, '2021-09-01'
)
, IP_indice_plan (AR_ident, PL_ident, IP_ident, IP_date) as
(select 001, 001, 001, '2020-07-10' union all
select 001, 001, 002, '2020-09-05' union all
select 001, 002, 001, '2020-11-14' union all
select 002, 001, 001, '2020-06-15' union all
select 002, 001, 002, '2020-08-22' union all
select 002, 001, 003, '2021-04-01' union all
select 003, 001, 001, '2021-01-20' union all
select 003, 002, 001, '2021-09-01' union all
select 003, 002, 002, '2021-12-07'
) |
Partager