Common Data Types

• INTEGER / REAL
• TEXT/VARCHAR(n)
• DATE / TIME / TIMESTAMP
• BOOLEAN
• NULL
• BLOB

用法

CREATE TABLE users (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  email VARCHAR(100),
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);