Language

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

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

Table Structure:
- `[ID]`: bigint, `auto-incrementing primary key`
- `[Country_Code]`: varchar(2), `not null`
- `[Language_Code]`: varchar(15), `not null`
- `[Description]`: nvarchar(250), `nullable`
- `[Modified_By]`: bigint, `nullable`
- `[Modified_Date]`: datetime, `not null`
- `[Created_By]`: bigint, `nullable`
- `[Created_Date]`: datetime, `not null`

Constraints:
- Primary Key: `[ID]`
- Default Constraint: `[Modified_Date]` (set to current UTC date and time)
- Default Constraint: `[Created_Date]` (set to current UTC date and time)

Last updated

Was this helpful?