表单安装 安装后可存放1000万+条数据
表字段预览 除系统字段外，okayapi_access数据库表 共有 11 个表字段
Displaying 1-11 of 11 results.
| 字段名称 | 字段类型 | 字段默认值 | 是否允许为空 | 字段描述 | 索引 | 字段数据示例 |
|---|---|---|---|---|---|---|
| debug | tinyint(2) | 0 | 否 | 是否为调试表，只允许在开发环境使用，测试和线上环境禁用 | 0 | |
| name | varchar(50) | 否 | 实际表名，例如 apijson_user | Unique Index | ||
| alias | varchar(20) | 是 | 外部调用的表别名，例如 User | Unique Index | ||
| get | varchar(100) | ["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"] | 否 | 允许 get 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"] 用 JSON 类型不能设置默认值，反正权限对应的需求是明确的，也不需要自动转 JSONArray。 TODO: 直接 LOGIN,CONTACT,CIRCLE,OWNER 更简单，反正是开发内部用，不需要复杂查询。 | ["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"] | |
| head | varchar(100) | ["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"] | 否 | 允许 head 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"] | ["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"] | |
| gets | varchar(100) | ["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"] | 否 | 允许 gets 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"] | ["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"] | |
| heads | varchar(100) | ["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"] | 否 | 允许 heads 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"] | ["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"] | |
| post | varchar(100) | ["OWNER", "ADMIN"] | 否 | 允许 post 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"] | ["OWNER", "ADMIN"] | |
| put | varchar(100) | ["OWNER", "ADMIN"] | 否 | 允许 put 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"] | ["OWNER", "ADMIN"] | |
| delete | varchar(100) | ["OWNER", "ADMIN"] | 否 | 允许 delete 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"] | ["OWNER", "ADMIN"] | |
| date | timestamp | CURRENT_TIMESTAMP | 否 | 创建时间 | CURRENT_TIMESTAMP |
