Difference between revisions of "Template:JOIN tables 2"

From SQLZOO
Jump to navigation Jump to search
(Created page with "<div class='db_ref' style='background:none'> <table class="zoo"> <caption>movie</caption> <tr> <th>Field name</th> <th>Type</th> <th>Notes</th> ...")
 
 
Line 1: Line 1:
<div class='db_ref' style='background:none'>
+
 
<table class="zoo">
+
<div class='ref_section' style='background:none'>
 +
<table class="db_ref">
 
   <caption>movie</caption>
 
   <caption>movie</caption>
 
     <tr>
 
     <tr>
Line 45: Line 46:
 
</table>
 
</table>
  
<table class="zoo">
+
<table class="db_ref">
 
   <caption>actor</caption>
 
   <caption>actor</caption>
 
     <tr>
 
     <tr>
Line 73: Line 74:
 
</table>
 
</table>
  
<table class="zoo">
+
<table class="db_ref">
 
   <caption>casting</caption>
 
   <caption>casting</caption>
 
     <tr>
 
     <tr>

Latest revision as of 08:50, 6 August 2012

movie
Field name Type Notes
id INTEGER An arbitrary unique identifier
title CHAR(70) The name of the film - usually in the language of the first release.
yr DECIMAL(4) Year of first release.
director INT A reference to the actor table.
budget INTEGER How much the movie cost to make (in a variety of currencies unfortunately).
gross INTEGER How much the movie made at the box office.
actor
Field name Type Notes
id INTEGER An arbitrary unique identifier
name CHAR(36) The name of the actor (the term actor is used to refer to both male and female thesps.)
casting
Field name Type Notes
movieid INTEGER A reference to the movie table.
actorid INTEGER A reference to the actor table.
ord INTEGER The ordinal position of the actor in the cast list. The

star of the movie will have ord value 1 the co-star will have

value 2, ...