SNS management

Tables (7)

Instagram Configuration (instagramConfig)

  • ID (id) — INT — Primary key — NOT NULL
  • Meta Business Account (metaBusinessAccessAccount)
  • enableAutoPost — BOOLEAN
  • Target Post Type (targetPostType) — ENUM — feed , reels, story
  • AlertBy (alertBy) — ENUM — message, email, kakaoTalk

Instagram Feed (instagramFeed)

  • ID (id) — INT — Primary key — NOT NULL
  • Instagram Post Infomation (instagramPostInfo) — INT — Foreign key → Instagram Post Infomation.ID — NOT NULL
  • Contents (contents) — STRING
  • Tags (tags) — STRING
  • Instagram Post Container (instagramPostContainer) — INT

Instagram Post Container (CopyOfinstagramFeed)

  • ID (id) — INT — Primary key — NOT NULL
  • Instagram Feed (instagramFeed) — INT — Foreign key → Instagram Feed.ID — NOT NULL
  • Instagram Reels (instagramReels) — INT — Foreign key → Instagram Reels.ID — NOT NULL
  • Instagram Story (instagramStory) — INT — Foreign key → Instagram Story.ID — NOT NULL
  • media — FILE — NOT NULL
  • fileSize — LONG
  • url — STRING

Instagram Post Infomation (instagramPostInfo)

  • ID (id) — INT — Primary key — NOT NULL
  • metaBusinessAccessAccount — INT — Foreign key → Meta Business Account.ID — NOT NULL
  • Post Type (postType) — ENUM — feed , reels, story
  • Publish Type (publishType) — ENUM — immediate, scheduled
  • Title (title) — STRING
  • Instagram Feed (instagramFeed) — INT
  • Instagram Reels (instagramReels) — INT
  • Instagram Story (instagramStory) — INT
  • Thumbnail (thumbnail) — IMAGE
  • Post Status (postStatus) — ENUM — pending, success, fail
  • ScheduledAt (scheduledAt) — DATE

Instagram Reels (instagramReels)

  • ID (id) — INT — Primary key — NOT NULL
  • Instagram Post Infomation (instagramPostInfo) — INT — Foreign key → Instagram Post Infomation.ID — NOT NULL
  • Contents (contents) — STRING
  • Tags (tags) — STRING
  • Instagram Post Container (instagramPostContainer) — INT

Instagram Story (instagramStory)

  • ID (id) — INT — Primary key — NOT NULL
  • Instagram Post Infomation (instagramPostInfo) — INT — Foreign key → Instagram Post Infomation.ID — NOT NULL
  • Contents (contents) — STRING
  • Tags (tags) — STRING
  • Instagram Post Container (instagramPostContainer) — INT

Meta Business Account (metaBusinessAccessAccount)

  • ID (id) — INT — Primary key — NOT NULL
  • Instagram Configuration (instagramConfig) — INT — Foreign key → Instagram Configuration.ID — NOT NULL
  • User Id (userId) — STRING
  • Page Id (pageId) — INT
  • Instagram Id (instagramId) — INT
  • Instagram Post Infomation (instagramPostInfo) — INT
  • Longterm Access Token (accessToken) — STRING
  • Token Expired Date (tokenExpiredDate) — DATE