Skip to content

Instantly share code, notes, and snippets.

@jugaldb
Created August 24, 2022 10:00
Show Gist options
  • Save jugaldb/c8b26910c0f87b7f33e85015db44cdf2 to your computer and use it in GitHub Desktop.
Save jugaldb/c8b26910c0f87b7f33e85015db44cdf2 to your computer and use it in GitHub Desktop.
Create table script for Fampay task
CREATE TABLE IF NOT EXISTS "videos" ("video_id" VARCHAR(255) , "name" VARCHAR(255), "published_at" VARCHAR(255), "thumbnail_url" VARCHAR(255), "channel_id" VARCHAR(255), "description" VARCHAR(255), "channel_name" VARCHAR(255), "created_date" TIMESTAMP WITH TIME ZONE, "search_doc_weights" tsvector, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, PRIMARY KEY ("video_id"));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment