Skip to content

Barcode database refactoring #150

@ArktinenKarpalo

Description

@ArktinenKarpalo

It would make more sense to have barcode column in RVITEM, and then refer to RVITEM from PRICE.

UPDATE "RVITEM"
SET barcode=lol.barcode
FROM (SELECT itemid,barcode FROM "PRICE" GROUP BY itemid,barcode) as lol
WHERE "RVITEM".itemid=lol.itemid;

Metadata

Metadata

Assignees

No one assigned

    Labels

    Tech-DebtDeveloper experience improvement

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions