Single releases: each row is one product with its own barcode.
Box set: one product (box_set_barcode) containing multiple movies in order.
Inner-case EAN (box sets): optional. If provided, the system can also treat each movie as a “single” in your library.
Discs: use type_disc=feature for main movie discs, bonus for extras.
Bonus items: optionally list what’s on a bonus disc.
Adds a new empty row with the title filled in.
Titles
Title
Barcode (EAN-13)
IMDb ID (optional)
Discs…
Tip: For “single + bonus disc”, add 2 discs: one feature and one bonus.
(Submit is disabled in this pure-HTML prototype.)
Movies in box (ordered)
Order
Title
IMDb ID (optional)
Inner-case EAN (optional)
Treat as single?
Inner-case EAN: If you enter an EAN for a movie inside the box, you can also have it treated as its own “single” in your library (no DDL changes required; backend can create a single physical_collection row).
Discs in this box (for copy_id = 1)
Set empty for “box-level” bonus disc.
Order
Type
Format
Related movie
Bonus items…
Bonus items are stored per disc (table disc_bonus_item).