러닝 SQL: 데이터 생성, 검색, 조작까지 데이터 제대로 주무르기

414

러닝 SQL

address

address_id SMALLINT(5)

address VARCHAR(50)

address2 VARCHAR(50)

district VARCHAR(20)

city_id SMALLINT(5)

postal_code VARCHAR(10)

phone VARCHAR(20)

location GEOMETRY

last_update TIMESTAMP

rental

rental_id INT(11)

rental_date DATETIME

inventory_id MEDIUMINT(8)

customer_id SMALLINT(5)

return_date DATETIME

last_update TIMESTAMP

actor

actor_id SMALLINT(5)

last_name VARCHAR(45)

last_update TIMESTAMP

inventory

inventory_id MEDIUMINT(8)

last_update TIMESTAMP

payment

payment_id SMALLINT(5)

customer_id SMALLINT(5)

rental_id INT(11)

amount DECIMAL (5,2)

payment_date DATETIME

last_update TIMESTAMP

customer

customer_id SMALLINT(5)

last_name VARCHAR(45)

first_name VARCHAR(45) ...