BlackList

The Blacklist table is used to store a list of blacklisted items. It includes columns for the type of item being blacklisted, the value of the blacklisted item, and a description of the blacklisted item. The table also tracks the user who created or last modified the blacklist record, along with the corresponding date and time.

Table Structure

• [ID] (bigint, auto-incrementing, primary key): Represents the unique identifier for each blacklist record.

• [Block_Type] (varchar(150), not null): Represents the type of item being blacklisted.

• [Value] (nvarchar(255), not null): Represents the value of the blacklisted item.

• [Description] (nvarchar(max), nullable): Represents a description of the blacklisted item.

• [Modified_By] (bigint, nullable): Represents the user who last modified the blacklist record.

• [Modified_Date] (datetime, not null): Represents the date and time when the blacklist record was last modified.

• [Created_By] (bigint, nullable): Represents the user who created the blacklist record.

• [Created_Date] (datetime, not null): Represents the date and time when the blacklist record was created.

Constraints

• [PK_BlackList]: primary key constraint on the [ID] column.

• [DF_BlackList_ModifiedDate]: default constraint on the [Modified_Date] column, default value is the current UTC date and time.

• [DF_BlackList_CreatedDate]: default constraint on the [Created_Date] column, default value is the current UTC date and time.

Example Data

ID	Block_Type	Value	Description
1	Email	[e-mail]	Known spam email address
2	IP Address	124.4.4.2	Malicious IP address
3	Domain	example.com	Blacklisted domain