tradingSystem/ddl_rotation_v1.sql

10 lines
452 B
MySQL
Raw Permalink Normal View History

-- 轮换状态、快照、验收证据及独立纸面账本。与交易表分开存储。
CREATE TABLE IF NOT EXISTS pms_rotation_document (
doc_id VARCHAR(128) NOT NULL PRIMARY KEY,
kind VARCHAR(32) NOT NULL,
payload_json LONGTEXT NOT NULL,
revision BIGINT NOT NULL DEFAULT 0,
updated_at DATETIME NOT NULL,
KEY idx_kind_updated (kind, updated_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='轮换持久状态与独立纸面记录';