.. role:: strike
    :class: strike

:strike:`workspaces 工作区表`
====================================

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

+------------+--------------+----------+-----------------+------------+
| 列名       | 类型         | 是否非空 | 默认值          | 备注       |
+------------+--------------+----------+-----------------+------------+
| id         | int          | not null | null            | 自增ID     |
+------------+--------------+----------+-----------------+------------+
| name       | varchar(30)  | not null | ""              | 工作区名称 |
+------------+--------------+----------+-----------------+------------+
| desc       | varchar(300) | not null | ""              | 工作区描述 |
+------------+--------------+----------+-----------------+------------+
| creator_id | int          | not null | null            | 创建用户id |
+------------+--------------+----------+-----------------+------------+
| createtime | datetime     | nullable | CurrentDateTime | 创建时间   |
+------------+--------------+----------+-----------------+------------+
| updatetime | datetime     | nullable | CurrentDateTime | 更新时间   |
+------------+--------------+----------+-----------------+------------+
| deletetime | datetime     | nullable | CurrentDateTime | 删除时间   |
+------------+--------------+----------+-----------------+------------+

索引
---------------------------

+------+----------+----------+----------------------------------------+
| 字段 | 是否唯一 | 索引方法 | 备注                                   |
+------+----------+----------+----------------------------------------+
| name | True     | BTree    | 工作区名称建唯一索引，会利用该字段查询 |
+------+----------+----------+----------------------------------------+

说明
---------------------------


建表语句
---------------------------

.. code::

    create table workspaces(
        id int primary key auto_increment comment '唯一键',
        name varchar(30) not null comment '工作区名称',
        desc varchar(300) not null comment '工作区描述'，
        creator_id int comment not null '用户id',
        createtime datetime comment '创建时间'，
        updatetime datetime comment '更新时间'，
        deletetime datetime comment '删除时间'，
    );