public.coupons

Description

Labels

svc-smarttab

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	integer	nextval('coupons_id_seq'::regclass)	false	public.bills
merchant_id	integer		false		public.merchants
coupon_code	varchar(50)		false
coupon_name	varchar(255)		false
discount_type	varchar(20)		false
discount_value	numeric(10,2)		false
min_purchase_amount	numeric(12,2)		true
max_discount_amount	numeric(12,2)		true
valid_from	date		false
valid_to	date		false
max_uses	integer		true
max_uses_per_customer	integer		true
current_uses	integer	0	true
applicable_store_ids	jsonb		true
is_active	boolean	true	true
created_at	timestamp with time zone	now()	true
updated_at	timestamp with time zone	now()	true

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