SPAY4 · CURRENT AUTHORITY

SQL 初始化

CURRENT

先以 ddl.sql 建立 51 relations,schema read-back 後才執行 seed 與 read-back。

所有 SQL 均須 DBA 與 Operator 個別審核。

所有 SQL 均須 DBA 與 Operator 個別審核。
14 Core + 37 Domain = 51 relations;所有關係為 logical relation。

ddl.sql → schema read-back → data.sql → seed read-back

初始化候選 SQL 不是 migration 或 target 操作授權。總 inventory 為 51 relations,沒有 database foreign key。

Core · 14

currencybankagentnotification_provider_sourcecredential_referencecredential_secretagent_banksystem_groupsystem_methodrolerole_methodusersystem_configagent_system_config

Domain · 37

external_api_replay_noncesuppliersupply_gatewaysupply_accountdomain_audit_logsupply_pt_policysupply_pt_revisionsupply_pt_revision_linesupply_gateway_direction_configsupply_gateway_agent_allocationsupply_eligible_factsupply_eligible_fact_correctionsupply_eligible_fact_projection_queuesupply_eligible_fact_projection_failure_attemptsupply_aggregate_projection_watermarksupply_financial_hourly_aggregatesupply_cardholdersupply_cardholder_sessionsupply_cardholder_device_tokensupply_cardholder_notificationpayment_account_applicationpayment_accountpayment_account_balance_loghouse_cardpayment_account_daily_countersupply_cardholder_daily_assignment_counteragent_api_order_claimsupply_deposit_ordersupply_withdrawal_ordersupply_order_assignment_attemptagent_callback_outboxpayment_account_reservationsupply_order_proofhouse_card_transactionsupply_withdrawal_recovery_casehouse_card_daily_counterhouse_card_deposit_reservation

來源:concepts/sql-initialization.md(SQL 初始化頁除外)。

圖片預覽