public.offer_daily_schedules¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| day | varchar(10) | false | ||||
| id | bigint | false | public.offer_schedule_intervals | |||
| offer_id | bigint | false | public.offers |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| offer_daily_schedules_offer_id_3d240b22_fk_offers_id | FOREIGN KEY | FOREIGN KEY (offer_id) REFERENCES offers(id) DEFERRABLE INITIALLY DEFERRED |
| offer_daily_schedules_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| unique_offer_day | UNIQUE | UNIQUE (offer_id, day) |
Indexes¶
| Name | Definition |
|---|---|
| offer_daily_day_dced47_idx | CREATE INDEX offer_daily_day_dced47_idx ON public.offer_daily_schedules USING btree (day) |
| offer_daily_schedules_offer_id_3d240b22 | CREATE INDEX offer_daily_schedules_offer_id_3d240b22 ON public.offer_daily_schedules USING btree (offer_id) |
| offer_daily_schedules_pkey | CREATE UNIQUE INDEX offer_daily_schedules_pkey ON public.offer_daily_schedules USING btree (id) |
| unique_offer_day | CREATE UNIQUE INDEX unique_offer_day ON public.offer_daily_schedules USING btree (offer_id, day) |
Generated by tbls