/
admin
sqlite
field
sqlite_sequence
Field name
Type
TEXT
REAL
NUMERIC
INTEGER
BLOB
Null
NOT NULL
Key
PRIMARY KEY
PRIMARY KEY AUTOINCREMENT
UNIQUE
Foreign key
Index name
Default
NULL
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
0
1
Check
salary > 0
LENGTH(column) > 3
Collate
BINARY
NOCASE
RTRIM
sqlite_sequence
cid
name
type
notnull
dflt_value
pk
0
name
0
0
1
seq
0
0