Currency

FILEPATH: /d:/Projects/1bytesoftware/sql/table-scripts/JFW.Currency.Table.sql

Description:
This script creates a table named `[JFW]`.[Currency] in the `[JFW_live]` database. The table stores information about different currencies.

Table Structure:
- `[ID]`: bigint, identity column, unique identifier for each currency.
- `[Name]`: varchar(20), the name of the currency.
- `[Code]`: varchar(5), the code of the currency.
- `[Symbol]`: varchar(5), the symbol of the currency.
- `[Is_Default]`: bit, indicates whether the currency is the default currency.
- `[Modified_By]`: bigint, the ID of the user who last modified the currency.
- `[Modified_Date]`: datetime, the date and time when the currency was last modified.
- `[Created_By]`: bigint, the ID of the user who created the currency.
- `[Created_Date]`: datetime, the date and time when the currency was created.

Constraints:
- `[PK_Currency]`: Primary key constraint on `[ID]` column.
- `[UK_Currency_Code]`: Unique constraint on `[Code]` column.

Default Values:
- `[Is_Default]`: Default value is 0 (false).
- `[Modified_Date]`: Default value is the current UTC date and time.
- `[Created_Date]`: Default value is the current UTC date and time.