schema.yaml

---
databases:
- database: "experiments"
  dialect: "vertica"
  namespace: "public"
  tables:
  - table: "part"
    isPublic: true
    columns:
    - name: "P_PARTKEY"
      maxFreq: 1
    - name: "P_NAME"
    - name: "P_MFGR"
    - name: "P_BRAND"
    - name: "P_TYPE"
    - name: "P_SIZE"
    - name: "P_CONTAINER"
    - name: "P_RETAILPRICE"
    - name: "P_COMMENT"
  - table: "supplier"
    isPublic: false
    columns:
    - name: "S_SUPPKEY"
      maxFreq: 1
    - name: "S_NAME"
    - name: "S_ADDRESS"
    - name: "S_NATIONKEY"
      maxFreq: 438
    - name: "S_PHONE"
    - name: "S_ACCTBAL"
    - name: "S_COMMENT"
  - table: "partsupp"
    isPublic: false
    columns:
    - name: "PS_PARTKEY"
      maxFreq: 4
    - name: "PS_SUPPKEY"
      maxFreq: 80
    - name: "PS_AVAILQTY"
    - name: "PS_SUPPLYCOST"
    - name: "PS_COMMENT"
  - table: "customer"
    isPublic: false
    columns:
    - name: "C_CUSTKEY"
      maxFreq: 1
    - name: "C_NAME"
    - name: "C_ADDRESS"
    - name: "C_NATIONKEY"
    - name: "C_PHONE"
    - name: "C_ACCTBAL"
    - name: "C_MKTSEGMENT"
    - name: "C_COMMENT"
  - table: "orders"
    isPublic: false
    columns:
    - name: "O_ORDERKEY"
      maxFreq: 1
    - name: "O_CUSTKEY"
      maxFreq: 41
    - name: "O_ORDERSTATUS"
    - name: "O_TOTALPRICE"
    - name: "O_ORDERDATE"
    - name: "O_ORDERPRIORITY"
    - name: "O_CLERK"
    - name: "O_SHIPPRIORITY"
    - name: "O_COMMENT"
  - table: "lineitem"
    isPublic: false
    columns:
    - name: "L_ORDERKEY"
      maxFreq: 7
    - name: "L_PARTKEY"
    - name: "L_SUPPKEY"
      maxFreq: 694
    - name: "L_LINENUMBER"
    - name: "L_QUANTITY"
    - name: "L_EXTENDEDPRICE"
    - name: "L_DISCOUNT"
    - name: "L_TAX"
    - name: "L_RETURNFLAG"
    - name: "L_LINESTATUS"
    - name: "L_SHIPDATE"
    - name: "L_COMMITDATE"
    - name: "L_RECEIPTDATE"
    - name: "L_SHIPINSTRUCT"
    - name: "L_SHIPMODE"
    - name: "L_COMMENT"
  - table: "nation"
    isPublic: true
    columns:
    - name: "N_NATIONKEY"
      maxFreq: 1
    - name: "N_NAME"
    - name: "N_REGIONKEY"
    - name: "N_COMMENT"
  - table: "region"
    isPublic: true
    columns:
    - name: "R_REGIONKEY"
      maxFreq: 1
    - name: "R_NAME"
    - name: "R_COMMENT"