root -> (REGION *, PART *)
@root -> ()
primKeys (root) = ()
REGION -> (R_REGIONKEY, R_NAME ?, R_COMMENT ?, NATION *)
@REGION -> ()
primKeys (REGION) = (R_REGIONKEY)
PART -> (P_PARTKEY, P_NAME ?, P_MFGR ?, P_BRAND ?, P_TYPE ?, P_SIZE ?, P_CONTAINER ?, P_RETAILPRICE ?, P_COMMENT ?, PARTSUPP *)
@PART -> ()
primKeys (PART) = (P_PARTKEY)
NATION -> (N_NATIONKEY, N_NAME ?, N_COMMENT ?, CUSTOMER *, SUPPLIER *)
@NATION -> ()
primKeys (NATION) = (N_NATIONKEY)
CUSTOMER -> (C_CUSTKEY, C_NAME ?, C_ADDRESS ?, C_PHONE ?, C_ACCTBAL ?, C_MKTSEGMENT ?, C_COMMENT ?, ORDERS *)
@CUSTOMER -> ()
primKeys (CUSTOMER) = (C_CUSTKEY)
SUPPLIER -> (S_SUPPKEY, S_NAME ?, S_ADDRESS ?, S_PHONE ?, S_ACCTBAL ?, S_COMMENT ?)
@SUPPLIER -> (@ID_SUPPLIER)
primKeys (SUPPLIER) = (S_SUPPKEY)
ORDERS -> (O_ORDERKEY, O_ORDERSTATUS ?, O_TOTALPRICE ?, O_ORDERDATE ?, O_ORDERPRIORITY ?, O_CLERK ?, O_SHIPPRIORITY ?, O_COMMENT ?, ORDER_ID, ORDER_DATE, ORDER_MODE ?, CUSTOMER_ID, ORDER_STATUS ?, ORDER_TOTAL ?, SALES_REP_ID ?, PROMOTION_ID ?)
@ORDERS -> ()
primKeys (ORDERS) = (ORDER_ID, O_ORDERKEY)
PARTSUPP -> (PS_AVAILQTY ?, PS_SUPPLYCOST ?, PS_COMMENT ?)
@PARTSUPP -> (@Ref_SUPPLIER)
primKeys (PARTSUPP) = (@Ref_SUPPLIER)