系统分析

最新推荐文章于 2024-06-28 09:12:59 发布

原创最新推荐文章于 2024-06-28 09:12:59 发布 · 773 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#integer #null #table #structure #脚本

JAVA 专栏收录该内容

68 篇文章

订阅专栏

本文提供了一组DB2数据库中表结构的创建脚本。这些表涉及公司、部门、职责等组织架构相关实体及用户权限配置，为构建企业级应用提供了必要的数据库支持。

]

db2脚本：

    create table "WPDB2INS"."COMPANY"(
        "ID" INTEGER generated by default as identity,
       "COMPANYID" INTEGER not null,
       "TITLE" VARCHAR(100) not null,
       "EXPLAIN" VARCHAR(100) not null,
       "DISABLED" VARCHAR (1) not null
    );

    create table "WPDB2INS"."DEPARTMENT"(
        "ID" INTEGER generated by default as identity,
       "DEPARTMENTID" INTEGER not null,
       "TITLE" VARCHAR(50) not null,
       "EXPLAIN" VARCHAR(100) not null,
       "DISABLED" VARCHAR (1) not null,
       "MANAGEMENTCODE" VARCHAR(10) not null
    );

    create table "WPDB2INS"."DUTY"(
        "ID" INTEGER generated by default as identity,
       "DUTYID" INTEGER not null,
       "TITLE" VARCHAR(50) not null,
       "EXPLAIN" VARCHAR(100),
       "DISABLED" VARCHAR (1) not null
    );

    create table "WPDB2INS"."EGROUP"(
        "ID" INTEGER generated by default as identity,
       "EGROUPID" INTEGER not null,
       "TITLE" VARCHAR(100) not null,
       "EXPLAIN" VARCHAR(100) not null,
       "DISABLED" INTEGER not null
    );

    create table "WPDB2INS"."GROUP"(
        "GROUPID" INTEGER not null,
       "ID" INTEGER generated by default as identity,
       "TITLE" VARCHAR(50) not null,
       "EXPLAIN" VARCHAR(100),
       "DISABLED" VARCHAR (1) not null,
        constraint "GROUPID" primary key ("GROUPID")
    );

    create unique index "WPDB2INS"."GROUPID" on "WPDB2INS"."GROUP"("GROUPID");

    create table "WPDB2INS"."GROUP-ROLE"(
        "ID" INTEGER generated by default as identity,
       "GROUPID" INTEGER not null,
       "ROLEID" INTEGER not null,
       "DISABLED" VARCHAR (1) not null
    );

    create table "WPDB2INS"."RESOURCE"(
        "ID" INTEGER generated by default as identity,
       "RESOURCEID" INTEGER not null,
       "TITLE" VARCHAR(50) not null,
       "EXPLAIN" VARCHAR(100),
       "DISABLED" VARCHAR (1) not null,
       "RESOURCEURL" VARCHAR(200) not null,
        constraint "RESOURCEID" primary key ("RESOURCEID")
    );

    create unique index "WPDB2INS"."RESOURCEID" on "WPDB2INS"."RESOURCE"("RESOURCEID");

    create table "WPDB2INS"."ROLE"(
        "ID" INTEGER generated by default as identity,
       "ROLEID" INTEGER not null,
       "TITLE" VARCHAR(50) not null,
       "EXPLAIN" VARCHAR(50),
       "DISABLED" VARCHAR (1) not null,
        constraint "ROLEID" primary key ("ROLEID")
    );

    create unique index "WPDB2INS"."ROLEID" on "WPDB2INS"."ROLE"("ROLEID");

    create table "WPDB2INS"."ROLE-RESOURCE"(
        "ID" INTEGER generated by default as identity,
       "ROLEID" INTEGER not null,
       "RESOURCEID" INTEGER not null,
       "DISABLED" VARCHAR (1) not null
    );

    create table "WPDB2INS"."STRUCT-DUTY"(
        "ID" INTEGER generated by default as identity,
       "DEPARTMENTID" INTEGER not null,
       "DUTYID" INTEGER not null,
       "DISABLED" VARCHAR (1) not null
    );

    create table "WPDB2INS"."STRUCTURE"(
        "ID" INTEGER generated by default as identity,
       "SID" INTEGER not null,
       "PARENTID" INTEGER not null,
       "LEVELID" INTEGER not null,
       "DEPARTMENTID" INTEGER not null,
       "DEPCODE" VARCHAR(10) not null,
       "DISABLED" VARCHAR (1) default '0' not null
    );

    create table "WPDB2INS"."USER-AGENT"(
        "ID" INTEGER generated by default as identity,
       "UID" INTEGER not null,
       "EGROUPID" VARCHAR(1) not null,
       "COMPANYID" VARCHAR(1) not null,
       "DEPARTMENTID" VARCHAR(2) not null,
       "DUTYID" INTEGER not null,
       "AGENTID" INTEGER not null,
       "DUTYCODE" VARCHAR(10) not null
    );

    create table "WPDB2INS"."USER-DUTY"(
        "ID" INTEGER generated by default as identity,
       "UID" INTEGER not null,
       "EGROUPID" VARCHAR(1) not null,
       "COMPANYID" VARCHAR(1) not null,
       "DEPARTMENTID" VARCHAR(2) not null,
       "DUTYID" INTEGER not null,
       "DUTYCODE" VARCHAR(10) not null
    );

    create table "WPDB2INS"."USER-GROUP"(
        "ID" INTEGER generated by default as identity,
       "UID" INTEGER not null,
       "GROUPID" INTEGER not null,
       "DISABLED" VARCHAR (1) not null
    );

    create table "WPDB2INS"."USER-RESOURCE"(
        "ID" INTEGER generated by default as identity,
       "UID" INTEGER not null,
       "RESOURCEID" INTEGER not null,
       "DISABLED" VARCHAR (1) not null
    );

    create table "WPDB2INS"."USERS"(
        "ID" INTEGER generated by default as identity,
       "UID" INTEGER not null,
       "USERNAME" VARCHAR(50) not null,
       "PASSWORD" VARCHAR(50) not null,
       "NAME" VARCHAR(50) not null,
       "EXPLAIN" VARCHAR(100),
       "DISABLED" VARCHAR (1) not null,
       "LDAP" VARCHAR(100),
        constraint "UID" primary key ("UID")
    );

    create unique index "WPDB2INS"."UID" on "WPDB2INS"."USERS"("UID");