AOKB/syncio
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
syncio/sql/seed_migration_tables.sql
brusnitsyn 7a13ff3b74 first commit
2026-04-16 17:57:58 +09:00

50 lines
35 KiB
SQL
Raw Permalink Blame History

INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('hlt_disp_Card', 'hlt_disp_card', 'incremental', 'full_then_incremental', 'Life_hlt_disp_Card', 'x_DateTime', 'disp_CardLifeID', '["x_DateTime", "disp_CardLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["disp_CardID"]', '["disp_CardLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('stt_ProcedureList', 'stt_procedurelist', 'incremental', 'full_then_incremental', 'Life_stt_ProcedureList', 'x_DateTime', 'ProcedureListLifeID', '["x_DateTime", "ProcedureListLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["ProcedureListID"]', '["ProcedureListLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('stt_StationarBranch', 'stt_stationarbranch', 'incremental', 'full_then_incremental', 'Life_stt_StationarBranch', 'x_DateTime', 'StationarBranchLifeID', '["x_DateTime", "StationarBranchLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["StationarBranchID"]', '["StationarBranchLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('hlt_ReestrIdCase', 'hlt_reestridcase', 'incremental', 'full_then_incremental', 'Life_hlt_ReestrIdCase', 'x_DateTime', 'ReestrIdCaseLifeID', '["x_DateTime", "ReestrIdCaseLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["ReestrIdCaseID"]', '["ReestrIdCaseLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('Oms_PRVD', 'oms_prvd', 'incremental', 'full_then_incremental', 'Life_Oms_PRVD', 'x_DateTime', 'PRVDLifeID', '["x_DateTime", "PRVDLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["PRVDID"]', '["PRVDLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('stt_BedAction', 'stt_bedaction', 'incremental', 'full_then_incremental', 'Life_stt_BedAction', 'x_DateTime', 'BedActionLifeID', '["x_DateTime", "BedActionLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["BedActionID"]', '["BedActionLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('hlt_disp_Exam', 'hlt_disp_exam', 'incremental', 'full_then_incremental', 'Life_hlt_disp_Exam', 'x_DateTime', 'disp_ExamLifeID', '["x_DateTime", "disp_ExamLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["disp_ExamID"]', '["disp_ExamLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('smp_MedService', 'smp_medservice', 'incremental', 'full_then_incremental', 'Life_smp_MedService', 'x_DateTime', 'MedServiceLifeID', '["x_DateTime", "MedServiceLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["MedServiceID"]', '["MedServiceLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('oms_DocumentStatus', 'oms_documentstatus', 'incremental', 'full_then_incremental', 'Life_oms_DocumentStatus', 'x_DateTime', 'DocumentStatusLifeID', '["x_DateTime", "DocumentStatusLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["DocumentStatusID"]', '["DocumentStatusLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('die_Card', 'die_card', 'incremental', 'full_then_incremental', 'Life_die_Card', 'x_DateTime', 'CardLifeID', '["x_DateTime", "CardLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["CardID"]', '["CardLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('Oms_LPU', 'oms_lpu', 'incremental', 'full_then_incremental', 'Life_oms_LPU', 'x_DateTime', 'LPULifeID', '["x_DateTime", "LPULifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["LPUID"]', '["LPULifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 09:30:15.367815', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('hlt_MKB_TAP', 'hlt_mkb_tap', 'incremental', 'full_then_incremental', 'Life_hlt_MKB_TAP', 'x_DateTime', 'MKB_TAPLifeID', '["x_DateTime", "MKB_TAPLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["MKB_TAPID"]', '["MKB_TAPLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('hlt_ReestrTAPMH', 'hlt_reestrtapmh', 'incremental', 'full_then_incremental', 'Life_hlt_ReestrTAPMH', 'x_DateTime', 'ReestrTAPMHLifeID', '["x_DateTime", "ReestrTAPMHLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["ReestrTAPMHID"]', '["ReestrTAPMHLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('oms_kl_DDService', 'oms_kl_ddservice', 'incremental', 'full_then_incremental', 'Life_oms_kl_DDService', 'x_DateTime', 'kl_DDServiceLifeID', '["x_DateTime", "kl_DDServiceLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["kl_DDServiceID"]', '["kl_DDServiceLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('stt_MigrationPatient', 'stt_migrationpatient', 'incremental', 'full_then_incremental', 'Life_stt_MigrationPatient', 'x_DateTime', 'MigrationPatientLifeID', '["x_DateTime", "MigrationPatientLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["MigrationPatientID"]', '["MigrationPatientLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('die_Mkb', 'die_mkb', 'incremental', 'full_then_incremental', 'Life_die_Mkb', 'x_DateTime', 'MkbLifeID', '["x_DateTime", "MkbLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["MkbID"]', '["MkbLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('stt_OperationPurpose', 'stt_operationpurpose', 'incremental', 'full_then_incremental', 'Life_stt_OperationPurpose', 'x_DateTime', 'OperationPurposeLifeID', '["x_DateTime", "OperationPurposeLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["OperationPurposeID"]', '["OperationPurposeLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('stt_Dead', 'stt_dead', 'incremental', 'full_then_incremental', 'Life_stt_Dead', 'x_DateTime', 'DeadLifeID', '["x_DateTime", "DeadLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["DeadID"]', '["DeadLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('hlt_Invoice', 'hlt_invoice', 'incremental', 'full_then_incremental', 'Life_hlt_Invoice', 'x_DateTime', 'InvoiceLifeID', '["x_DateTime", "InvoiceLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["InvoiceID"]', '["InvoiceLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('stt_ReestrOccasion', 'stt_reestroccasion', 'incremental', 'full_then_incremental', 'Life_stt_ReestrOccasion', 'x_DateTime', 'ReestrOccasionLifeID', '["x_DateTime", "ReestrOccasionLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["ReestrOccasionID"]', '["ReestrOccasionLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('stt_ReestrMKSB', 'stt_reestrmksb', 'incremental', 'full_then_incremental', 'Life_stt_ReestrMKSB', 'x_DateTime', 'ReestrMKSBLifeID', '["x_DateTime", "ReestrMKSBLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["ReestrMKSBID"]', '["ReestrMKSBLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('oms_StateBirth', 'oms_statebirth', 'incremental', 'full_then_incremental', 'Life_oms_StateBirth', 'x_DateTime', 'StateBirthLifeID', '["x_DateTime", "StateBirthLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["StateBirthID"]', '["StateBirthLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('stt_EmerSign', 'stt_emersign', 'incremental', 'full_then_incremental', 'Life_stt_EmerSign', 'x_DateTime', 'EmerSignLifeID', '["x_DateTime", "EmerSignLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["EmerSignID"]', '["EmerSignLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('hlt_ReestrMHSMTAP', 'hlt_reestrmhsmtap', 'incremental', 'full_then_incremental', 'Life_hlt_ReestrMHSMTAP', 'x_DateTime', 'ReestrMHSMTAPLifeID', '["x_DateTime", "ReestrMHSMTAPLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["ReestrMHSMTAPID"]', '["ReestrMHSMTAPLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('die_Certificate', 'die_certificate', 'incremental', 'full_then_incremental', 'Life_die_Certificate', 'x_DateTime', 'CertificateLifeID', '["x_DateTime", "CertificateLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["CertificateID"]', '["CertificateLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('hlt_PolisMKAB', 'hlt_polismkab', 'incremental', 'full_then_incremental', 'Life_hlt_PolisMKAB', 'x_DateTime', 'PolisMKABLifeID', '["x_DateTime", "PolisMKABLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["PolisMKABID"]', '["PolisMKABLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('oms_ParamValue', 'oms_paramvalue', 'incremental', 'full_then_incremental', 'Life_oms_ParamValue', 'x_DateTime', 'ParamValueLifeID', '["x_DateTime", "ParamValueLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["ParamValueID"]', '["ParamValueLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('hlt_dent_tech_OrderSM', 'hlt_dent_tech_ordersm', 'incremental', 'full_then_incremental', 'Life_hlt_dent_tech_OrderSM', 'x_DateTime', 'dent_tech_OrderSMLifeID', '["x_DateTime", "dent_tech_OrderSMLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["dent_tech_OrderSMID"]', '["dent_tech_OrderSMLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('hlt_disp_CardPlan', 'hlt_disp_cardplan', 'incremental', 'full_then_incremental', 'Life_hlt_disp_CardPlan', 'x_DateTime', 'disp_CardPlanLifeID', '["x_DateTime", "disp_CardPlanLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["disp_CardPlanID"]', '["disp_CardPlanLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('hlt_DUVisit', 'hlt_duvisit', 'incremental', 'full_then_incremental', 'Life_hlt_DUVisit', 'x_DateTime', 'DUVisitLifeID', '["x_DateTime", "DUVisitLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["DUVisitID"]', '["DUVisitLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('hlt_disp_PatientModel', 'hlt_disp_patientmodel', 'incremental', 'full_then_incremental', 'Life_hlt_disp_PatientModel', 'x_DateTime', 'disp_PatientModelLifeID', '["x_DateTime", "disp_PatientModelLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["disp_PatientModelID"]', '["disp_PatientModelLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('oms_ServiceMedical', 'oms_servicemedical', 'incremental', 'full_then_incremental', 'Life_oms_ServiceMedical', 'x_DateTime', 'ServiceMedicalLifeID', '["x_DateTime", "ServiceMedicalLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["ServiceMedicalID"]', '["ServiceMedicalLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('stt_Diagnos', 'stt_diagnos', 'incremental', 'full_then_incremental', 'Life_stt_Diagnos', 'x_DateTime', 'DiagnosLifeID', '["x_DateTime", "DiagnosLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["DiagnosID"]', '["DiagnosLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('hlt_TAP', 'hlt_tap', 'incremental', 'full_then_incremental', 'Life_hlt_TAP', 'x_DateTime', 'TAPLifeID', '["x_DateTime", "TAPLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["TAPID"]', '["TAPLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('hlt_MKAB', 'hlt_mkab', 'incremental', 'full_then_incremental', 'Life_hlt_MKAB', 'x_DateTime', 'MKABLifeID', '["x_DateTime", "MKABLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["MKABID"]', '["MKABLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('hlt_LPUDoctor', 'hlt_lpudoctor', 'incremental', 'full_then_incremental', 'Life_hlt_LPUDoctor', 'x_DateTime', 'LPUDoctorLifeID', '["x_DateTime", "LPUDoctorLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["LPUDoctorID"]', '["LPUDoctorLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('stt_SurgicalOperation', 'stt_surgicaloperation', 'incremental', 'full_then_incremental', 'Life_stt_SurgicalOperation', 'x_DateTime', 'SurgicalOperationLifeID', '["x_DateTime", "SurgicalOperationLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["SurgicalOperationID"]', '["SurgicalOperationLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('hlt_DocPRVD', 'hlt_docprvd', 'incremental', 'full_then_incremental', 'Life_hlt_DocPRVD', 'x_DateTime', 'DocPRVDLifeID', '["x_DateTime", "DocPRVDLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["DocPRVDID"]', '["DocPRVDLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('Oms_mkb', 'oms_mkb', 'incremental', 'full_then_incremental', 'Life_Oms_mkb', 'x_DateTime', 'MKBLifeID', '["x_DateTime", "MKBLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["MKBID"]', '["MKBLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('stt_NewbornHistory', 'stt_newbornhistory', 'incremental', 'full_then_incremental', 'Life_stt_NewbornHistory', 'x_DateTime', 'NewbornHistoryLifeID', '["x_DateTime", "NewbornHistoryLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["NewbornHistoryID"]', '["NewbornHistoryID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('stt_MedicalHistory', 'stt_medicalhistory', 'incremental', 'full_then_incremental', 'Life_stt_MedicalHistory', 'x_DateTime', 'MedicalHistoryLifeID', '["x_DateTime", "MedicalHistoryLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["MedicalHistoryID"]', '["MedicalHistoryLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('hlt_RegMedicalCheck', 'hlt_regmedicalcheck', 'incremental', 'full_then_incremental', 'Life_hlt_RegMedicalCheck', 'x_DateTime', 'RegMedicalCheckLifeID', '["x_DateTime", "RegMedicalCheckLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["RegMedicalCheckID"]', '["RegMedicalCheckLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('stt_Bed', 'stt_bed', 'incremental', 'full_then_incremental', 'Life_stt_Bed', 'x_DateTime', 'BedLifeID', '["x_DateTime", "BedLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["BedID"]', '["BedLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('hlt_SMTAP', 'hlt_smtap', 'incremental', 'full_then_incremental', 'Life_hlt_SMTAP', 'x_DateTime', 'SMTAPLifeID', '["x_DateTime", "SMTAPLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["SMTAPID"]', '["SMTAPLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('hlt_disp_Type', 'hlt_disp_type', 'incremental', 'full_then_incremental', 'Life_hlt_disp_Type', 'x_DateTime', 'disp_TypeLifeID', '["x_DateTime", "disp_TypeLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["disp_TypeID"]', '["disp_TypeLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('stt_MedServicePatient', 'stt_medservicepatient', 'incremental', 'full_then_incremental', 'Life_stt_MedServicePatient', 'x_DateTime', 'MedServicePatientLifeID', '["x_DateTime", "MedServicePatientLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["MedServicePatientID"]', '["MedServicePatientLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('hlt_BillService', 'hlt_billservice', 'incremental', 'full_then_incremental', 'Life_hlt_BillService', 'x_DateTime', 'BillServiceLifeID', '["x_DateTime", "BillServiceLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["BillServiceID"]', '["BillServiceLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('hlt_ReestrMH', 'hlt_reestrmh', 'incremental', 'full_then_incremental', 'Life_hlt_ReestrMH', 'x_DateTime', 'ReestrMHLifeID', '["x_DateTime", "ReestrMHLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["ReestrMHID"]', '["ReestrMHLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
INSERT INTO replicator.migration_tables (source_table, target_table, mode, initial_load_mode, life_table, datetime_column, sequence_column, order_columns_json, operation_column, delete_operations_json, upsert_operations_json, primary_key_json, exclude_columns_json, timescale, timescale_time_column, enabled, created_at, updated_at) VALUES ('hlt_disp_ServicePM', 'hlt_disp_servicepm', 'incremental', 'full_then_incremental', 'Life_hlt_disp_ServicePM', 'x_DateTime', 'disp_ServicePMLifeID', '["x_DateTime", "disp_ServicePMLifeID"]', 'x_Operation', '["d"]', '["i", "u"]', '["disp_ServicePMID"]', '["disp_ServicePMLifeID", "x_Operation", "x_DateTime", "x_Seance", "x_User"]', false, null, true, '2026-04-13 07:02:42.339557', '2026-04-13 07:02:42.339557');
Reference in New Issue View Git Blame Copy Permalink