当前位置:网站首页>Metadata management - the complete implementation of dynamic form designer in crudapi system
Metadata management - the complete implementation of dynamic form designer in crudapi system
2021-03-01 10:21:43 【crudapi】
Form design
In the previous article , We introduce some basic functions of form design through a series of cases , Form design plays a very important role , It's also crudapi The core , So this article will introduce some other functions in form design in detail .
Summary
form field column attribute
List English names | describe |
---|---|
name | English name |
caption | Chinese name |
autoIncrement | Is it self growth |
description | describe |
displayOrder | Serial number ,UI The order shown in |
dataType | data type , Like strings 、 Integers, etc |
seqId | Serial number ID, Used to set the serial number |
indexName | The index name |
indexStorage | Index storage , Support BTREE、HASH |
indexType | Index type , Support PRIMARY, UNIQUE, INDEX, FULLTEXT |
length | length |
precision | Precision 、 accurate ( precision ), Represents the number of significant digits in the field |
scale | scale 、 Range of values , Represents the number of decimal places in the field |
nullable | Can it be empty |
unsigned | Whether there is no sign |
insertable | Is it possible to insert |
queryable | Whether it can be queried |
systemable | Whether the system field |
updatable | Modifiable or not |
createdDate | Creation time |
lastModifiedDate | Modification time |
Not all of the above attributes are valid at the same time , such as unsigned Only in dataType It works when it's a number , It is ignored when it is a string , Other situations are similar .
System fields
When you create a form, it will be added by default 5 A system field , They are numbers id, name name, Full-text index fullTextBody, Creation time createdDate And modification time lastModifiedDate, With customer For example , System fields json The contents are as follows :
[{
"autoIncrement": true,
"caption": " Number ",
"createdDate": 1613181300985,
"dataType": "BIGINT",
"description": " Primary key ",
"displayOrder": 0,
"id": 253,
"indexType": "PRIMARY",
"insertable": false,
"lastModifiedDate": 1613182114133,
"length": 20,
"name": "id",
"nullable": false,
"queryable": false,
"systemable": true,
"unsigned": true,
"updatable": false
}, {
"autoIncrement": false,
"caption": " name ",
"createdDate": 1613181300985,
"dataType": "VARCHAR",
"description": " name ",
"displayOrder": 1,
"id": 254,
"insertable": true,
"lastModifiedDate": 1613182114133,
"length": 200,
"name": "name",
"nullable": false,
"queryable": true,
"systemable": true,
"unsigned": false,
"updatable": true
}, {
"autoIncrement": false,
"caption": " Full-text index ",
"createdDate": 1613181300985,
"dataType": "TEXT",
"description": " Full-text index ",
"displayOrder": 2,
"id": 255,
"indexName": "ft_fulltext_body",
"indexType": "FULLTEXT",
"insertable": false,
"lastModifiedDate": 1613182114133,
"name": "fullTextBody",
"nullable": true,
"queryable": false,
"systemable": true,
"unsigned": false,
"updatable": false
}, {
"autoIncrement": false,
"caption": " Creation time ",
"createdDate": 1613181300985,
"dataType": "DATETIME",
"description": " Creation time ",
"displayOrder": 3,
"id": 256,
"insertable": false,
"lastModifiedDate": 1613182114133,
"name": "createdDate",
"nullable": false,
"queryable": false,
"systemable": true,
"unsigned": false,
"updatable": false
}]
Uniqueness index
Index types include primary keys 、 The full text 、 Ordinary 、 only , Full text indexing has been introduced before , Ordinary index is mainly to improve query efficiency , Here we mainly introduce the unique index Customer list mobile Create unique index of mobile field , Mobile phone number cannot be repeated
When you add a customer , Enter and add the existing mobile phone number , Prompt for duplicate errors , Consistent with expectations , Unique index can prevent data duplication .
Joint index
If the index has only one field , When setting column properties, directly set . If it's a joint index of multiple fields , It needs to be set up separately . Here you can create two types of common or unique union indexes , Select multiple fields from the drop-down box . Such as to customer Set up a union index , The final index function is similar to the previous single field index .
The attachment
The attachment type field supports saving attachments , Mainly documents 、 Pictures, etc
Settings file file Tabular url The link field property is ATTACHMENT
When entering data , The attachment field can upload files , If it's a picture, you can preview it .
Form design API
Form design provides API, If the background management provided by default UI Not suitable for , It can be redeveloped , The redesign UI, adopt API Manage forms ,API The documents are as follows :
https://demo.crudapi.cn/swagger-ui.html
Postman Inquire about customer Table cell data .
Summary
This paper introduces the complete function of form design , Either through UI Configuration to realize , It can also be done through API Secondary development .
attach demo demonstration
This system belongs to the product level zero code platform , Unlike automatic code generators , You don't have to generate Controller、Service、Repository、Entity And so on , The program can be used as soon as it runs , real 0 Code , It can cover basic business independent CRUD RESTful API.
Official website address :https://crudapi.cn
Address of the test :https://demo.crudapi.cn/crudapi/login
版权声明
本文为[crudapi]所创,转载请带上原文链接,感谢
https://chowdera.com/2021/03/20210301102004584m.html
边栏推荐
- 寻找性能更优秀的不可变小字典
- Introduction to common tuning tools for JVM
- Uni app learning record -- 1. Uni app basic grammar
- Summary and analysis of the list of top 50 bloggers of 1024 activities in 2020, please call for your favorite bloggers! (integration of selected articles)
- 彻底摆脱乱码的困惑
- 网络变压器 10G base-T 1000base-T 对比
- prometheus-net.DotNetRuntime 获取 CLR 指标原理解析
- Alertmanager 报警模板
- Hello!OA!Hello!工作流!寻找OA和工作流的旅途记录
- 如何配置Fabric出块参数来达到“最大”TPS
猜你喜欢
-
Data collection mechanism and strategy in business scenarios
-
企业级数据中心推演
-
实战爬取腾讯地图上的收费站、服务区、厕所等数据
-
js隐式类型转换
-
Flutter 按钮Button多样式练习
-
Once centos7. X is installed, Zeppelin v0.9.0 is deployed, and PostgreSQL database is configured
-
MongoDB 基础手册(一)
-
Simple use of struct module
-
CCFCSP历年认证考试真题解答汇总(已解决6道,持续更新ing)
-
2021 年国产数据库名录和产品信息一览
随机推荐
- Bpmn.js 中文文档(一)
- Open source of table component based on efcore
- JVM tuning parameters, methods, tools and case summary
- JVM tuning parameters, methods, tools and case summary
- Ytu-cst winter training base camp
- 微信小程序--wx.showModal
- WPF foundation - x namespace
- Concept of tcapsusdb knowledge base (table, key, record, index)
- Maxkey single sign on authentication system v2.6.0ga released
- 数据库隔离级别
- Metadata management - the complete implementation of dynamic form designer in crudapi system
- SQL排名问题,100% leetcode答案大公开!
- 2020 top 50 blogger list summary analysis, please call for your favorite bloggers! (integration of selected articles)
- Metadata management - the complete implementation of dynamic form designer in crudapi system
- Metadata management - the complete implementation of dynamic form designer in crudapi system
- Row cache lock for waiting events
- Should embedded engineers learn arm assembly instructions or not? Summary of arm learning articles
- Row cache lock for waiting events
- Collation of common commands of JVM
- Why do you call this a sentinel?
- Alibaba cloud Internet of things.net core client| CZGL.AliIoTClient : 2. IOT client
- Introduction of common tuning tools for JVM
- BB network layer test
- SQLite under firedac [4] - creating database
- Chapter 15 device independent bitmap_ 15.3 combination of DIB and DDB
- Team work 8 -- the second project Sprint (beta stage) Day1 -- 5.18
- Window Pains
- ==Compare with equals
- 计算属性
- Using seed table to generate serial number in SQL Server
- PHP large file upload plug-in (above 500m)
- Detailed explanation of official document editor of open source OA: official document format and basic use