To understand the keyword, we must break it down into its three constituent parts:
CREATE TABLE pins ( id UUID PRIMARY KEY, user_id UUID REFERENCES users(id), lat DOUBLE PRECISION NOT NULL, lng DOUBLE PRECISION NOT NULL, created_at TIMESTAMP DEFAULT now(), media_url TEXT NOT NULL, caption TEXT, likes INT DEFAULT 0, comments INT DEFAULT 0, visibility ENUM('public','friends','private') DEFAULT 'public' ); www yukikax 146