Database

Image Metadata Storage

In order to implement replace preview to licensed image functionality, we should store information about the uploaded image. Consider storing as much info as we can to simplify further features development.

Database Schema

TBD

Fields details

adobe_stock_asset table

Field	API Field	Data Type	Description
id	N/A	int	primary key
media_type_id	N/A	int	Foreign key adobe_stock_media_type.id
category_id	N/A	int	Foreign key adobe_stock_image_category.id
creator_id	creator_id	int	Foreign key adobe_stock_image_creator.id
premium_level_id	N/A	int	Foreign key adobe_stock_premium_level.id
path	N/A	int	Filesystem image path (relative to media directory root)
adobe_id	id	int	Asset's unique identifier on adobe stock side
stock_id	stock_id	string
is_licensed	is_licensed	int	Is image licensed and downloaded
title	title	string	Asset's title
preview_url	comp_url	string	URL to the watermarked version of the asset
preview_width	comp_width	int	complementary (unlicensed) image pixels width
preview_height	comp_height	int	complementary (unlicensed) image pixels height
width	width	int	licensed width
height	height	int	licensed height
url		int	licensed image url
country_name	country_name	string
details_url	details_url	string	URL to the Adobe Stock details page for the asset. If you pass the Authorization header with the call, Adobe Stock generates an SSO jump URL
vector_type	vector_type	string|null	"svg" or "zip" (ai/eps) for vector images
content_type	content_type	string	Mime type of the asset's content.
creation_date	creation_date	string
created_at	N/A	string
updated_at	N/A	string

adobe_stock_category table

Field	Search Response Field	Data Type	Description
id	N/A	int	primary key
adobe_id	category.id	int
name	category.name	string

adobe_stock_asset_keyword table

Field	Data Type	Description
asset_id	int	Foreign key adobe_stock_image.id
keyword_id	int	Foreign key adobe_stock_image_keyword.id

adobe_stock_keyword table

Field	API Field	Data Type	Description
id	N/A	int	primary key
keyword	keywords	string

adobe_stock_asset_creator table

Field	API Field	Data Type	Description
id	N/A	int	primary key
adobe_id	creator_id	int
creator_name	creator_name	string	Asset creator's name

adobe_stock_media_type table

Field	API Field	Data Type	Description
id	N/A	int	primary key
adobe_id	media_type_id	int	adobe assets type
name	name	string	assets type name

adobe_stock_premium_level table

Field	API Field	Data Type	Description
id	N/A	int	primary key
adobe_id	premium_level_id	int
name	name	string	premium level name