Specifies how column names are qualified to ensure uniqueness in the generated schema.

Possible Values

データ型

string

デフォルト値

"None"

解説

By default, the 本製品 qualifies column names only as much as necessary to make them unique. For example, given the following JSON document, the 本製品 produces the columns id (referring to the company id) and employee.id.

{
  "company": [
    {
      "id": "Smith Holdings", 
      "employee": [
        {"id": "George Smith"},
        {"id": "Mike Johnson"}
      ]
    }
  ]
}

When this option is set to Parent, the 本製品 uses a similar procedure to the one above. However, the 本製品 always qualifies columns by one level so that each includes its parent table name, even when the name is already unique. For example, the above document would generate the columns company.id and employee.id because both are unique when including their parent.

When this option is set to Full, the 本製品 qualifies all column names with their full JSON path, ensuring clarity about each column’s origin. This generates longer column names, but ensures that it is clear where each column name comes from within the document. For the example above, the 本製品 generates the columns json.company.id and json.company.employee.id.