[systems]:
select
//столбцы таблицы systems
system_id,
"system",
"schema"
from app_db_schema.schemas;
keep ([systems])
LOAD
//синтетический id таблицы, который нужен при формировании определений таблиц
AutoNumber([system_id]&[table_id]) as [tbl_synth_id],
system_id,
table_id,
table_name,
table_desc
;
[tables]:
select
system_id,
table_id,
table_name,
table_desc
from app_db_schema.tables;
keep ([tables])
[columns]:
select
table_id,
column_id,
column_name,
column_desc,
column_type
from app_db_schema.columns;
keep([columns])
[joins_columns]:
select
column_id, ext_column_id
from app_db_schema.joins_ids;
keep(joins_columns)
[ext_columns]:
LOAD
column_id as ext_column_id,
column_name as ext_column_name,
table_id as ext_table_id
Resident columns;
keep(ext_columns)
[ext_tables]:
LOAD
table_id as ext_table_id,
table_name as ext_table_name,
table_desc as ext_table_desc,
system_id as ext_system_id,
tbl_synth_id as ext_tbl_synth_id
Resident tables;
keep(ext_tables)
[ext_systems]:
LOAD
system_id as ext_system_id,
system as ext_system,
schema as ext_schema
Resident systems;