.. role:: strike
    :class: strike

:strike:`projects 项目表`
==============================

字段
-------------

+--------------+----------------+----------+--------+------------------------------------+
| 列名         | 类型           | 是否非空 | 默认值 | 备注                               |
+--------------+----------------+----------+--------+------------------------------------+
| id           | big increament | not null | null   | 自增ID                             |
+--------------+----------------+----------+--------+------------------------------------+
| displayname  | string         | not null | null   | 项目显示名称，用于前端显示         |
+--------------+----------------+----------+--------+------------------------------------+
| name         | string         | not null | null   | 项目名称，用于后端查询和数据库创建 |
+--------------+----------------+----------+--------+------------------------------------+
| creator_id   | bigint         | not null | null   | 用户id                             |
+--------------+----------------+----------+--------+------------------------------------+
| comment      | string         | not null | null   | 项目描述                           |
+--------------+----------------+----------+--------+------------------------------------+
| creator_time | DATETIME       | not null | null   | 项目创建时间                       |
+--------------+----------------+----------+--------+------------------------------------+
| status       | short          | not null | 0      | 状态。 0-正常，1-停用              |
+--------------+----------------+----------+--------+------------------------------------+


## 索引

+------+----------+------+
| 字段 | 唯一索引 | 备注 |
+------+----------+------+
| 无   |          |      |
+------+----------+------+


## 说明


## 建表语句

.. code::

    create table projects(
        id int primary key auto increment comment '唯一键',
        displayname varchar(100) not null comment '项目别名',
        name varchar(20) comment not null '项目名称',
        creator_id int comment not null '用户id',
        comment varchar(300) not null comment '项目描述',
        creator_time datetime not null comment '项目创建时间',
        status smallint not null comment '状态'
    );