Table structures for PHP projects 9-10

note: attribute or column types are in parenthesis

Table name
attribute
attribute attribute attribute attribute attribute attribute
automobile
make( varchar)
model (varchar)
category (varchar)
vin (varchar)



Contract
contract_id (varhcar)
contract_amount (varchar)
theater_id (varchar)
production_comp (varchar)



Critic
critic_id (int)
critic_name (varchar)
vin (varcahr)
age (int)
sex (varchar)
marital_status (varhcar)
education_level (varchar)
movierating
critic_id (varchar)
movie_id (varchar)
type (varchar)
rating (varcahr)



Movies
title (varchar)
producer (varchar)
director (varchar)
production_company_id (varchar)
budget (decimal)
id_no (varchar)

production_ company
company_name (varchar)
company_id (varchar)
gross_revenues (varchar)
principal_owner (varchar)
city (varchar)
state (varchar)

theater
theater_name (varchar)
theater_id (varchar)
City (varchar)
 State (varchar)
Zip (varchar)


make sure  table names and attributes follow case sensitivity!
The database is a MySQL database named movies and it is on the server gwiggins-old.mc.edu.