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.

MySQL Table 'tbl_test_03' Schema Definition

原文地址: https://www.cveoy.top/t/topic/oijc 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录