add database columns for completion and appearance