Pipelines
Product Item Models
9min
this provides an overview of the models used to represent product items within the linns data pipeline project these models define the structure of tables in the database ensure you have read the 3pl integration pipeline docid\ js5jysp3sct6tzlsqhuqw before continuing models inventory the inventory model represents the product inventory table in the database it stores essential information about each product item attributes pkstockitemid (str) primary key for the inventory item itemnumber (str) the item number itemtitle (str) the item title categoryname (str) the category name barcodenumber (str) the barcode number metadata (str) the metadata for the item purchaseprice (int) the purchase price of the item retailprice (int) the retail price of the item quantity (int) the quantity of the item weight (str) the weight of the item locations the locations model represents the locations table in the database, storing information about different product locations attributes locationid (str) primary key for the location locationname (str) the name of the location stocklevels the stocklevels model represents the stock levels table in the database, tracking product stock levels at various locations attributes id (int) the primary key for the stock level fkstockitemid (str) foreign key referencing the inventory table's pkstockitemid fklocationid (str) foreign key referencing the locations table's locationid stocklevel (int) the stock level for the item at the location minimumlevel (int) the minimum stock level for the item at the location itemextendedproperties the itemextendedproperties model represents the item extended properties table in the database, capturing additional properties for each product item attributes id (int) the primary key for the extended property propertyname (str) the name of the extended property propertyvalue (str) the value of the extended property fkstockitemid (str) foreign key referencing the inventory table's pkstockitemid images the images model represents the images table in the database, storing information about product images attributes id (int) the primary key for the image fkstockitemid (str) foreign key referencing the inventory table's pkstockitemid source (str) the image source fullsource (str) the full image source sortorder (int) the sort order of the image ismain (bool) indicates if the image is the main image itemchanneltitles the itemchanneltitles model represents the item channel titles table in the database, recording titles associated with product items on various channels attributes id (int) the primary key for the item channel title source (str) the source of the item channel title subsource (str) the sub source of the item channel title fkstockitemid (str) foreign key referencing the inventory table's pkstockitemid title (str) the title of the item channel itemchanneldescription the itemchanneldescription model represents the item channel description table in the database, storing descriptions associated with product items on various channels attributes id (int) the primary key for the item channel description source (str) the source of the item channel description subsource (str) the sub source of the item channel description fkstockitemid (str) foreign key referencing the inventory table's pkstockitemid description (str) the description of the item channel itemchannelprices the itemchannelprices model represents the item channel prices table in the database, keeping track of prices for product items on various channels attributes id (int) the primary key for the item channel price source (str) the source of the item channel price subsource (str) the sub source of the item channel price fkstockitemid (str) foreign key referencing the inventory table's pkstockitemid price (int) the price of the item channel these models define the structure of the database tables used to store product related information within the linns data pipeline project