CREATE TYPE "public"."file_source" AS ENUM('pas hub', 'sharepoint', 'hubspot');--> statement-breakpoint
CREATE TYPE "public"."file_type" AS ENUM('photo_pack', 'site_note', 'rd_sap_site_note', 'pas_2023_ventilation', 'pas_2023_condition', 'pas_significance', 'par_photo_pack', 'pas_2023_property', 'pas_2023_occupancy');--> statement-breakpoint
CREATE TABLE "uploaded_files" (
	"id" bigserial PRIMARY KEY NOT NULL,
	"s3_file_bucket" text NOT NULL,
	"s3_file_key" text NOT NULL,
	"s3_upload_timestamp" timestamp with time zone NOT NULL,
	"landlord_property_id" text,
	"uprn" bigint,
	"hubspot_listing_id" bigint,
	"file_type" "file_type",
	"file_source" "file_source"
);
