In this video I take a look at the structure of tables I plan on using for my database and point on the relational links between the tables. I also discuss the primary key of the table as well as using it as a foreign key in a related table. I take a look at a few basic data types for field columns to include:
CHAR = 255 characters
VARCHAR = 255 characters
SMALLINT = -32,768 to 32,767
INT = -2,147,483,648 to 2,147,483,647
DECIMAL = Numbers with a decimal value
Date = In the format DD-MMM-YYYY
This video is part of a series of videos with the purpose of learning the SQL language. For more information visit Lecture Snippets at http://lecturesnippets.com.
