is usually in the form of merge_user_role or mapping_user_role. Of course, user_role is also possible, but it is easy to be confused with other tables. As for whether to use plural numbers, it mainly depends on the design of other tables. If your users table is plural, you can probably use plural numbers here, but generally table names do not appear in plural form, so there is no need to use plural numbers here.
There is no regulation, but it is recommended to use the odd number, because if the negative number takes up 2 more characters, the maximum length of the identifier in ORACLE is 30. In some cases, using the plural number will exceed the limit
The naming convention only needs to be unified. If a single table name uses a plural number, it is also recommended to use a plural number in the name of the table relationship.
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
is usually in the form of
merge_user_roleormapping_user_role. Of course,user_roleis also possible, but it is easy to be confused with other tables. As for whether to use plural numbers, it mainly depends on the design of other tables. If youruserstable is plural, you can probably use plural numbers here, but generally table names do not appear in plural form, so there is no need to use plural numbers here.There is no need to worry about whether it is singular or plural, just keep the style consistent
There is no regulation, but it is recommended to use the odd number, because if the negative number takes up 2 more characters, the maximum length of the identifier in ORACLE is 30. In some cases, using the plural number will exceed the limit
The naming convention only needs to be unified. If a single table name uses a plural number, it is also recommended to use a plural number in the name of the table relationship.