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
1
spam@yopmail.com
Known spam email address
2
IP Address
124.4.4.2
Malicious IP address
3
Domain
example.com
Blacklisted domain
Last updated