public.member¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | uuid | false | public.wellpass_account | Unique identifier for the membership record(DC2Type:uuid) | ||
| group_id | uuid | false | public.user_group | Reference to the user group this membership belongs to. Required for all memberships.(DC2Type:uuid) | ||
| user_id | uuid | true | public.user | Reference to the user account. Null if member was invited but has not registered yet.(DC2Type:uuid) | ||
| created_at | timestamp(0) with time zone | false | Timestamp when the membership was created. Used for membership duration tracking and billing period calculations.(DC2Type:datetimetz_immutable) | |||
| email_address | varchar(255) | NULL::character varying | true | Email address of the member. Used for inviting users who may not have accounts yet. Unique per group. | ||
| status | varchar(255) | false | Membership status: PREPARED (pending confirmation) or CONFIRMED (active membership). Used to track membership lifecycle. | |||
| added_by_id | uuid | true | public.user | Reference to the user who added this member to the group. Used for audit and accountability purposes.(DC2Type:uuid) |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| fk_70e4fa7855b127a4 | FOREIGN KEY | FOREIGN KEY (added_by_id) REFERENCES "user"(id) |
| fk_70e4fa78a76ed395 | FOREIGN KEY | FOREIGN KEY (user_id) REFERENCES "user"(id) |
| fk_70e4fa78fe54d947 | FOREIGN KEY | FOREIGN KEY (group_id) REFERENCES user_group(id) |
| member_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| member_pkey | CREATE UNIQUE INDEX member_pkey ON public.member USING btree (id) |
| idx_70e4fa78fe54d947 | CREATE INDEX idx_70e4fa78fe54d947 ON public.member USING btree (group_id) |
| idx_70e4fa78a76ed395 | CREATE INDEX idx_70e4fa78a76ed395 ON public.member USING btree (user_id) |
| uniq_70e4fa78a76ed395fe54d947 | CREATE UNIQUE INDEX uniq_70e4fa78a76ed395fe54d947 ON public.member USING btree (user_id, group_id) |
| uniq_70e4fa78b08e074efe54d947 | CREATE UNIQUE INDEX uniq_70e4fa78b08e074efe54d947 ON public.member USING btree (email_address, group_id) |
| idx_70e4fa7855b127a4 | CREATE INDEX idx_70e4fa7855b127a4 ON public.member USING btree (added_by_id) |
Relations¶
Generated by tbls