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?