title: Flask Alchemy how do I create formatted email column or a column to hold paragraphs for a biography
body: <p>I am trying to expand a database table from a tutorial. I'm using sqlalchemy in a flask application.</p>
  
  <p>I would like to be able to add all of the columns my little heart desires but at the very least I would like to know if there is a correct way to add:</p>
  
  <ol>
  <li>a column to hold a website url</li>
  <li>a column to hold paragraphs as paragraphs, so probably html but nothing crazy. No links or lists.</li>
  </ol>
  
  <p>Normally I can find anything on google but I've spent hours across two days playing with this and resources are scares. I can't find a list of available columns, column attributes, best practices, or any solid documentation. I've done the same forum tutorial 12 different ways though and none of them go beyond the basic profile information. Any resource you could include would be helpful.</p>
  
  <p>python:</p>
  
  <pre><code>id  = db.Column(db.Integer(20), primary_key=True)
      email = db.Column(db.String(25), unque=True, nullable=False)
      first_name = dbColumn(db.String(20))
      last_name = dbColumn(db.String(20))
      profile_pic = db.Column(db.String(120), unique=True, nullable=False, default='default.jpg')
      bio = db.Column(db.String(500))
  
      password = db.Column(db.String(60), nullable=False)
      community_score = db.Column(db.Integer(3), default=100)
      forum_posts = db.relationship('Post', backref='author', lazy=True)
  </code></pre>