products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
25 rows where series_id = "CNT_2SFP92K6R9RG"
This data as json, CSV (advanced)
Suggested facets: description, listed_at (date), on_sale_at (date)
| id ▼ | content_id | series_id | parent_content_id | level | content_type | product_type | title | alt_titles | subtitle | display_title | display_title_short | description | description_short | image_id | display_order | listed_at | label_id | geoblock_id | display_name | copyright | on_presale_at | on_sale_at | off_sale_at | add_on | add_on_campaign_only |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PRD_01F8NKYRKVF0 | CNT_12ZWTRKDZPMG | Soul Eater CNT_2SFP92K6R9RG | CNT_2SFP92K6R9RG | 2 | 1 | 1 | Volume 17 | [] | Soul Eater, Vol. 17 | The DWMA student body is still reeling after the news that one of their own is a witch. But as one young witch flees Death City, another has come back to DWMA hoping to strike a deal with Shinigami-sama. Medusa has already proven herself a traitor to the school, but the information she offers is critical to DWMA's efforts to take down Arachnophobia and curb the spread of madness. Can Medusa be trusted to lead a team of students into the heart of enemy territory?! | 01KG9819GGVYQ2HTQDRXTQP0ZD | 17.0 | 2016-06-30T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Soul Eater, Vol. 17 | 2016-06-30T15:00:00.000Z | 0 | 0 | ||||||
| PRD_040MF60E29KG | CNT_0HTTJ5BHXKQ0 | Soul Eater CNT_2SFP92K6R9RG | CNT_2SFP92K6R9RG | 2 | 1 | 1 | Volume 18 | [] | Soul Eater, Vol. 18 | As Kid struggles against the madness deep in the Book of Eibon, a group of Spartoi members race to rescue their friend. Through page after page of Lust, Gluttony, and Envy, the students must conquer the seduction of their own fears and desires to reach the final chapter! Will their efforts be enough to give this tale a happy ending? | 01KG9800H5X3S5TPAB3HB35RRH | 18.0 | 2016-06-30T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Soul Eater, Vol. 18 | 2016-06-30T15:00:00.000Z | 0 | 0 | ||||||
| PRD_05XV76R2ZTE0 | CNT_32A9TA9PANNG | Soul Eater CNT_2SFP92K6R9RG | CNT_2SFP92K6R9RG | 2 | 1 | 1 | Volume 15 | [] | Soul Eater, Vol. 15 | Deep in the belly of Baba Yaga Castle, Maka, Soul, and Medusa prepare to face Arachne in her own chambers. Arachne has grown even stronger since their last meeting, and even the crafty Medusa is caught in her sister's twisted web. As Arachne's intense madness threatens everyone in and around the castle, Soul must perform a string concerto that will move his audience to their very souls...or be caught in the witch's net himself! | 01KG9815JCJEVS0FDY3CNK4E5Y | 15.0 | 2016-06-30T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Soul Eater, Vol. 15 | 2016-06-30T15:00:00.000Z | 0 | 0 | ||||||
| PRD_08JBJST4VSD0 | CNT_15M75NZYSMPG | Soul Eater CNT_2SFP92K6R9RG | CNT_2SFP92K6R9RG | 2 | 1 | 1 | Volume 13 | [] | Soul Eater, Vol. 13 | As Maka and a team of DWMA students slip into Baba Yaga Castle in the guise of Arachnophobian guards, Black*Star opts for his usual style of entrance: loud and without a trace of subtlety! But although Black*Star doesn't seem to have changed much on the outside, inwardly he has at last found the way to harness the true power of the Uncanny Sword. And that means he's ready to test his blade in a round three rematch against swordsman Mifune! Will Black*Star's transformation be enough? Or will he once again find himself at the mercy of the great samurai?! | 01KG98144ZFP4CGAGMMGAADJQG | 13.0 | 2016-06-30T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Soul Eater, Vol. 13 | 2016-06-30T15:00:00.000Z | 0 | 0 | ||||||
| PRD_0F0TWCMF7RC0 | CNT_34YM57M74KQG | Soul Eater CNT_2SFP92K6R9RG | CNT_2SFP92K6R9RG | 2 | 1 | 1 | Volume 11 | [] | Soul Eater, Vol. 11 | Arachnophobia has taken the offensive and spreads the Kishin's madness throughout the world, using "BREW" to threaten anyone who stands in their way. In the wake of attacks at home and abroad, DWMA sends its top students to quell the madness and gather information wherever they can. But the madness is spreading much quicker and is stronger than they had anticipated. When confronted by an incarnation of the Kishin's madness itself-the sinister Clown-will Maka and Soul fall victim to it's manipulations? | 01KG98113N2WVAD35KD76EYTS2 | 11.0 | 2016-06-30T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Soul Eater, Vol. 11 | 2016-06-30T15:00:00.000Z | 0 | 0 | ||||||
| PRD_0FHR5GYFGZZG | CNT_22H7XPZGT9V0 | Soul Eater CNT_2SFP92K6R9RG | CNT_2SFP92K6R9RG | 2 | 1 | 1 | Volume 22 | [] | Soul Eater, Vol. 22 | The remaining Death Weapons, along with Kid, gather to stage their assault on the moon. As they approach the Kishin's hideout, Stein and Justin clash in a violent, madness-fueled battle. Stein struggles to maintain his grip on sanity while Justin draws power from the Kishin's inexhaustible aura of madness. Everyone knows there will be casualties on the road to restoring "order"-but will Stein become the first? | 01KG97TCPG6YDE2BVJR98G16AZ | 22.0 | 2016-06-30T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Soul Eater, Vol. 22 | 2016-06-30T15:00:00.000Z | 0 | 0 | ||||||
| PRD_1KHNFZHH3RK0 | CNT_14914HAFKJGG | Soul Eater CNT_2SFP92K6R9RG | CNT_2SFP92K6R9RG | 2 | 1 | 1 | Volume 9 | [] | Soul Eater, Vol. 9 | Crona's loyalties are torn as Medusa regroups and plots to beat both DWMA and her sister, Arachne, in the arms race for Eibon's demon tools. As the madness of the Kishin continues to spread, Maka, Black*Star, and Kid begin even more rigorous training to master their weapons and work together as a team. Will they be ready to face Arachnophobia in time for their next mission? Or will internal strife tear them apart?! | 01KG980Y97RY736SWZK137CEXP | 9.0 | 2016-06-30T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Soul Eater, Vol. 9 | 2016-06-30T15:00:00.000Z | 0 | 0 | ||||||
| PRD_1P65TJKVC7J0 | CNT_37KY430QYHHG | Soul Eater CNT_2SFP92K6R9RG | CNT_2SFP92K6R9RG | 2 | 1 | 1 | Volume 7 | [] | Soul Eater, Vol. 7 | Shinigami-sama summons the strongest weapons from around the world to contain the rogue kishin and the spread of his madness. As these powerful weapons strategize for what will be the most difficult battle of their lives, the students of DWMA try to get back to their normal lives as best they can. For Maka, adjusting to the dangerous times is nothing compared to Crona's struggle to adjust to life as a DWMA student! | 01KG980WE3WJTR9E1YA53N7WJX | 7.0 | 2016-06-30T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Soul Eater, Vol. 7 | 2016-06-30T15:00:00.000Z | 0 | 0 | ||||||
| PRD_1S54QRF7M5G0 | CNT_368R7RB8VFKG | Soul Eater CNT_2SFP92K6R9RG | CNT_2SFP92K6R9RG | 2 | 1 | 1 | Volume 3 | [] | Soul Eater, Vol. 3 | Tsubaki and Black*Star set off on their most difficult mission yet: a battle with the Uncanny Sword Masamune, a soul on the brink of becoming a Kishin. But this fight holds personal significance for Tsubaki - their target is her older brother. Jealous of her inherited talents, Masamune is holding nothing back. Usually docile and complacent, Tsubaki must find the strength to overtake the Uncanny Sword before she too is sucked into the darkness. | 01KG980NX2PXWCQRAXQF11M43P | 3.0 | 2016-06-30T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Soul Eater, Vol. 3 | 2016-06-30T15:00:00.000Z | 0 | 0 | ||||||
| PRD_1SX0FX0YT76G | CNT_1EWDC5T9G2C0 | Soul Eater CNT_2SFP92K6R9RG | CNT_2SFP92K6R9RG | 2 | 1 | 1 | Volume 25 | [] | Soul Eater, Vol. 25 | Kid's sense of order stands in sharp contrast to the unpredictable madness of the Kishin. But order and madness are two sides of the same coin. When Asura challenges the "tyrannical" Shinigami and his laws that serve to control humans' lives, Kid can feel the tendrils of madness within himself seeking purchase. The bonds of his friendships and his faith in order are tested to their limits as Asura makes his final stand against the forces of DWMA. When the moondust settles, who will emerge as lord of this world--Shinigami or Kishin? | 01KG95KHPTE44P2CZQ5KH6MK5V | 25.0 | 2016-06-30T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Soul Eater, Vol. 25 | 2016-06-30T15:00:00.000Z | 0 | 0 | ||||||
| PRD_1TMM45DX86H0 | CNT_16YB4EN0DGJG | Soul Eater CNT_2SFP92K6R9RG | CNT_2SFP92K6R9RG | 2 | 1 | 1 | Volume 5 | [] | Soul Eater, Vol. 5 | On the night of DWMA's anniversary celebration, every meister and weapon in Death City has gathered at the school for an evening of music and dancing. Little do they know that the witch Medusa is about the crash Shinigama-sama's party. Trapping the meisters inside, the witch makes her way to the chamber where the First Kishin is imprisoned. Will the few meisters who've managed to escape be enough to prevent Medusa from rousing the madness that slumbers far below in the Kishin's domain? | 01KG980RKTJ72MWAXJ8A4MM395 | 5.0 | 2016-06-30T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Soul Eater, Vol. 5 | 2016-06-30T15:00:00.000Z | 0 | 0 | ||||||
| PRD_1XVQ1B99G4Q0 | CNT_1SJN7A1H6EWG | Soul Eater CNT_2SFP92K6R9RG | CNT_2SFP92K6R9RG | 2 | 1 | 1 | Volume 1 | [] | Soul Eater, Vol. 1 | Maka is a scythe meister, working to perfect one particular scythe until it is good enough to become Death's Weapon -- the weapon used by Shinigami-sama, the spirit of Death himself. As if that wasn't unusual enough, her scythe is a demon scythe called Soul Eater, which can change form from a scythe to a human-looking boy. In order to make Soul Eater powerful enough to be Death's Weapon, he must eat the souls of 99 humans and 1 witch. Along the way, the two of them face many different challenges, including a cat witch named Blair (who happens to have a thing for Soul) and a teacher who's been turned into a zombie (and wants him to join her!). Her fellow students, like the shadow ninja weapon meister named Black Star who always needs to be the center of attention, aren't much help, either. It'll be a miracle if Maka even survives, let alone manages to make Soul Eater into the Death Scythe. | 01KG6ZFYGAJ4H6F5YVXNNCEYP5 | 1.0 | 2016-06-30T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Soul Eater, Vol. 1 | 2016-06-30T15:00:00.000Z | 0 | 0 | ||||||
| PRD_23AXBAQ6RAX0 | CNT_1YTQ2JT5856G | Soul Eater CNT_2SFP92K6R9RG | CNT_2SFP92K6R9RG | 2 | 1 | 1 | Volume 19 | [] | Soul Eater, Vol. 19 | In his madness, Death the Kid has embraced a new notion of "order": Only in nothingness can there be true balance and equilibrium. But for Black*Star, being on equal footing with anyone is not his style. Black*Star has always wanted to "transcend the gods"-now his only chance may be to overpower his shinigami friend and take Death down if he wants to save him...! | 01KG9803VXZ78G7FY6VKKJ17B2 | 19.0 | 2016-06-30T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Soul Eater, Vol. 19 | 2016-06-30T15:00:00.000Z | 0 | 0 | ||||||
| PRD_23Q6BDHMEJB0 | CNT_30XA353KCX8G | Soul Eater CNT_2SFP92K6R9RG | CNT_2SFP92K6R9RG | 2 | 1 | 1 | Volume 21 | [] | Soul Eater, Vol. 21 | Crona's crimes have become too terrible to ignore, and the troubled youth is added to Shinigami's list. Hoping to reach her friend first, Maka extends her soul perception ability to engulf the entire planet. But the sweep delivers even more than she had bargained for--the location of the Kishin's hideout! | 01KG97THCGDTEQ5R0WCV4MKEAC | 21.0 | 2016-06-30T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Soul Eater, Vol. 21 | 2016-06-30T15:00:00.000Z | 0 | 0 | ||||||
| PRD_27MKEW9XHVYG | CNT_22MKA1EJ4640 | Soul Eater CNT_2SFP92K6R9RG | CNT_2SFP92K6R9RG | 2 | 1 | 1 | Volume 16 | [] | Soul Eater, Vol. 16 | Like the other members of the newly formed Spartoi unit, Maka and Soul undergo rigorous training, probing the boundaries of Soul's hard-won new potential as a weapon. Maka's soul perception ability has made her the enemy's next target, and she and Soul will have to kick it up to a whole new level-and fast! Noah and his followers are coming, ready or not!! | 01KG98187C2YHMA8HB32MMVZVF | 16.0 | 2016-06-30T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Soul Eater, Vol. 16 | 2016-06-30T15:00:00.000Z | 0 | 0 | ||||||
| PRD_2A53RFB7XTXG | CNT_05Z0NK4TK550 | Soul Eater CNT_2SFP92K6R9RG | CNT_2SFP92K6R9RG | 2 | 1 | 1 | Volume 14 | [] | Soul Eater, Vol. 14 | When "BREW" activates in the middle of his battle with Mosquito, Death the Kid's soul wavelength is amplified to a whole new level! But once Mosquito has recovered from the shock of seeing the real "BREW" in action, he redoubles his efforts to destroy the young shinigami before the intruders from DWMA unlock the way to the Spider Queen Room. Will Kid's awakened power be enough to defeat Mosquito's deadly form?! | 01KG9814RGVFZFGJNGBGZKJED2 | 14.0 | 2016-06-30T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Soul Eater, Vol. 14 | 2016-06-30T15:00:00.000Z | 0 | 0 | ||||||
| PRD_2D82PN7C5R3G | CNT_04MAN8FBD370 | Soul Eater CNT_2SFP92K6R9RG | CNT_2SFP92K6R9RG | 2 | 1 | 1 | Volume 10 | [] | Soul Eater, Vol. 10 | With Doctor Stein unable to carry on, Maka, Kid, and Black*Star enter the magnetic field to take up the mission and locate the tempestuous demon tool known as Brew. Time is quickly running out as the three face off against Mosquito, struggling to harmonize their wavelengths within the magnetized vortex. They'll be lucky to escape with their lives, let alone the demon tool! | 01KG980Z0EZ6Y6RBSW0DQ1GK9J | 10.0 | 2016-06-30T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Soul Eater, Vol. 10 | 2016-06-30T15:00:00.000Z | 0 | 0 | ||||||
| PRD_2EVJB259SSWG | CNT_259XNYS2Y460 | Soul Eater CNT_2SFP92K6R9RG | CNT_2SFP92K6R9RG | 2 | 1 | 1 | Volume 12 | [] | Soul Eater, Vol. 12 | The DWMA student body is still reeling after the news that one of their own is a witch. But as one young witch flees Death City, another has come back to DWMA hoping to strike a deal with Shinigami-sama. Medusa has already proven herself a traitor to the school, but the information she offers is critical to DWMA's efforts to take down Arachnophobia and curb the spread of madness. Can Medusa be trusted to lead a team of students into the heart of enemy territory?! | 01KG9812Q7Y6Q5QGX6QS8HZ550 | 12.0 | 2016-06-30T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Soul Eater, Vol. 12 | 2016-06-30T15:00:00.000Z | 0 | 0 | ||||||
| PRD_2MAJCNBWQH90 | CNT_09YMGM6H9WAG | Soul Eater CNT_2SFP92K6R9RG | CNT_2SFP92K6R9RG | 2 | 1 | 1 | Volume 24 | [] | Soul Eater, Vol. 24 | DWMA braces for the final showdown as the Kishin awakens from his slumber at the heart of the moon. Unable to contain his rage, Noah is the first to attack, the Book of Eibon and "BREW" fueling his assault. Despite his formidable efforts, though, Noah is overcome not by the Kishin, but by the sudden appearance of Crona. With the world hanging in the balance, DWMA can only wonder who will prove to be the greater foe--the Kishin...or Crona... | 01KG95KZDTZRDRK3DK66MBNS36 | 24.0 | 2016-06-30T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Soul Eater, Vol. 24 | 2016-06-30T15:00:00.000Z | 0 | 0 | ||||||
| PRD_316CDCZHPSH0 | CNT_365CFDW7EKJG | Soul Eater CNT_2SFP92K6R9RG | CNT_2SFP92K6R9RG | 2 | 1 | 1 | Volume 23 | [] | Soul Eater, Vol. 23 | Kid enters the witches' realm to appeal for help! Though they have been DWMA's enemies for years, the witches share a respect for order--and are equally threatened by the Kishin. Kid's immediate goal is to deal with the situation on the moon, but he hopes that the negotiations will forge a new pact between DWMA and witches in the future--assuming anyone survives the Kishin's madness! | 01KG95N1ZP9480297NK40QC4TT | 23.0 | 2016-06-30T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Soul Eater, Vol. 23 | 2016-06-30T15:00:00.000Z | 0 | 0 | ||||||
| PRD_3CQDD4DMM8GG | CNT_0CKJHSV54JJ0 | Soul Eater CNT_2SFP92K6R9RG | CNT_2SFP92K6R9RG | 2 | 1 | 1 | Volume 20 | [] | Soul Eater, Vol. 20 | Kid has been freed from Noah's greedy clutches, but The Book of Eibon remains at large. Noah was a troublesome foe, but the vast knowledge contained within the book could itself be dangerous - and information is not all that lies in its pages... Meanwhile, Crona has resurfaced in Moscow, his madness and Medusa's maternal pressure having all but consumed the friend Maka once knew. The question is how many will be devoured by Crona's madness before he can be stopped?! | 01KG97TW17V5ZT4DNW571DAQER | 20.0 | 2016-06-30T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Soul Eater, Vol. 20 | 2016-06-30T15:00:00.000Z | 0 | 0 | ||||||
| PRD_3HYX080PE72G | CNT_27Y7MT5KR200 | Soul Eater CNT_2SFP92K6R9RG | CNT_2SFP92K6R9RG | 2 | 1 | 1 | Volume 8 | [] | Soul Eater, Vol. 8 | While Black*Star and Tsubaki keep Mifune and Mosquito distracted, Sid is able to locate Arachnophobia's demon tool and put an abrupt end to their sinister plans. But though the evil organization won't be manipulating anyone's morality anytime soon, the blueprints for the dangerous tool are sealed away in Shinigami-sama's secret vault rather than destroyed. Surely Shinigami-sama would never think of constructing a demon tool himself?! | 01KG980XB2DETXRTG231EAJRM2 | 8.0 | 2016-06-30T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Soul Eater, Vol. 8 | 2016-06-30T15:00:00.000Z | 0 | 0 | ||||||
| PRD_3MFDKV2RA61G | CNT_078MM5VW7110 | Soul Eater CNT_2SFP92K6R9RG | CNT_2SFP92K6R9RG | 2 | 1 | 1 | Volume 6 | [] | Soul Eater, Vol. 6 | Death the Kid and Black*Star race after Free and Eruka, ready to do whatever it takes to stop the Black Blood before it is used to revive the slumbering First Kishin. Meanwhile, Maka has allowed herself to slip into madness in an effort to reach Crona's troubled soul. In addition to being horribly embarrassing, her actions carry a great risk. If Maka can't find Crona fast, she too will be consumed by madness! | 01KG980VFT2GVRYSYZ4NC8SKW1 | 6.0 | 2016-06-30T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Soul Eater, Vol. 6 | 2016-06-30T15:00:00.000Z | 0 | 0 | ||||||
| PRD_3RXWXFW2P50G | CNT_26K1QQG4J020 | Soul Eater CNT_2SFP92K6R9RG | CNT_2SFP92K6R9RG | 2 | 1 | 1 | Volume 4 | [] | Soul Eater, Vol. 4 | At Maka's request, she and Soul meet with Doctor Stein for an intensive tutoring session. Although Stein warns that they may never be able to resonate again if they fail to complete the training, Maka insists, desperate to become stronger so that Soul is never hurt again. But Soul's strange nightmares have made him reluctant to seek power, and his unwillingness to share his fears only frustrates his partner. With their soul wavelengths pulling apart, will Maka and Soul be able to come together when danger emerges on their next assignment? | 01KG980QC21G8R2K4Z5XRYWYRR | 4.0 | 2016-06-30T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Soul Eater, Vol. 4 | 2016-06-30T15:00:00.000Z | 0 | 0 | ||||||
| PRD_3ZJF82Y4J47G | CNT_0SXYQ16D1Z30 | Soul Eater CNT_2SFP92K6R9RG | CNT_2SFP92K6R9RG | 2 | 1 | 1 | Volume 2 | [] | Soul Eater, Vol. 2 | StartFragmentThe remedial assignment continues as Soul and Maka confront Dr. Franken Stein, the man behind Sid-sensei's unfortunate transformation and the strongest meister ever to graduate from Death Weapon Meister Academy. Even without a weapon, his massive soul dwarfs them all-even big shot Black*Star! Can Maka rally her strength to face Stein in battle, or will despair be her downfall?EndFragment | 01KG980MNKDZ7YC8CVPGD932XK | 2.0 | 2016-06-30T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Soul Eater, Vol. 2 | 2016-06-30T15:00:00.000Z | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE products (
id TEXT PRIMARY KEY,
content_id TEXT NOT NULL,
series_id TEXT NOT NULL,
parent_content_id TEXT,
level INTEGER NOT NULL,
content_type INTEGER NOT NULL,
product_type INTEGER NOT NULL,
title TEXT NOT NULL,
alt_titles TEXT NOT NULL,
subtitle TEXT NOT NULL,
display_title TEXT NOT NULL,
display_title_short TEXT NOT NULL,
description TEXT NOT NULL,
description_short TEXT NOT NULL,
image_id TEXT NOT NULL,
display_order REAL NOT NULL,
listed_at TEXT NOT NULL,
label_id TEXT NOT NULL,
geoblock_id TEXT,
display_name TEXT NOT NULL,
copyright TEXT,
on_presale_at TEXT,
on_sale_at TEXT NOT NULL,
off_sale_at TEXT,
add_on INTEGER NOT NULL,
add_on_campaign_only INTEGER NOT NULL,
FOREIGN KEY (series_id) REFERENCES series(id),
FOREIGN KEY (label_id) REFERENCES labels(id),
FOREIGN KEY (geoblock_id) REFERENCES geoblocks(id)
);
CREATE INDEX idx_products_content ON products(content_id);
CREATE INDEX idx_products_series ON products(series_id);
CREATE INDEX idx_products_label ON products(label_id);
CREATE INDEX idx_products_geoblock ON products(geoblock_id);
CREATE INDEX idx_products_image ON products(image_id);