Creating missing tables before inserting records with foreign keys

Before adding rows to the target table, you must first create all the required structures (tables).

create table dev_network
(
    device_id bigint generated by default as identity primary key,
    profile_ref bigint not null
        constraint fk_profile_ref references network_device_profiles,
    radius_settings_ref bigint not null
        constraint fk_radius_settings_ref references radius_auth_settings,
    ip_address inet not null unique,
    device_name varchar(200) not null unique,
    model varchar(200),
    description varchar(200)
);