Foreign key twice in same table for different columns in SQL server 2019

Question

how can i create fk relation with user in order table with these columns

AcceptedBy

RejectedBy

Answer 1

As Olaf suggests, it's straightforward:

CREATE TABLE users (id int NOT NULL,
                    username nvarchar(100) NOT NULL,
                    role     nvarchar(100) NULL,
                    CONSTRAINT pk_users PRIMARY KEY (id)
)

CREATE TABLE orders (ordernumber int NOT NULL,
                    AcceptedBy   int  NULL,
                    RejectedBy   int  NULL,
                    CONSTRAINT pk_orders PRIMARY KEY (ordernumber),
                    CONSTRAINT fk_orders_users_AccepteBy 
                        FOREIGN KEY (AcceptedBy) REFERENCES users(id),
                    CONSTRAINT fk_orders_users_RejecteddBy 
                        FOREIGN KEY (RejectedBy) REFERENCES users(id)
)
go
DROP TABLE orders, users

Answer 2

Sure you can, why not?