Product type parent table, its primary key is "product_parent_type_id", why not just use "id"? When writing SQL, it should be written like this: `product_parent_type`.`product_parent_type_id` Don’t you think this The place is really too long.
Is it better to call the primary key of the parent table of the product type product_category_id? Personally, I think that when the naming length is too long, you can try to see if there is an equally descriptive name (of course this requires accumulation and experience), but it really doesn’t work a little longer. Better than a short meaningless name.
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
Product type parent table, its primary key is "product_parent_type_id", why not just use "id"?
When writing SQL, it should be written like this:
`product_parent_type`.`product_parent_type_id`
Don’t you think this The place is really too long.
`product_parent_type`.`id`
How clear.
Is it better to call the primary key of the parent table of the product type
product_category_id? Personally, I think that when the naming length is too long, you can try to see if there is an equally descriptive name (of course this requires accumulation and experience), but it really doesn’t work a little longer. Better than a short meaningless name.