mint/documents/zh/api/translation.md

译文

句子块 sent_block

CREATE TABLE sent_block (
    id SERIAL PRIMARY KEY,
    uuid         VARCHAR (36),
    parent_id    VARCHAR (36),
    book         INTEGER,
    paragraph    INTEGER,
    owner_id     INTEGER NOT NULL,
    owner        VARCHAR (36) NOT NULL,
    lang         VARCHAR (8),
    author       VARCHAR (50),
    editor_id    INTEGER,
    editor       TEXT,
    status       INTEGER,
    create_at  BIGINT,
    update_at  BIGINT,
    delete_at  BIGINT
);

book 书号

paragraph 书号

author

编辑者列表。还没设计好。 可能是这样

[
    {"creater":"bhikkhu bodhi"},
    {"translater":"bhikkhu kosalla"},
]

editor 数据提交者 旧表中用 user_name 新表用 editor_id

owner 记录的创建者

sentence

CREATE TABLE sentence (
    id           int PRIMARY KEY,
    uuid           CHAR (36) ,
    parent       CHAR (36),
    block_id     CHAR (36),
    channel_id      CHAR (36),
    book         INTEGER   NOT NULL,
    paragraph    INTEGER   NOT NULL,
    start      INTEGER   NOT NULL,
    end        INTEGER   NOT NULL,
    author       TEXT,
    editor_id       CHAR (36),
    text         TEXT,
    language     CHAR (8),
    version      INTEGER,
    status       INTEGER,
    strlen       INTEGER,
    create_at    BIGINT  NOT NULL,
    update_at    BIGINT   NOT NULL,
    delete_at    BIGINT,

);

uuid 原表的主键 新表中用 int 代替

channel_id 外键 原表 channal uuid 导入后应改为 int

editor_id 记录的上传者 外键 原表用 uuid 现在改用 int

text 句子文本

version 用于乐观锁 每次更新+1

strlen 句子字符数

CREATE TABLE sent_pr (
    id           INTEGER      PRIMARY KEY AUTOINCREMENT,
    book         INTEGER      NOT NULL,
    paragraph    INTEGER      NOT NULL,
    start      INTEGER      NOT NULL,
    end        INTEGER      NOT NULL,
    channel_id      VARCHAR (36),
    author       VARCHAR (40),
    editor_id       VARCHAR (36),
    text         TEXT,
    language     VARCHAR (8),
    status       INTEGER,
    strlen       INTEGER,
    create_at    BIGINT  NOT NULL,
    update_at    BIGINT   NOT NULL,
    delete_at    BIGINT,
);

修改历史

CREATE TABLE sent_historay (
    sent_id  CHAR (36),
    user_id  CHAR (36),
    text     TEXT,
    create_at     BIGINT NOT NULL,
    landmark VARCHAR(32)
);

sent_id 外键 导入后改为 int

user_id 外键 导入后改为 int

text 句子文本

landmark 里程碑标记