create table article - Githubissues

code-mates / blog

First project from code-mates meetup group

Apache License 2.0

1 stars 0 forks source link

create table article #3

Open ghost opened 7 years ago

ghost commented 7 years ago

create table article

cm_blog-3-vb

create a table in the cm_blog database called article

each article will have

article_id
author_user_id
title
body
publish_date

Each column should have its own data type. Research which mysql data type should be used for each column and present your findings.

that there are many strategies for handling whitespace and text formatting. Describe at least 2 and pick a data type for the body column.
dates are also complicated. ISO 8601 is not. Always include the full date and time with time zone in any column pertaining to a point in time.

add your code to the schema.sql file