5 lines
193 B
SQL
5 lines
193 B
SQL
ALTER TABLE "orders"
|
|
ADD COLUMN "coupon_id" INT NULL,
|
|
ADD COLUMN "discount_amount" DECIMAL(10, 2) DEFAULT 0.00,
|
|
ADD CONSTRAINT "fk_coupon" FOREIGN KEY ("coupon_id") REFERENCES "coupons"("id");
|