okayapi_jsh_orga_user_rel - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_jsh_orga_user_rel：/tablelist/okayapi_jsh_orga_user_rel.html


-- MySQL Table okayapi_jsh_orga_user_rel
-- From: OkayAPI.com
CREATE TABLE `okayapi_jsh_orga_user_rel` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `orga_id` bigint(20) NULL COMMENT '机构id',
    `user_id` bigint(20) NULL COMMENT '用户id',
    `user_blng_orga_dspl_seq` varchar(20) NULL COMMENT '用户在所属机构中显示顺序',
    `delete_flag` char(1) NULL DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
    `create_time` datetime NULL COMMENT '创建时间',
    `creator` bigint(20) NULL COMMENT '创建人',
    `updater` bigint(20) NULL COMMENT '更新人',
    `tenant_id` bigint(20) NULL COMMENT '租户id',
    KEY `orga_id` (`orga_id`),
    KEY `user_id` (`user_id`),
    KEY `user_blng_orga_dspl_seq` (`user_blng_orga_dspl_seq`),
    KEY `delete_flag` (`delete_flag`),
    KEY `create_time` (`create_time`),
    KEY `creator` (`creator`),
    KEY `updater` (`updater`),
    KEY `tenant_id` (`tenant_id`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'ERP进销存-机构用户关系表';

After replication, you can go to the database to create the database table.

MySQL database table structure design

Displaying 1-8 of 8 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
orga_id	bigint(20)		否	机构id
user_id	bigint(20)		否	用户id
user_blng_orga_dspl_seq	varchar(20)		是	用户在所属机构中显示顺序
delete_flag	char(1)	0	是	删除标记，0未删除，1删除	0
create_time	datetime		是	创建时间
creator	bigint(20)		是	创建人
updater	bigint(20)		是	更新人
tenant_id	bigint(20)		是	租户id