字段命名 - mysql 字段太长，如何简要字段规范？

Answer 1

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.

Answer 2

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.