CREATE TABLE tbl_test_03 id INT 11 NOT NULL AUTO_INCREMENT principal_part VARCHAR 20 CHARACTER SET utf8mb4 NOT NULL COMMENT 主体用户账 号 principal_part_type TINYINT 2 NOT NULL COMMENT 主体类型1用户2运用默认为

This SQL code creates a table named "tbl_test_03" with the following columns:

• id: an auto-incremented integer that serves as the primary key
• principal_part: a string that represents the main entity (user account)
• principal_part_type: a tiny integer that indicates the type of the main entity (1 for user, 2 for application)
• resources: a string that represents the resource (role)
• resources_type: a tiny integer that indicates the type of the resource (1 for role, 2 for permission)
• space_code: a string that represents the space code (project code)
• note: a string that contains a description of the authorization
• status: a tiny integer that indicates whether the authorization is enabled or disabled (0 for disabled, 1 for enabled)
• gmt_create: a datetime value that represents the creation time of the authorization
• gmt_modified: a timestamp value that represents the last update time of the authorization

The table is using the InnoDB engine, has an initial auto-increment value of 48041, and uses the UTF-8 character set