Skip to content

Instantly share code, notes, and snippets.

@potatoqualitee

potatoqualitee/sql2014.AdventureWorks2014.tables.json

Last active December 21, 2018 10:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save potatoqualitee/f01e88cbddaa16191d5e8cdc835edb56 to your computer and use it in GitHub Desktop.
Save potatoqualitee/f01e88cbddaa16191d5e8cdc835edb56 to your computer and use it in GitHub Desktop.
Download ZIP
Modified New-DbaDbMaskingConfig output
Raw
sql2014.AdventureWorks2014.tables.json
{
"Name": "AdventureWorks2014",
"Tables": [
{
"Name": "Employee",
"Schema": "HumanResources",
"Columns": [
{
"Name": "NationalIDNumber",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 2147483647,
"MaskingType": "Random",
"SubType": "Number",
"Deterministic": false,
"Nullable": false
},
{
"Name": "LoginID",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 256,
"MaskingType": "Internet",
"SubType": "UserName",
"Deterministic": false,
"Nullable": false
},
{
"Name": "JobTitle",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 50,
"MaskingType": "Name",
"SubType": "JobType",
"Deterministic": false,
"Nullable": false
},
{
"Name": "BirthDate",
"ColumnType": "date",
"CharacterString": null,
"MinValue": "1/1/1970",
"MaxValue": "1/1/1990",
"MaskingType": "Random",
"SubType": "Date",
"Deterministic": false,
"Nullable": false
},
{
"Name": "MaritalStatus",
"ColumnType": "nchar",
"CharacterString": "SM",
"MinValue": null,
"MaxValue": 1,
"MaskingType": "Random",
"SubType": "String",
"Deterministic": false,
"Nullable": false
},
{
"Name": "Gender",
"ColumnType": "nchar",
"CharacterString": "MF",
"MinValue": null,
"MaxValue": 1,
"MaskingType": "Random",
"SubType": "String",
"Deterministic": false,
"Nullable": false
},
{
"Name": "SalariedFlag",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 1,
"MaskingType": "Random",
"SubType": "Bool",
"Deterministic": false,
"Nullable": false
},
{
"Name": "VacationHours",
"ColumnType": "smallint",
"CharacterString": null,
"MinValue": -40,
"MaxValue": 200,
"MaskingType": "Random",
"SubType": "Number",
"Deterministic": false,
"Nullable": false
},
{
"Name": "SickLeaveHours",
"ColumnType": "smallint",
"CharacterString": null,
"MinValue": 0,
"MaxValue": 120,
"MaskingType": "Random",
"SubType": "Number",
"Deterministic": false,
"Nullable": false
},
{
"Name": "CurrentFlag",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 1,
"MaskingType": "Random",
"SubType": "Bool",
"Deterministic": false,
"Nullable": false
},
{
"Name": "rowguid",
"ColumnType": "uniqueidentifier",
"CharacterString": null,
"MinValue": null,
"MaxValue": 16,
"MaskingType": "Random",
"SubType": "String",
"Deterministic": false,
"Nullable": false
}
]
},
{
"Name": "EmployeeDepartmentHistory",
"Schema": "HumanResources",
"Columns": [
{
"Name": "StartDate",
"ColumnType": "date",
"CharacterString": null,
"MinValue": null,
"MaxValue": "1/1/2018",
"MaskingType": "Random",
"SubType": "Date",
"Deterministic": false,
"Nullable": false
},
{
"Name": "EndDate",
"ColumnType": "date",
"CharacterString": null,
"MinValue": "1/2/2018",
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date",
"Deterministic": false,
"Nullable": true
}
]
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment