root -> (MPART *, MREGION *, MNATION *, MEMP *)
@root -> ()
primKeys (root) = ()
MPART -> (PARTKEY, NAME ?, MFGR ?, BRAND ?, TYPE ?, P_SIZE ?, CONTAINER ?, RETAILPRICE ?, P_COMMENT ?, MPARTSUPP *)
@MPART -> ()
primKeys (MPART) = (PARTKEY)
MREGION -> (REGIONKEY, NAME ?, R_COMMENT ?)
@MREGION -> ()
primKeys (MREGION) = (REGIONKEY)
MNATION -> (NATIONKEY, NAME ?, REGIONKEY ?, N_COMMENT ?, MCUSTOMER *, MSUPPLIER *)
@MNATION -> ()
primKeys (MNATION) = (NATIONKEY)
MNATION(REGIONKEY) REFERS MREGION (REGIONKEY)
MEMP -> (EID, NAME ?, MPROJ *)
@MEMP -> (@Ref_MPROJ)
primKeys (MEMP) = (EID)
MCUSTOMER -> (CUSTKEY, NAME ?, ADDRESS ?, PHONE ?, ACCTBAL ?, MKTSEGMENT ?, C_COMMENT ?, MORDERS *)
@MCUSTOMER -> ()
primKeys (MCUSTOMER) = (CUSTKEY)
MORDERS -> (ORDERKEY, ORDERSTATUS ?, TOTALPRICE ?, ORDERDATE ?, ORDERPRIORITY ?, CLERK ?, SHIPPRIORITY ?, O_COMMENT ?, MLINEITEM ?)
@MORDERS -> ()
primKeys (MORDERS) = (ORDERKEY)
MLINEITEM -> (LINENUMBER ?, QUANTITY ?, EXTENDEDPRICE ?, DISCOUNT ?, TAX ?, RETURNFLAG ?, LINESTATUS ?, SHIPDATE ?, COMMITDATE ?, RECEIPTDATE ?, SHIPINSTRUCT ?, SHIPMODE ?, L_COMMENT ?)
@MLINEITEM -> (@Ref_MPARTSUPP)
primKeys (MLINEITEM) = ()
MSUPPLIER -> (SUPPKEY, NAME ?, ADDRESS ?, PHONE ?, ACCTBAL ?, S_COMMENT ?)
@MSUPPLIER -> (@ID_MSUPPLIER)
primKeys (MSUPPLIER) = (SUPPKEY)
MPARTSUPP -> (AVAILQTY ?, SUPPLYCOST ?, PS_COMMENT ?)
@MPARTSUPP -> (@ID_MPARTSUPP, @Ref_MSUPPLIER)
primKeys (MPARTSUPP) = (@Ref_MSUPPLIER)
MPROJ -> (NAME)
@MPROJ -> (@ID_MPROJ)
primKeys (MPROJ) = (NAME)