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