smsCodeTb

Table actions Table actions

2 rows

✎ View and edit SQL

This data as json, CSV (advanced)

phone ▼ code expires last_sent
13424452443 340026 1779288441.5564346 1779288141.5564346
13900000001 975242 1779287266.5710738 1779286966.5710738

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE smsCodeTb (
                phone TEXT PRIMARY KEY,
                code TEXT NOT NULL,
                expires REAL NOT NULL,
                last_sent REAL NOT NULL
            );
CREATE INDEX idx_sms_expires ON smsCodeTb(expires);