Authentication type differences in SQL Server
instance means this is a sql login, while windows means this is Windows login, and none means it does not need authentication (such as database role).

BTW, the two columns are in sys.database_principals