Post4U (LowCodeHackaton)

Tables (3)

brand_analysis

  • id — BIGINT
  • brand_name — VARCHAR(255) — NOT NULL
  • brand_description — TEXT — NOT NULL
  • target_audience — TEXT — NOT NULL
  • core_message — TEXT — NOT NULL
  • tone_adjectives — JSON — NOT NULL
  • frequent_expressions — JSON — NOT NULL
  • forbidden_expressions — JSON — NOT NULL
  • emoji_rule — TEXT — NOT NULL
  • sentence_length_rule — TEXT — NOT NULL
  • source_summary — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

posts

  • id — BIGINT
  • platform — VARCHAR(30) — NOT NULL
  • brand_name — VARCHAR(100) — NOT NULL
  • post_date — DATE — NOT NULL
  • body — TEXT — NOT NULL
  • hashtags — JSON
  • image_url — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME

temp_posts

  • id — BIGINT
  • platform — VARCHAR(30) — NOT NULL
  • brand_name — VARCHAR(100) — NOT NULL
  • post_date — DATE — NOT NULL
  • body — TEXT — NOT NULL
  • hashtags — JSON
  • image_url — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME