public.discount

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	uuid		false	public.match_player public.match_series		(DC2Type:uuid)
group_id	uuid		true		public.user_group	(DC2Type:uuid)
created_at	timestamp(0) with time zone		false			(DC2Type:datetimetz_immutable)
valid_from	timestamp(0) with time zone		false			(DC2Type:datetimetz_immutable)
valid_till	timestamp(0) with time zone		false			(DC2Type:datetimetz_immutable)
percentage	integer		false
is_enabled	boolean		false
applicable_on_days	text		false			(DC2Type:simple_array)
applicable_from_time	time(0) without time zone	NULL::time without time zone	false			(DC2Type:time_immutable)
applicable_till_time	time(0) without time zone	NULL::time without time zone	false			(DC2Type:time_immutable)
applicable_on_sports	text		false			(DC2Type:simple_array)
applicable_on_locations	text		false			(DC2Type:simple_array)
max_playable_hours_in_validity_period	integer		true
kind	varchar(255)	NULL::character varying	true
played_hours_in_validity_period	double precision	0	false
played_hours_last_computed_at	timestamp(0) with time zone	NULL::timestamp with time zone	true			(DC2Type:datetimetz_immutable)
origin	varchar(255)	NULL::character varying	false

Constraints

Name	Type	Definition
fk_e1e0b40efe54d947	FOREIGN KEY	FOREIGN KEY (group_id) REFERENCES user_group(id)
discount_pkey	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
discount_pkey	CREATE UNIQUE INDEX discount_pkey ON public.discount USING btree (id)
idx_e1e0b40efe54d947	CREATE INDEX idx_e1e0b40efe54d947 ON public.discount USING btree (group_id)

Relations

---

Generated by tbls