Database

sqlite DDL create문

웨일파도 2025. 5. 16. 16:58
반응형
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;

 

반응형