CREATE TABLE video_files ( file_id BIGSERIAL PRIMARY KEY, video_id BIGINT REFERENCES videos(video_id), resolution VARCHAR(10), -- e.g., 1080p, 720p bitrate_kbps INT, codec VARCHAR(20), -- h264, vp9, av1 url VARCHAR(255) NOT NULL, size_bytes BIGINT );
