Country

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

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

• [Region]: nvarchar(50), nullable

• [Subregion]: nvarchar(50), nullable

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

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

• [ISO3]: varchar(3), not null

• [Numeric_Code]: smallint, not null

• [Phone_Code]: nvarchar(50), not null

• [Capital]: nvarchar(50), nullable

• [Currency]: varchar(3), not null

• [Tld]: nvarchar(50), not null

• [Native]: nvarchar(100), nullable

• [Modified_By]: bigint, nullable

• [Modified_Date]: datetime, not null

• [Created_By]: bigint, nullable

• [Created_Date]: datetime, not null

The table has the following constraints:

• Primary Key: [ID], [ISO3166]

• Default Constraint: [DF_Country_ModifiedDate] (getutcdate()) for [Modified_Date]

• Default Constraint: [DF_Country_CreatedDate] (getutcdate()) for [Created_Date]