CREATE TABLE share_to (
id SERIAL PRIMARY KEY,
res_id INTEGER NOT NULL,
res_uuid VARCHAR (36),
res_type INTEGER,
cooperator_id INTEGER NOT NULL,
cooperator_uuid VARCHAR (36),
cooperator_type INTEGER NOT NULL,
right INTEGER NOT NULL DEFAULT 0,
version INTEGER NOT NULL DEFAULT 0,
created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP NOT NULL
);
分享资源给用户或者群组。
res_id 资源id 原来的表中是uuid 导入后改为 int
res_type 资源类型
cooperator_id 用户或工作组id
cooperator_type
right 权限
拥有者
CREATE TABLE share_link (
id SERIAL PRIMARY KEY,
link_id VARCHAR (36) UNIQUE,
res_id INTEGER NOT NULL,
res_type INTEGER,
right INTEGER,
version INTEGER NOT NULL DEFAULT 0,
created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP NOT NULL
);
分享资源链接
link_id uuid
res_id 资源id 原来的表中是uuid 导入后改为 int
res_type 资源类型