public.coupons

Description

Labels

svc-smarttab

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	integer	nextval('coupons_id_seq'::regclass)	false	public.bills		Coupon identifier.
merchant_id	integer		false		public.merchants	Parent merchant ID.
coupon_code	varchar(50)		false			Coupon code (unique within merchant).
coupon_name	varchar(255)		false			Coupon display name.
discount_type	varchar(20)		false			Discount type: percentage or fixed_amount.
discount_value	numeric(10,2)		false			Discount value.
min_purchase_amount	numeric(12,2)		true			Minimum purchase amount to apply coupon.
max_discount_amount	numeric(12,2)		true			Maximum discount amount.
valid_from	date		false			Coupon valid from date.
valid_to	date		false			Coupon valid to date.
max_uses	integer		true			Maximum total uses.
max_uses_per_customer	integer		true			Maximum uses per customer.
current_uses	integer	0	true			Current use count.
applicable_store_ids	jsonb		true			Applicable store IDs (empty = all stores).
is_active	boolean	true	true			Coupon active status.
created_at	timestamp with time zone	now()	true			Record creation timestamp.
updated_at	timestamp with time zone	now()	true			Record last update timestamp.

Viewpoints

Name	Definition
Order & Billing	Order lifecycle — Orders → Bills → Payments → Settlements

Constraints

Name	Type	Definition
coupons_dates_check	CHECK	CHECK ((valid_to >= valid_from))
coupons_discount_type_check	CHECK	CHECK (((discount_type)::text = ANY ((ARRAY['percentage'::character varying, 'fixed_amount'::character varying])::text[])))
coupons_merchant_id_fkey	FOREIGN KEY	FOREIGN KEY (merchant_id) REFERENCES merchants(id) ON DELETE CASCADE
coupons_pkey	PRIMARY KEY	PRIMARY KEY (id)
uq_coupons_merchant_coupon_code	UNIQUE	UNIQUE (merchant_id, coupon_code)

Indexes

Name	Definition
coupons_pkey	CREATE UNIQUE INDEX coupons_pkey ON public.coupons USING btree (id)
uq_coupons_merchant_coupon_code	CREATE UNIQUE INDEX uq_coupons_merchant_coupon_code ON public.coupons USING btree (merchant_id, coupon_code)
ix_coupons_merchant_id	CREATE INDEX ix_coupons_merchant_id ON public.coupons USING btree (merchant_id)

Relations

---

Generated by tbls