public.transfer_tokens¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | bigint | nextval('transfer_tokens_id_seq'::regclass) | false | |||
| token | varchar(64) | false | ||||
| identity_id | varchar(255) | false | ||||
| expires_at | timestamp without time zone | false | ||||
| used_at | timestamp without time zone | true | ||||
| created_at | timestamp without time zone | CURRENT_TIMESTAMP | false |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| transfer_tokens_created_at_not_null | n | NOT NULL created_at |
| transfer_tokens_expires_at_not_null | n | NOT NULL expires_at |
| transfer_tokens_id_not_null | n | NOT NULL id |
| transfer_tokens_identity_id_not_null | n | NOT NULL identity_id |
| transfer_tokens_token_not_null | n | NOT NULL token |
| transfer_tokens_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| transfer_tokens_token_key | UNIQUE | UNIQUE (token) |
Indexes¶
| Name | Definition |
|---|---|
| transfer_tokens_pkey | CREATE UNIQUE INDEX transfer_tokens_pkey ON public.transfer_tokens USING btree (id) |
| transfer_tokens_token_key | CREATE UNIQUE INDEX transfer_tokens_token_key ON public.transfer_tokens USING btree (token) |
| idx_transfer_tokens_token | CREATE INDEX idx_transfer_tokens_token ON public.transfer_tokens USING btree (token) |
Relations¶
Generated by tbls