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