Try SQLinkr Contact Us

My Schema

{
"tables":[
    {"table_name":"ITEM_STORE_DATE_SALES", "schema": ["ITEM_ID", "STORE_ID", "DATE", "SALES_AMOUNT"]},
    {"table_name":"ITEM_STORE_DATE_INVENTORY", "schema": ["ITEM_ID", "STORE_ID", "DATE", "INVENTORY_AMOUNT"]},
    {"table_name":"ITEM_COST", "schema": ["ITEM_ID", "COST_AMOUNT", "COST_TIER_ID"]},
    {"table_name":"COST_TIER_HIERARCHY", "schema": ["COST_TIER_ID", "COST_TIER_DESCRIPTION"]},
    {"table_name":"PRODUCT_HIERARCHY", "schema": ["ITEM_ID", "ITEM_DESCRIPTION", "PRODUCT_STATUS_ID", "SUB_CATEGORY_ID"]},
    {"table_name":"PRODUCT_STATUS_HIERARCHY", "schema": ["PRODUCT_STATUS_ID", "PRODUCT_STATUS_DESCRIPTION"]},
    {"table_name":"SUB_CATEGORY_HIERARCHY", "schema": ["SUB_CATEGORY_ID", "SUB_CATEGORY_DESCRIPTION", "CATEGORY_ID"]},
    {"table_name":"CATEGORY_HIERARCHY", "schema": ["CATEGORY_ID", "CATEGORY_DESCRIPTION"]},
    {"table_name":"LOCATION_HIERARCHY", "schema": ["STORE_ID", "STORE_DESCRIPTION", "LOCATION_STATUS_ID", "SUB_REGION_ID"]},
    {"table_name":"LOCATION_STATUS_HIERARCHY", "schema": ["LOCATION_STATUS_ID", "LOCATION_STATUS_DESCRIPTION"]},
    {"table_name":"SUB_REGION_HIERARCHY", "schema": ["SUB_REGION_ID", "SUB_REGION_DESCRIPTION", "REGION_ID"]},
    {"table_name":"REGION_HIERARCHY", "schema": ["REGION_ID", "REGION_DESCRIPTION"]},
    {"table_name":"EMPLOYEE_HIERARCHY", "schema": ["EMPLOYEE_ID", "EMPLOYEE_DESCRIPTION"]}
]
}
{
"tables":[
    {"table_name":"ITEM_STORE_DATE_SALES", "schema": ["ITEM_ID", "STORE_ID", "DATE", "SALES_AMOUNT"]},
    {"table_name":"ITEM_STORE_DATE_INVENTORY", "schema": ["ITEM_ID", "STORE_ID", "DATE", "INVENTORY_AMOUNT"]},
    {"table_name":"ITEM_COST", "schema": ["ITEM_ID", "COST_AMOUNT", "COST_TIER_ID"]},
    {"table_name":"COST_TIER_HIERARCHY", "schema": ["COST_TIER_ID", "COST_TIER_DESCRIPTION"]},
    {"table_name":"PRODUCT_HIERARCHY", "schema": ["ITEM_ID", "ITEM_DESCRIPTION", "PRODUCT_STATUS_ID", "SUB_CATEGORY_ID"]},
    {"table_name":"PRODUCT_STATUS_HIERARCHY", "schema": ["PRODUCT_STATUS_ID", "PRODUCT_STATUS_DESCRIPTION"]},
    {"table_name":"SUB_CATEGORY_HIERARCHY", "schema": ["SUB_CATEGORY_ID", "SUB_CATEGORY_DESCRIPTION", "CATEGORY_ID"]},
    {"table_name":"CATEGORY_HIERARCHY", "schema": ["CATEGORY_ID", "CATEGORY_DESCRIPTION"]},
    {"table_name":"LOCATION_HIERARCHY", "schema": ["STORE_ID", "STORE_DESCRIPTION", "LOCATION_STATUS_ID", "SUB_REGION_ID"]},
    {"table_name":"LOCATION_STATUS_HIERARCHY", "schema": ["LOCATION_STATUS_ID", "LOCATION_STATUS_DESCRIPTION"]},
    {"table_name":"SUB_REGION_HIERARCHY", "schema": ["SUB_REGION_ID", "SUB_REGION_DESCRIPTION", "REGION_ID"]},
    {"table_name":"REGION_HIERARCHY", "schema": ["REGION_ID", "REGION_DESCRIPTION"]},
    {"table_name":"EMPLOYEE_HIERARCHY", "schema": ["EMPLOYEE_ID", "EMPLOYEE_DESCRIPTION"]}
]
}