问从SQLite移植到PostgreSQL:在PostgreSQL 14.5 SQL脚本中，.NET 6中的数据类型byte[]和DateTime是什么？

EN

namespace AuthenticationWebApi.Models

{
    public class User
    {
        public int Id { get; set; }
        public string Username { get; set; } = string.Empty;
        public byte[] PasswordHash { get; set; } = new byte[32]; // <-- In don't know how to choose according datatype in PostgreSQL' DDL script.
        public byte[] PasswordSalt { get; set; } = new byte[32]; // <-- In don't know how to choose according datatype in PostgreSQL' DDL script.
        public string RefreshToken { get; set; } = string.Empty;
        public DateTime TokenCreated { get; set; } // <-- In don't know how to choose according datatype in PostgreSQL' DDL script.
        public DateTime TokenExpires { get; set; } // <-- In don't know how to choose according datatype in PostgreSQL' DDL script.
        public string Role { get; set; } = string.Empty;
    }
}

CREATE TABLE public."my_user"
(
    id integer,
    username character varying(32),
    password_hash character varying(32), // <-- Incorrect mapping.
    password_salt character varying(32), // <-- Incorrect mapping.
    refresh_token character varying(32),
    token_created time with time zone, // <-- Incorrect mapping.
    token_expires time with time zone, // <-- Incorrect mapping.
    role text
);

ALTER TABLE IF EXISTS public."my_user"
    OWNER to postgres;