Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('okr.temporary_registrations_id_seq'::regclass) |
|
|
||
| confirmation_token | varchar | 255 | null |
|
|
|||
| confirmation_sent_at | timestamptz | 35,6 | null |
|
|
|||
| varchar | 255 | null |
|
|
||||
| is_trial_account | bool | 1 | false |
|
|
|||
| is_self_serve | bool | 1 | false |
|
|
セルフサーブのTemporaryRegistrationかどうか |
||
| trial_expires_at | timestamptz | 35,6 | √ | null |
|
|
セルフサーブ期間の有効期限 |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| temporary_registrations_pkey | Primary key | Asc | id |
| idx_temporary_registrations_on_confirmation_token | Must be unique | Asc | confirmation_token |
| idx_temporary_registrations_on_email | Must be unique | Asc | |
| idx_temporary_registrations_on_is_self_serve | Performance | Asc | is_self_serve |
| idx_temporary_registrations_on_trial_expires_at | Performance | Asc | trial_expires_at |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| check_self_serve_or_trial | ((NOT ((is_trial_account IS TRUE) AND (is_self_serve IS TRUE)))) |
Diagram producer might be missing
No diagrams were produced please see application output for any errors