OA系统数据字典 - 万千技术部文档中心

最后修改人	林旭
最后修改时间	2022-07-27 15:46:59
创建人	林旭
创建时间	2022-07-26 11:59:09

该文档由林旭创建于 2022-07-26 11:59:09 ，林旭在 2022-07-27 15:46:59 修改了该文档。

[TOCM]

```sql_create

CREATE TABLE `dtmoban_ad` (
  `aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '',
  `pid` int(10) unsigned NOT NULL DEFAULT '0',
  `typeid` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `areaid` int(10) unsigned NOT NULL DEFAULT '0',
  `amount` float NOT NULL DEFAULT '0',
  `currency` varchar(20) NOT NULL DEFAULT '',
  `url` varchar(255) NOT NULL DEFAULT '',
  `introduce` varchar(255) NOT NULL DEFAULT '',
  `hits` int(10) unsigned NOT NULL DEFAULT '0',
  `username` varchar(30) NOT NULL DEFAULT '',
  `addtime` int(10) unsigned NOT NULL DEFAULT '0',
  `editor` varchar(30) NOT NULL DEFAULT '',
  `edittime` int(10) unsigned NOT NULL DEFAULT '0',
  `fromtime` int(10) unsigned NOT NULL DEFAULT '0',
  `totime` int(10) unsigned NOT NULL DEFAULT '0',
  `stat` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `note` text NOT NULL,
  `code` text NOT NULL,
  `text_name` varchar(100) NOT NULL DEFAULT '',
  `text_url` varchar(255) NOT NULL DEFAULT '',
  `text_title` varchar(100) NOT NULL DEFAULT '',
  `text_style` varchar(50) NOT NULL DEFAULT '',
  `image_src` varchar(255) NOT NULL DEFAULT '',
  `image_url` varchar(255) NOT NULL DEFAULT '',
  `image_alt` varchar(100) NOT NULL DEFAULT '',
  `flash_src` varchar(255) NOT NULL DEFAULT '',
  `flash_url` varchar(255) NOT NULL DEFAULT '',
  `flash_loop` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `key_moduleid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `key_catid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `key_word` varchar(100) NOT NULL DEFAULT '',
  `key_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `listorder` smallint(4) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `people` mediumtext COMMENT '可以查看的人',
  `activity_id` varchar(20) DEFAULT '' COMMENT '小程序活动Id',
  PRIMARY KEY (`aid`),
  KEY `pid` (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED COMMENT='广告';

```
表名：**dtmoban_ad**   
备注：*=*

| 字段 | 类型 | 空 | 说明 | 
| --- | --- | --- | --- | 
| aid | int (10) | N |  | 
| title | varchar (100) | N |  | 
| pid | int (10) | N |  | 
| typeid | tinyint (1) | N |  | 
| areaid | int (10) | N |  | 
| amount | float | N |  | 
| currency | varchar (20) | N |  | 
| url | varchar (255) | N |  | 
| introduce | varchar (255) | N |  | 
| hits | int (10) | N |  | 
| username | varchar (30) | N |  | 
| addtime | int (10) | N |  | 
| editor | varchar (30) | N |  | 
| edittime | int (10) | N |  | 
| fromtime | int (10) | N |  | 
| totime | int (10) | N |  | 
| stat | tinyint (1) | N |  | 
| note | text | N |  | 
| code | text | N |  | 
| text_name | varchar (100) | N |  | 
| text_url | varchar (255) | N |  | 
| text_title | varchar (100) | N |  | 
| text_style | varchar (50) | N |  | 
| image_src | varchar (255) | N |  | 
| image_url | varchar (255) | N |  | 
| image_alt | varchar (100) | N |  | 
| flash_src | varchar (255) | N |  | 
| flash_url | varchar (255) | N |  | 
| flash_loop | tinyint (1) | N |  | 
| key_moduleid | smallint (6) | N |  | 
| key_catid | smallint (6) | N |  | 
| key_word | varchar (100) | N |  | 
| key_id | bigint (20) | N |  | 
| listorder | smallint (4) | N |  | 
| status | tinyint (1) | N |  | 
| people | mediumtext | Y | 可以查看的人 | 
| activity_id | varchar (20) | Y | 小程序活动Id |