7 lines
261 B
SQL
7 lines
261 B
SQL
CREATE TABLE IF NOT EXISTS "coupons" (
|
|
"id" SERIAL PRIMARY KEY,
|
|
"code" VARCHAR(255) NOT NULL UNIQUE,
|
|
"discount_percentage" DECIMAL(5, 2) NOT NULL,
|
|
"is_active" BOOLEAN NOT NULL DEFAULT TRUE,
|
|
"created_at" TIMESTAMP DEFAULT CURRENT_TIMESTAMP
|
|
); |