반응형
CREATE TABLE movies
movie_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
title TEXT UNIQUE NOT NULL,
released INTEGER NOT NULL CHECK (released > 1900),
overview TEXT NOT NULL CHECK (LENGTH(overview) <= 100),
rating REAL NOT NULL CHECK (rating BETWEEN 0 AND 10),
director TEXT,
for_kids INTEGER NOT NULL DEFAULT 0 CHECK (for_kids BETWEEN 0 AND 1)
-- poster BLOB
) STRICT;
반응형
'Database' 카테고리의 다른 글
윈도우 sqlite 설치 (0) | 2025.05.16 |
---|---|
[MySQL] 테이블 분할 & 분석(PARTITION BY) (0) | 2023.11.25 |
[오라클DB] PL/SQL 프로시저 반복문 - 0329 2교시 (0) | 2023.03.29 |
[오라클DB] 프로시저 복습문제 - 0329 1교시 (0) | 2023.03.29 |
[DB] SQL 기본 (0) | 2023.03.29 |