In Siebel database naming conventions, foreign key columns reference the primary key of another table and are suffixed with _ID (for example, ACCNT_ID). Suffixes like _FK, _PK, or _UK are not the standard naming convention for foreign key columns in Siebel.