public.court_blocker¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | uuid | false | public.court_blocker_court | (DC2Type:uuid) | ||
| starts_at | timestamp(0) with time zone | false | (DC2Type:datetimetz_immutable) | |||
| ends_at | timestamp(0) with time zone | false | (DC2Type:datetimetz_immutable) | |||
| title | varchar(255) | false | ||||
| created_at | timestamp(0) with time zone | NULL::timestamp with time zone | true | (DC2Type:datetimetz_immutable) | ||
| updated_at | timestamp(0) with time zone | NULL::timestamp with time zone | true | (DC2Type:datetimetz_immutable) | ||
| note | text | true | ||||
| created_by_id | uuid | true | public.user | (DC2Type:uuid) | ||
| updated_by_id | uuid | true | public.user | (DC2Type:uuid) |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| court_blocker_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| fk_9e65a63896dbbde | FOREIGN KEY | FOREIGN KEY (updated_by_id) REFERENCES "user"(id) |
| fk_9e65a63b03a8386 | FOREIGN KEY | FOREIGN KEY (created_by_id) REFERENCES "user"(id) |
Indexes¶
| Name | Definition |
|---|---|
| court_blocker_pkey | CREATE UNIQUE INDEX court_blocker_pkey ON public.court_blocker USING btree (id) |
| idx_9e65a63b03a8386 | CREATE INDEX idx_9e65a63b03a8386 ON public.court_blocker USING btree (created_by_id) |
| idx_9e65a63896dbbde | CREATE INDEX idx_9e65a63896dbbde ON public.court_blocker USING btree (updated_by_id) |
Relations¶
Generated by tbls