boluor commented on issue #3213: URL: https://github.com/apache/doris-website/issues/3213#issuecomment-4525904340
Fair feedback on the example. The doc shows \`UNIQUE KEY(user_id, user_name)\` to illustrate that the Unique Key model treats the whole key tuple as the primary identifier — not because \`user_id\` alone wouldn't suffice, but to demonstrate the multi-column key syntax. In practice you're right that production tables usually pick a single id column. A clearer note here would be: "Unique Key may be a single column or a column tuple; rows are unique on the whole key. Choose the minimal set of columns that uniquely identifies a row." Will think about wording in a follow-up edit. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
