Please enable JavaScript.
Coggle requires JavaScript to display documents.
Entities (DB structure) - Coggle Diagram
Entities (DB structure)
Albums
link (varchar (255))
cover_url (varchar (255))
aws_hash
cover_hash (varchar (255))
tags (varchar (255))
cover_link (varchar (255))
subscriptions (varchar (255))
file_type (varchar (255))
cover (varchar (255))
is_encrypted (tinyint (1))
composer (varchar (255))
featured (tinyint (1))
title (varchar (255))
setting_date (timestamp)
creation_date (timestamp)
status (varchar (255))
corresponding_product (int (10))
album_id (int (10))
Subscriptions
status (varchar (255))
code_origin (varchar (255))
creation_date (timestamp)
subscription_product_id (int (11))
code (text)
code_active_until (datetime)
corresponding_order_id (varchar (32))
amasty_subscription_id (int (10))
customer_id (int (10))
cancelation_date (timestamp)
id (int (10))
Codes
Table of available and used codes
(index table)
code (text)
qty (int (11))
id (int (10))
used (int (11))
Table of codes applying
main_cutomer_id (int (10))
customer_id (int (10))
code (text)
is_paused (tinyint (1))
id (int (10))