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