将列结构设置成这样...

Set the column structure as such...

• invoice_id == 自动递增
• invoice_year == YEAR(NOW())
• invoice_customer_id == customer_id 来自客户表
• 等等...

...然后在视图中向最终用户显示一个串联的 id (2011-1-1234).

...and then display to the end users a concatenated id (2011-1-1234) in the view.

看来您确实需要根据输出来组织架构.

It really seems like you need to organize the schema based on your output.