public.wellpass_account¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | uuid | false | (DC2Type:uuid) | |||
| created_at | timestamp(0) with time zone | false | (DC2Type:datetimetz_immutable) | |||
| is_linked | boolean | false | false | |||
| linked_at | timestamp(0) with time zone | NULL::timestamp with time zone | true | (DC2Type:datetimetz_immutable) | ||
| member_account_id | varchar(255) | NULL::character varying | true | |||
| owner_id | uuid | false | public.user | (DC2Type:uuid) | ||
| linked_with_email_address | varchar(255) | true | ||||
| user_group_member_id | uuid | true | public.member | (DC2Type:uuid) |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| fk_80e0e7c77e3c61f9 | FOREIGN KEY | FOREIGN KEY (owner_id) REFERENCES "user"(id) |
| fk_80e0e7c7a7f8e390 | FOREIGN KEY | FOREIGN KEY (user_group_member_id) REFERENCES member(id) |
| wellpass_account_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| wellpass_account_pkey | CREATE UNIQUE INDEX wellpass_account_pkey ON public.wellpass_account USING btree (id) |
| idx_80e0e7c77e3c61f9 | CREATE INDEX idx_80e0e7c77e3c61f9 ON public.wellpass_account USING btree (owner_id) |
| uniq_80e0e7c7a7f8e390 | CREATE UNIQUE INDEX uniq_80e0e7c7a7f8e390 ON public.wellpass_account USING btree (user_group_member_id) |
Relations¶
Generated by tbls