TEST

Tables (15)

Chapters

  • id — INT
  • chapter_number — INT
  • title — VARCHAR(255)

Copywriting_Techniques

  • id — INT
  • category — VARCHAR(100)
  • technique_name — VARCHAR(100)
  • description — TEXT

Core_Concepts

  • id — INT
  • name — VARCHAR(50)
  • metaphorical_role — VARCHAR(100)
  • copywriting_application — VARCHAR(255)
  • description — TEXT

Customer_Personas

  • id — INT
  • persona_name — VARCHAR(255)
  • description — TEXT
  • example_product_id — INT

E_Commerce_Platforms

  • id — INT
  • platform_name — VARCHAR(100)
  • policy_summary — TEXT

Example_Copies

  • id — INT
  • copy_text — TEXT
  • context — TEXT
  • related_technique_id — INT
  • target_persona_id — INT
  • example_product_id — INT

Example_Products

  • id — INT
  • product_name — VARCHAR(100)
  • category — VARCHAR(100)
  • features — TEXT

Lectures

  • id — INT
  • chapter_id — INT
  • lecture_code — VARCHAR(50)
  • title — VARCHAR(255)
  • full_transcript — TEXT

Lectures_Example_Copies

  • lecture_id — INT
  • example_copy_id — INT

Lectures_Techniques

  • lecture_id — INT
  • technique_id — INT

Product_Page_Components

  • id — INT
  • component_name — VARCHAR(50)
  • description — TEXT

Product_Page_Structure

  • id — INT
  • element_name — VARCHAR(50)
  • analogy — VARCHAR(100)
  • purpose — TEXT
  • primary_components — VARCHAR(255)

Product_Page_Types

  • id — INT
  • type_name — VARCHAR(50)
  • core_message — VARCHAR(255)
  • description — TEXT
  • suitable_for — TEXT

Recommended_Resources

  • id — INT
  • title — VARCHAR(255)
  • author — VARCHAR(100)
  • summary — TEXT

Structure_Components

  • structure_id — INT
  • component_id — INT