[SQL example] #SQL

sql_example.sql

CREATE TABLE product (
  id                 UUID		     PRIMARY KEY,
  name               VARCHAR(64)     NOT NULL,
  -- max 999999.9999
  price_amount       NUMERIC(10, 4)  NOT NULL CHECK (price_amount >= 0),
  price_currency     VARCHAR(10)     NOT NULL,
  created_at         TIMESTAMP WITH TIME ZONE NOT NULL,
  updated_at         TIMESTAMP WITH TIME ZONE NULL
);

CREATE TABLE product_price (
  product_id         VARCHAR(64)     REFERENCES product,
  money_currency     VARCHAR(10)     NOT NULL,
  money_amount       NUMERIC(10, 4)  NOT NULL CHECK (money_amount >= 0),
  UNIQUE(product_id, money_currency)
);

CREATE INDEX idx_payment_by_user_priceamount ON payment (user_id, price_amount);

ALTER TABLE payment ADD COLUMN payment_method VARCHAR(128);

ALTER TABLE payment DROP COLUMN IF EXISTS payment_method;