摘要:序设计了几张表,这里简单介绍下主要用来存储对象的每次变更操作以及变更的属性值。存储了每次变更的存储了每次变更的时间变更人支持自动从获取也可以自定义,比如用来存储额外的信息,比如存储了用户,顺带存一下用户名等。
序
javers设计了几张表,这里简单介绍下
jv_snapshot主要用来存储对象的每次变更操作以及变更的属性值。
-- ---------------------------- -- Table structure for jv_snapshot -- ---------------------------- DROP TABLE IF EXISTS "public"."jv_snapshot"; CREATE TABLE "public"."jv_snapshot" ( "snapshot_pk" int8 NOT NULL, "type" varchar(200) COLLATE "default", "version" int8, "state" text COLLATE "default", "changed_properties" text COLLATE "default", "managed_type" varchar(200) COLLATE "default", "global_id_fk" int8, "commit_fk" int8 ) WITH (OIDS=FALSE); ALTER TABLE "public"."jv_snapshot" OWNER TO "postgres"; -- ---------------------------- -- Primary key structure for table jv_snapshot -- ---------------------------- ALTER TABLE "public"."jv_snapshot" ADD PRIMARY KEY ("snapshot_pk") NOT DEFERRABLE INITIALLY IMMEDIATE; -- ---------------------------- -- Indexes structure for table jv_snapshot -- ---------------------------- CREATE INDEX "jv_snapshot_commit_fk_idx" ON "public"."jv_snapshot" USING btree(commit_fk "pg_catalog"."int8_ops" ASC NULLS LAST); CREATE INDEX "jv_snapshot_global_id_fk_idx" ON "public"."jv_snapshot" USING btree(global_id_fk "pg_catalog"."int8_ops" ASC NULLS LAST); -- ---------------------------- -- Foreign keys structure for table jv_snapshot -- ---------------------------- ALTER TABLE "public"."jv_snapshot" ADD CONSTRAINT "jv_snapshot_commit_fk" FOREIGN KEY ("commit_fk") REFERENCES "public"."jv_commit" ("commit_pk") ON UPDATE NO ACTION ON DELETE NO ACTION NOT DEFERRABLE INITIALLY IMMEDIATE; ALTER TABLE "public"."jv_snapshot" ADD CONSTRAINT "jv_snapshot_global_id_fk" FOREIGN KEY ("global_id_fk") REFERENCES "public"."jv_global_id" ("global_id_pk") ON UPDATE NO ACTION ON DELETE NO ACTION NOT DEFERRABLE INITIALLY IMMEDIATE;jv_global_id
存储了每次变更的id
-- ---------------------------- -- Table structure for jv_global_id -- ---------------------------- DROP TABLE IF EXISTS "public"."jv_global_id"; CREATE TABLE "public"."jv_global_id" ( "global_id_pk" int8 NOT NULL, "local_id" varchar(200) COLLATE "default", "fragment" varchar(200) COLLATE "default", "type_name" varchar(200) COLLATE "default", "owner_id_fk" int8 ) WITH (OIDS=FALSE); ALTER TABLE "public"."jv_global_id" OWNER TO "postgres"; -- ---------------------------- -- Primary key structure for table jv_global_id -- ---------------------------- ALTER TABLE "public"."jv_global_id" ADD PRIMARY KEY ("global_id_pk") NOT DEFERRABLE INITIALLY IMMEDIATE; -- ---------------------------- -- Indexes structure for table jv_global_id -- ---------------------------- CREATE INDEX "jv_global_id_local_id_idx" ON "public"."jv_global_id" USING btree(local_id COLLATE "default" "pg_catalog"."text_ops" ASC NULLS LAST); -- ---------------------------- -- Foreign keys structure for table jv_global_id -- ---------------------------- ALTER TABLE "public"."jv_global_id" ADD CONSTRAINT "jv_global_id_owner_id_fk" FOREIGN KEY ("owner_id_fk") REFERENCES "public"."jv_global_id" ("global_id_pk") ON UPDATE NO ACTION ON DELETE NO ACTION NOT DEFERRABLE INITIALLY IMMEDIATE;jv_commit
存储了每次变更的时间、变更人
-- ---------------------------- -- Table structure for jv_commit -- ---------------------------- DROP TABLE IF EXISTS "public"."jv_commit"; CREATE TABLE "public"."jv_commit" ( "commit_pk" int8 NOT NULL, "author" varchar(200) COLLATE "default", "commit_date" timestamp(6) NULL, "commit_id" numeric(22,2) ) WITH (OIDS=FALSE); ALTER TABLE "public"."jv_commit" OWNER TO "postgres"; -- ---------------------------- -- Primary key structure for table jv_commit -- ---------------------------- ALTER TABLE "public"."jv_commit" ADD PRIMARY KEY ("commit_pk") NOT DEFERRABLE INITIALLY IMMEDIATE; -- ---------------------------- -- Indexes structure for table jv_commit -- ---------------------------- CREATE INDEX "jv_commit_commit_id_idx" ON "public"."jv_commit" USING btree(commit_id "pg_catalog"."numeric_ops" ASC NULLS LAST);
支持自动从SpringSecurity获取auditor
public class SpringSecurityAuthorProvider implements AuthorProvider { public SpringSecurityAuthorProvider() { } public String provide() { Authentication auth = SecurityContextHolder.getContext().getAuthentication(); return auth == null?"unauthenticated":auth.getName(); } }
也可以自定义,比如
@Bean public AuthorProvider authorProvider() { return new MockAuthorProvider(); }jv_commit_property
用来存储额外的信息,比如存储了用户id,顺带存一下用户名等。
-- ---------------------------- -- Table structure for jv_commit_property -- ---------------------------- DROP TABLE IF EXISTS "public"."jv_commit_property"; CREATE TABLE "public"."jv_commit_property" ( "property_name" varchar(200) NOT NULL COLLATE "default", "property_value" varchar(600) COLLATE "default", "commit_fk" int8 NOT NULL ) WITH (OIDS=FALSE); ALTER TABLE "public"."jv_commit_property" OWNER TO "postgres"; -- ---------------------------- -- Primary key structure for table jv_commit_property -- ---------------------------- ALTER TABLE "public"."jv_commit_property" ADD PRIMARY KEY ("commit_fk", "property_name") NOT DEFERRABLE INITIALLY IMMEDIATE; -- ---------------------------- -- Indexes structure for table jv_commit_property -- ---------------------------- CREATE INDEX "jv_commit_property_commit_fk_idx" ON "public"."jv_commit_property" USING btree(commit_fk "pg_catalog"."int8_ops" ASC NULLS LAST); CREATE INDEX "jv_commit_property_property_name_property_value_idx" ON "public"."jv_commit_property" USING btree(property_name COLLATE "default" "pg_catalog"."text_ops" ASC NULLS LAST, property_value COLLATE "default" "pg_catalog"."text_ops" ASC NULLS LAST); -- ---------------------------- -- Foreign keys structure for table jv_commit_property -- ---------------------------- ALTER TABLE "public"."jv_commit_property" ADD CONSTRAINT "jv_commit_property_commit_fk" FOREIGN KEY ("commit_fk") REFERENCES "public"."jv_commit" ("commit_pk") ON UPDATE NO ACTION ON DELETE NO ACTION NOT DEFERRABLE INITIALLY IMMEDIATE;
可以这样自定义
@Bean public CommitPropertiesProvider commitPropertiesProvider() { return new CommitPropertiesProvider() { @Override public Mapdocprovide() { return ImmutableMap.of("key", "ok"); } }; }
javers
文章版权归作者所有,未经允许请勿转载,若此文章存在违规行为,您可以联系管理员删除。
转载请注明本文地址:https://www.ucloud.cn/yun/67506.html
摘要:谈谈如何设计评论表的表结构前言打算使用打造一个博客的后台,遇到了如何设计评论表的困惑,因为如果采用开放评论的模式,就会导致评论的层层嵌套,使得管理和展示都变得非常复杂。 谈谈mongodb如何设计评论表的表结构 前言: 打算使用node+koa+mongodb打造一个博客的后台,遇到了如何设计评论表的困惑,因为如果采用开放评论的模式,就会导致评论的层层嵌套,使得管理和展示都变得非常复杂...
摘要:支持崩溃后的安全恢复。的使用场景更新密集的表存储引擎特别适合处理多重并发的更新请求。外键约束支持外键的存储引擎只有。引擎是及之前版本的默认存储引擎。文件存储表的索引。引擎存储引擎是引擎的变种。 MySQL基础知识点整理 - 存储引擎 0. 查看 MySQL 支持的存储引擎 可以在 mysql 客户端中,使用 show engines; 命令可以查看MySQL支持的引擎: mysql> ...
阅读 3460·2021-09-27 13:35
阅读 3523·2019-08-29 17:09
阅读 2378·2019-08-26 11:30
阅读 671·2019-08-26 10:32
阅读 499·2019-08-26 10:23
阅读 1163·2019-08-26 10:20
阅读 3122·2019-08-23 15:26
阅读 3429·2019-08-23 14:33