tweets

✎ View and edit SQL

This data as json

0 records

CREATE TABLE [tweets] (
   [id] INTEGER PRIMARY KEY,
   [user] INTEGER REFERENCES [users]([id]),
   [created_at] TEXT,
   [full_text] TEXT,
   [retweeted_status] INTEGER,
   [quoted_status] INTEGER,
   [place] TEXT REFERENCES [places]([id]),
   [source] TEXT REFERENCES [sources]([id]),
   FOREIGN KEY(retweeted_status) REFERENCES tweets(id),
   FOREIGN KEY(quoted_status) REFERENCES tweets(id)
);