· 6 years ago · Aug 24, 2019, 07:36 PM
1CREATE TABLE IF NOT EXISTS demo_il.k001_hier_item_key
2(
3 hier_item_id BIGINT NOT NULL,
4 hier_item_src_pfx VARCHAR(1024) NOT NULL,
5 hier_item_src_key VARCHAR(1024) NOT NULL,
6 src_syst_id INTEGER NOT NULL,
7 PRIMARY KEY(hier_item_src_pfx, hier_item_src_key, src_syst_id)
8);