Others

Account

Table: account

Column Name	Data type	Description
account_id	Integer	Intentwise Account Id
account_name	String	Intentwise Account Name
organization_name	String	Organization name used within the intentwise
amazon_profile_id	Integer	Unique amazon Identifier for sellers and vendors referenced by APIs
region	String	Account region
country_code	String	Country code of the account
currency_code	String	Currency Code of the account
market_place	String	Market place of the account
brand_id	String	Identifier for sellers and vendors. Note that this value is not unique and maybe the same across the marketplace.
brand_type	String	The SELLER and VENDOR account types are associated with Sponsored Ads APIs. The AGENCY account type is associated with DSP
vendor_name	String	Account name used within the amazon console

Catalog Master

Table: catalog_master

Note: This table should be used in conjunction with catalog_item_summary. Use ctlg_master_id as the join condition

Column Name	Data type	Description
ctlg_master_id	Integer	Unique Identifier
asin	String	Amazon ASIN
account_id	Integer	Intentwise Account Identifier
account_name	String	Intentwise Account Name

Catalog Item Summary

Table: catalog_item_summary

Column Name	Data type	Description
id	Integer	Unique Identfier
brand_name	String	Name of the brand associated with an Amazon catalog item
browse_node	String	Classification (browse node) associated with an Amazon catalog item.
color_name	String	Name of the color associated with an Amazon catalog item.
item_name	String	Name, or title, associated with an Amazon catalog item.
manufacturer	String	Name of the manufacturer associated with an Amazon catalog item.
model_number	String	Model number associated with an Amazon catalog item.
size_name	String	Name of the size associated with an Amazon catalog item.
style_name	String	Name of the style associated with an Amazon catalog item.
ctlg_master_id	Integer	Key to join with catalog_master table
account_id	Integer	Intentwise account identifier

Catalog Item Images

Table: catalog_item_images

Note: This table can be used in conjunction with catalog_item_summary and catalog_master. Use ctlg_master_id as the join condition

Column Name	Data Type	Description
id	Integer	Unique Identfier
variant	string	Variant of the image, such as MAIN or PT01
link	String	Link, or URL, for the image.
height	Integer	Height of the image in pixels.
width	Integer	Width of the image in pixels.
ctlg_master_id	Integer	Key to join with catalog_master table
account_id	Integer	Intentwise account identifier