1create_table("identity_verification_tokens") {
2 t.Column("id", "uuid", {primary: true})
3
4 t.Column("token", "string", {"size": 64})
5 t.Column("used", "bool", {"default": false})
6 t.Column("used_at", "timestamp", {"null": true})
7 t.Column("expires_at", "timestamp")
8 t.Column("issued_at", "timestamp")
9
10 t.Column("identity_verifiable_address_id", "uuid")
11 t.ForeignKey("identity_verifiable_address_id", {"identity_verifiable_addresses": ["id"]}, {"on_delete": "cascade"})
12
13 t.Column("selfservice_verification_flow_id", "uuid", {"null": true})
14 t.ForeignKey("selfservice_verification_flow_id", {"selfservice_verification_flows": ["id"]}, {"on_delete": "cascade"})
15}
16
17add_index("identity_verification_tokens", ["token"], { "unique": true, "name": "identity_verification_tokens_token_uq_idx" })
18add_index("identity_verification_tokens", ["token"], { "name": "identity_verification_tokens_token_idx" })
19
20add_index("identity_verification_tokens", ["identity_verifiable_address_id"], { "name": "identity_verification_tokens_verifiable_address_id_idx" })
21add_index("identity_verification_tokens", ["selfservice_verification_flow_id"], { "name": "identity_verification_tokens_verification_flow_id_idx" })
View as plain text