Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0613· OpenAIAi2 WildChat-4.8M (AI2)

Change model to sql const adlaunchSchema: Schema = new mongoose.Schema<IAdlaunch>( {…

  1. User

    Change model to sql

    const adlaunchSchema: Schema = new mongoose.Schema( { campaignName: { type: String }, adsManagerLink: { type: String }, eventType: { type: Schema.Types.ObjectId, ref: "AirTable_EventTypes" }, campaignLaunchTemplates: [ { type: Schema.Types.ObjectId, ref: "AirTable_CampaignLaunchTemplate" }, ], geo: [{ type: Schema.Types.ObjectId, ref: "AirTable_Geo" }], languages: { type: [String] }, adGroupBudget: { type: Number }, campaignBudget: { type: Number }, startingBid: { type: Number }, bidIncrement: { type: Number }, status: { type: Boolean }, adText: { type: [String] }, url: { type: String }, creatives: [{ type: Schema.Types.ObjectId, ref: "document" }], startingRoasValue: { type: Number }, roasValueIncrements: { type: Number }, created: { type: String }, dayParting: { type: Schema.Types.ObjectId, ref: "AirTable_DayParting" }, specialIndustries: { type: [String] }, pixelId: { type: Schema.Types.ObjectId, ref: "AirTable_Pixel" }, optimizationEvent: { type: [String] }, identityId: { type: Schema.Types.ObjectId, ref: "AirTable_Identity" }, callToActions: [ { type: Schema.Types.ObjectId, ref: "AirTable_CallToAction" }, ], adAccountId: { type: Schema.Types.ObjectId, ref: "AirTable_AdAccount" }, stateGroup: [{ type: Schema.Types.ObjectId, ref: "AirTable_StateGroup" }], locationIdsState: { type: [String] }, dayPartingPresetting: { type: [String] }, createdBy: { email: { type: String }, name: { type: String }, }, automationId: { type: Number }, airTableId: { type: String }, launchType: { type: String, enum: ["facebook", "tiktok"] }, description: { type: [String] }, headlines: { type: [String] }, campaignObjective: { type: String }, placementType: { type: String }, facebookPositions: { type: [String] }, instagramPositions: { type: [String] }, attributionSpec: { type: Schema.Types.ObjectId, ref: "AirTable_AttributionSetting", }, displayLink: { type: String }, standardEnhancement: { type: Boolean }, creativeJson: { type: String }, campaignBidCap: { type: Number }, }, { timestamps: true }, );

  2. Assistant

    CREATE TABLE adlaunch ( id INT PRIMARY KEY AUTO_INCREMENT, campaignName VARCHAR(255), adsManagerLink VARCHAR(255), eventType INT, campaignLaunchTemplates INT, geo INT, languages VARCHAR(255), adGroupBudget FLOAT, campaignBudget FLOAT, startingBid FLOAT, bidIncrement FLOAT, status BOOLEAN, adText VARCHAR(255), url VARCHAR(255), creatives INT, startingRoasValue FLOAT, roasValueIncrements FLOAT, created VARCHAR(255), dayParting INT, specialIndustries VARCHAR(255), pixelId INT, optimizationEvent VARCHAR(255), identityId INT, callToActions INT, adAccountId INT, stateGroup INT, locationIdsState VARCHAR(255), dayPartingPresetting VARCHAR(255), email VARCHAR(255), name VARCHAR(255), automationId INT, airTableId VARCHAR(255), launchType ENUM('facebook', 'tiktok'), description VARCHAR(255), headlines VARCHAR(255), campaignObjective VARCHAR(255), placementType VARCHAR(255), facebookPositions VARCHAR(255), instagramPositions VARCHAR(255), attributionSpec INT, displayLink VARCHAR(255), standardEnhancement BOOLEAN, creativeJson VARCHAR(255), campaignBidCap FLOAT, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP );

  3. User

    const AirTableAdAccountSchema: Schema = new Schema( { accountName: { type: String }, accountId: { type: String }, credentialIdentifier: { type: String }, airTableId: { type: String }, type: { type: String, enum: ["facebook", "tiktok"] }, }, { timestamps: true }, );

    Change to postgres schema

  4. Assistant

    CREATE TABLE airtable_adaccount ( id SERIAL PRIMARY KEY, accountName VARCHAR(255), accountId VARCHAR(255), credentialIdentifier VARCHAR(255), airTableId VARCHAR(255), type VARCHAR(255) CHECK (type IN ('facebook', 'tiktok')), created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP );