企业讯息.dmj

{
  "RootName": "DataModels",
  "CTVER": "43543231",
  "TableCount": 5,
  "Count": 1,
  "items": [{
    "ID": 9,
    "Name": "企业讯息更新版",
    "CreateDate": "2019/9/19 10:45:26",
    "OrderNo": 1,
    "ConfigStr": "DrawerWidth=2120\nDrawerHeight=2880\nWorkAreaColor=12639424\nSelectedColor=-16777203\nDefaultObjectColor=15921906\nDefaultTitleColor=255\nDefaultPKColor=16711935\nDefaultFKColor=16711680\nDefaultBorderColor=12632256\nDefaultLineColor=16711680\nShowFieldType=1\nShowFieldIcon=1\nShowPhyFieldName=2\nDatabaseEngine=\nGenFKIndexesSQL=0\n",
    "Tables": {
      "Count": 5,
      "items": [
        {
          "Name": "cms_content",
          "Caption": "内容表",
          "Memo": "内容表",
          "OrderNo": 1,
          "GraphDesc": "Left=184.00\r\nTop=766.00",
          "MetaFields": {
            "Count": 28,
            "items": [
              {
                "ID": 1,
                "Name": "id",
                "OrderNo": 1,
                "DisplayName": "主键",
                "DataType": 2,
                "KeyFieldType": 1,
                "DefaultValue": "{auto_increment}"
              },
              {
                "ID": 2,
                "Name": "contenttypeid",
                "Memo": "类型id",
                "OrderNo": 2,
                "DisplayName": "类型id",
                "DataType": 2,
                "Nullable": true,
                "GraphDesc": "P1=1097.00,538.00\nP2=1040.00,538.00\nP3=1040.00,538.00\nP4=984.00,538.00\nHookP1=20.00,27.00\nHookP2=219.00,528.00\nMod_OP1=0\nMod_OP2=1\nMod_CP=0\nHorz1=1\nHorz2=1"
              },
              {
                "ID": 3,
                "Name": "title",
                "Memo": "标题",
                "OrderNo": 3,
                "DisplayName": "标题",
                "DataType": 1,
                "Nullable": true,
                "DataLength": 50
              },
              {
                "ID": 4,
                "Name": "author",
                "Memo": "作者",
                "OrderNo": 4,
                "DisplayName": "作者",
                "DataType": 1,
                "Nullable": true,
                "DataLength": 25
              },
              {
                "ID": 5,
                "Name": "summary",
                "Memo": "内容",
                "OrderNo": 5,
                "DisplayName": "内容",
                "DataType": 7,
                "Nullable": true
              },
              {
                "ID": 6,
                "Name": "source",
                "Memo": "出处",
                "OrderNo": 6,
                "DisplayName": "出处",
                "DataType": 1,
                "Nullable": true,
                "DataLength": 30
              },
              {
                "ID": 7,
                "Name": "introduction",
                "Memo": "摘要",
                "OrderNo": 7,
                "DisplayName": "摘要",
                "DataType": 7,
                "Nullable": true
              },
              {
                "ID": 8,
                "Name": "linkaddress",
                "Memo": "链接",
                "OrderNo": 8,
                "DisplayName": "链接",
                "DataType": 1,
                "Nullable": true,
                "DataLength": 500
              },
              {
                "ID": 9,
                "Name": "addeddate",
                "Memo": "录入时间",
                "OrderNo": 9,
                "DisplayName": "录入时间",
                "DataType": 2,
                "Nullable": true,
                "DataLength": 20
              },
              {
                "ID": 10,
                "Name": "releasestate",
                "Memo": "发布状态 0:已发布；1：未发布；2：已收回；3：定时发布中",
                "OrderNo": 10,
                "DisplayName": "发布状态",
                "DataType": 2,
                "DefaultValue": "1",
                "Nullable": true
              },
              {
                "ID": 11,
                "Name": "status",
                "Memo": "审核状态 0:审核中；1：审核通过；2：审核不通过",
                "OrderNo": 11,
                "DisplayName": "审核状态",
                "DataType": 2,
                "DefaultValue": "2",
                "Nullable": true
              },
              {
                "ID": 12,
                "Name": "userid",
                "Memo": "责任编辑-用户id",
                "OrderNo": 12,
                "DisplayName": "责任编辑-用户id",
                "DataType": 2,
                "Nullable": true
              },
              {
                "ID": 13,
                "Name": "organization_id",
                "Memo": "归属商户id",
                "OrderNo": 13,
                "DisplayName": "归属商户id",
                "DataType": 2,
                "Nullable": true
              },
              {
                "ID": 16,
                "Name": "existencestatus",
                "Memo": "状态 1:正常 2:删除",
                "OrderNo": 14,
                "DisplayName": "状态",
                "DataType": 2,
                "Nullable": true,
                "DataLength": 4
              },
              {
                "ID": 17,
                "Name": "auditor",
                "Memo": "审核人(用户ID)",
                "OrderNo": 15,
                "DisplayName": "审核人(用户ID)",
                "DataType": 2,
                "Nullable": true,
                "DataLength": 10
              },
              {
                "ID": 18,
                "Name": "audittime",
                "Memo": "审核时间",
                "OrderNo": 16,
                "DisplayName": "审核时间",
                "DataType": 4,
                "Nullable": true,
                "DataLength": 19
              },
              {
                "ID": 19,
                "Name": "auditopinion",
                "Memo": "审核意见",
                "OrderNo": 17,
                "DisplayName": "审核意见",
                "DataType": 1,
                "Nullable": true,
                "DataLength": 200
              },
              {
                "ID": 25,
                "Name": "releasetime",
                "Memo": "发布时间",
                "OrderNo": 18,
                "DisplayName": "发布时间",
                "DataType": 4,
                "Nullable": true,
                "DataLength": 19
              },
              {
                "ID": 32,
                "Name": "eventremindingtime",
                "Memo": "提醒时间",
                "OrderNo": 19,
                "DisplayName": "提醒时间",
                "DataType": 2,
                "Nullable": true,
                "DataLength": 20
              },
              {
                "ID": 33,
                "Name": "sender",
                "Memo": "发送人-0:默认全部人员，1：批量人员",
                "OrderNo": 20,
                "DisplayName": "发送人",
                "DataType": 2,
                "Nullable": true
              },
              {
                "ID": 34,
                "Name": "modularid",
                "Memo": "所属模块ID",
                "OrderNo": 21,
                "DisplayName": "所属模块ID",
                "DataType": 2,
                "Nullable": true,
                "GraphDesc": "P1=568.00,610.00\nP2=656.00,610.00\nP3=656.00,618.00\nP4=745.00,618.00\nHookP1=198.00,35.00\nHookP2=28.00,608.00\nMod_OP1=0\nMod_OP2=1\nMod_CP=0\nHorz1=1\nHorz2=1"
              },
              {
                "ID": 35,
                "Name": "releasemode",
                "Memo": "信息发布方式：1-编辑文本；2-文本识别",
                "OrderNo": 22,
                "DisplayName": "信息发布方式",
                "DataType": 2,
                "Nullable": true
              },
              {
                "ID": 36,
                "Name": "releasetype",
                "Memo": "发布方式：1，审核通过后立即发布，2定时发布，3手动发布",
                "OrderNo": 23,
                "DisplayName": "发布方式",
                "DataType": 2,
                "Nullable": true
              },
              {
                "ID": 37,
                "Name": "takeBack",
                "Memo": "收回人(用户ID)",
                "OrderNo": 24,
                "DisplayName": "收回人(用户ID)",
                "DataType": 2,
                "Nullable": true,
                "DataLength": 10
              },
              {
                "ID": 38,
                "Name": "takeBackTime",
                "Memo": "收回时间",
                "OrderNo": 25,
                "DisplayName": "收回时间",
                "DataType": 4,
                "Nullable": true,
                "DataLength": 19
              },
              {
                "ID": 39,
                "Name": "fixedTime",
                "Memo": "定时发布时间",
                "OrderNo": 26,
                "DisplayName": "定时发布时间",
                "DataType": 2,
                "Nullable": true,
                "DataLength": 20
              },
              {
                "ID": 109,
                "Name": "fmtpath",
                "CreateDate": "2019/12/12 15:41:45",
                "OrderNo": 27,
                "DisplayName": "封面路径",
                "DataType": 1,
                "Nullable": true
              },
              {
                "ID": 110,
                "Name": "filepath",
                "CreateDate": "2019/12/12 15:41:45",
                "OrderNo": 28,
                "DisplayName": "附件路径",
                "DataType": 1,
                "Nullable": true
              }
            ]
          }
        },
        {
          "ID": 10,
          "Name": "cms_is_read",
          "Caption": "已读消息表",
          "CreateDate": "2019/12/11 16:27:46",
          "OrderNo": 2,
          "GraphDesc": "Left=542.51\r\nTop=839.05",
          "MetaFields": {
            "Count": 5,
            "items": [
              {
                "ID": 1,
                "Name": "id",
                "CreateDate": "2019/12/11 16:27:46",
                "OrderNo": 1,
                "DisplayName": "编号",
                "DataType": 2,
                "KeyFieldType": 1
              },
              {
                "ID": 2,
                "Name": "mid",
                "CreateDate": "2019/12/11 16:27:46",
                "OrderNo": 2,
                "DisplayName": "消息id",
                "DataType": 2,
                "KeyFieldType": 3,
                "Nullable": true
              },
              {
                "ID": 3,
                "Name": "uid",
                "CreateDate": "2019/12/11 16:27:46",
                "OrderNo": 3,
                "DisplayName": "用户id",
                "DataType": 2,
                "KeyFieldType": 3,
                "Nullable": true
              },
              {
                "ID": 82,
                "Name": "read_time",
                "CreateDate": "2019/12/12 15:25:28",
                "OrderNo": 4,
                "DisplayName": "读取时间",
                "DataType": 4,
                "Nullable": true
              },
              {
                "ID": 115,
                "Name": "org_code",
                "CreateDate": "2019/12/12 16:04:55",
                "OrderNo": 5,
                "DisplayName": "公司id",
                "DataType": 2,
                "Nullable": true
              }
            ]
          }
        },
        {
          "ID": 13,
          "Name": "cms_announcement",
          "Caption": "轮播公告表",
          "CreateDate": "2019/12/11 15:10:06",
          "OrderNo": 3,
          "GraphDesc": "Left=535.78\r\nTop=959.81",
          "MetaFields": {
            "Count": 5,
            "items": [
              {
                "ID": 1,
                "Name": "id",
                "CreateDate": "2019/12/11 15:10:06",
                "OrderNo": 1,
                "DisplayName": "编号",
                "DataType": 2,
                "KeyFieldType": 1
              },
              {
                "ID": 5,
                "Name": "fbrid",
                "CreateDate": "2019/12/11 15:10:06",
                "OrderNo": 2,
                "DisplayName": "发布人id",
                "DataType": 2,
                "Nullable": true
              },
              {
                "ID": 9,
                "Name": "fbtime",
                "Memo": "默认为当前时间",
                "CreateDate": "2019/12/11 15:10:06",
                "OrderNo": 3,
                "DisplayName": "发布时间",
                "DataType": 4,
                "DefaultValue": "sysdate",
                "Nullable": true
              },
              {
                "ID": 11,
                "Name": "jstime",
                "CreateDate": "2019/12/11 15:10:06",
                "OrderNo": 4,
                "DisplayName": "结束时间",
                "DataType": 4,
                "Nullable": true
              },
              {
                "ID": 10,
                "Name": "fbnr",
                "CreateDate": "2019/12/11 15:10:06",
                "OrderNo": 5,
                "DisplayName": "发布内容",
                "DataType": 1,
                "Nullable": true
              }
            ]
          }
        },
        {
          "Name": "cms_content_modular",
          "Caption": "消息模块表-预留未使用",
          "Memo": "消息模块表",
          "OrderNo": 4,
          "GraphDesc": "Left=496.64\r\nTop=1076.47",
          "MetaFields": {
            "Count": 7,
            "items": [
              {
                "ID": 1,
                "Name": "id",
                "OrderNo": 1,
                "DisplayName": "主键",
                "DataType": 2,
                "KeyFieldType": 1,
                "DefaultValue": "{auto_increment}"
              },
              {
                "ID": 2,
                "Name": "modularname",
                "Memo": "模块名",
                "OrderNo": 2,
                "DisplayName": "模块名",
                "DataType": 1,
                "Nullable": true,
                "DataLength": 100
              },
              {
                "ID": 3,
                "Name": "organization_id",
                "Memo": "归属商户id",
                "OrderNo": 3,
                "DisplayName": "归属商户id",
                "DataType": 2,
                "Nullable": true
              },
              {
                "ID": 73,
                "Name": "mkicon",
                "CreateDate": "2019/12/18 9:33:33",
                "OrderNo": 4,
                "DisplayName": "模块图标",
                "DataType": 1,
                "Nullable": true
              },
              {
                "ID": 74,
                "Name": "mkpic",
                "CreateDate": "2019/12/18 9:33:51",
                "OrderNo": 5,
                "DisplayName": "模块图片",
                "DataType": 1,
                "Nullable": true
              },
              {
                "ID": 75,
                "Name": "modular_english",
                "CreateDate": "2019/12/18 9:34:05",
                "OrderNo": 6,
                "DisplayName": "模块英文",
                "DataType": 1,
                "Nullable": true
              },
              {
                "ID": 76,
                "Name": "is_open",
                "CreateDate": "2019/12/18 9:34:05",
                "OrderNo": 7,
                "DisplayName": "是否启用",
                "DataType": 2,
                "Nullable": true
              }
            ]
          }
        },
        {
          "ID": 14,
          "Name": "cms_contenttype",
          "Caption": "内容类型表",
          "CreateDate": "2019/12/18 9:35:42",
          "OrderNo": 5,
          "GraphDesc": "Left=538.49\r\nTop=772.80",
          "MetaFields": {
            "Count": 2,
            "items": [
              {
                "ID": 1,
                "Name": "Id",
                "CreateDate": "2019/12/18 9:35:42",
                "OrderNo": 1,
                "DisplayName": "编号",
                "DataType": 2,
                "KeyFieldType": 1,
                "Nullable": true
              },
              {
                "ID": 2,
                "Name": "name",
                "CreateDate": "2019/12/18 9:35:42",
                "OrderNo": 2,
                "DisplayName": "类型名称",
                "DataType": 1,
                "Nullable": true
              }
            ]
          }
        }
      ]
    }
  }]
}