· 8 years ago · Mar 08, 2018, 09:52 PM
1CREATE TABLE IF NOT EXISTS PRODUCT_INV (
2Product_Code TEXT,
3Storecode TEXT,
4StoreType TEXT,
5ProductInfo TEXT,
6PRIMARY KEY ((Product_Code, Storecode, StoreType)));
7
8Product_Code Storecode StoreType ProductInfo
912 601 Retail ABC
1012 601 Supermart ABC
1113 601 Retail DEF
1214 701 Retail QWE
1313 601 Supermart ZXC
14
15Storecode: 601
16StoreType: Retail
17List of Product_Code : 12,13
18
19Storecode: 601
20StoreType : Supermart
21List of Product_Code : 12,13
22
23Storecode: 701
24StoreType: Retail
25List of Product_Code:14