字段联动

CREATE TABLE IF NOT EXISTS app_dictionary (
  id BIGINT PRIMARY KEY,
  parent_id BIGINT,
  code VARCHAR(64) NOT NULL,
  label VARCHAR(100) NOT NULL,
  sort INTEGER NOT NULL DEFAULT 0,
  creator VARCHAR(64) NOT NULL DEFAULT '',
  create_time TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP,
  updater VARCHAR(64) NOT NULL DEFAULT '',
  update_time TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP,
  deleted SMALLINT NOT NULL DEFAULT 0,
  tenant_id BIGINT NOT NULL DEFAULT 0
);
CREATE UNIQUE INDEX IF NOT EXISTS app_dictionary_active_code
  ON app_dictionary (tenant_id, code) WHERE deleted = 0;
CREATE INDEX IF NOT EXISTS app_dictionary_parent
  ON app_dictionary (tenant_id, parent_id, sort, id) WHERE deleted = 0;