State

This script creates a table named [JFW].[State] in the [JFW_live] database. The table has the following columns:

• [ID]: bigint, auto-incrementing primary key

• [Country_Code]: varchar(2), not null

• [Code]: varchar(5), not null

• [Name]: nvarchar(200), not null

• [State_Type]: nvarchar(max), nullable

• [Modified_By]: bigint, nullable

• [Modified_Date]: datetime, not null

• [Created_By]: bigint, nullable

• [Created_Date]: datetime, not null

The table also has the following constraints:

• [PK_State]: primary key constraint on the [ID] column

• [DF_State_ModifiedDate]: default constraint to set [Modified_Date] to the current UTC date and time

• [DF_State_CreatedDate]: default constraint to set [Created_Date] to the current UTC date and time

This table is used to store information about states, including their codes, names, and other details.