Criação da Account_Bling

mail@pastecode.io avatar
unknown
sql
21 days ago
903 B
2
Indexable
Never
-- public."Account_Bling" definition

-- Drop table

-- DROP TABLE public."Account_Bling";

CREATE TABLE public."Account_Bling" (
	id text NOT NULL,
	"type" text NOT NULL,
	provider text NOT NULL,
	refresh_token text NULL,
	access_token text NULL,
	expires_at int4 NULL,
	token_type text NULL,
	"scope" text NULL,
	id_token text NULL,
	session_state text NULL,
	"providerAccountId" text NOT NULL,
	"userId" text NOT NULL,
	last_bling_update timestamp(3) NULL,
	bling_user_id text NULL,
	CONSTRAINT "AccountBling_pkey" null
);
CREATE UNIQUE INDEX "AccountBling_provider_providerAccountId_key" ON public."Account_Bling" (provider text_ops,"providerAccountId" text_ops);


-- public."Account_Bling" foreign keys

ALTER TABLE public."Account_Bling" ADD CONSTRAINT "AccountBling_userId_fkey" FOREIGN KEY ("userId") REFERENCES public."User"(id) ON DELETE CASCADE ON UPDATE CASCADE;
Leave a Comment