2021-10-11-q4
Tables (5)
Actor (tb_actor)
- Actor Code (actor_id) — Primary key — NOT NULL
- DVD Code (dvd_id) — Foreign key → DVD.DVD Code — NOT NULL
Customer (tb_customer)
- Customer Number (customer_id) — Primary key — NOT NULL
- Name (customer_name)
- Address (customer_addr)
DVD (tb_dvd)
- DVD Code (dvd_id) — Primary key — NOT NULL
- Purchase Date (dvd_date)
- Rent Counter (dvd_count)
- Title (dvd_title)
- Release Date (dvd_year)
- Customer Number (customer_id) — Foreign key → Transaction.Customer Number — NOT NULL
Director (tb_director)
- Director Code (director_id) — Primary key — NOT NULL
- DVD Code (dvd_id) — Foreign key → DVD.DVD Code — NOT NULL
Transaction (tb_transaction)
- Customer Number (customer_id) — Foreign key → Customer.Customer Number — NOT NULL
- Rent Date (transaction_date)
- Rent Time (transaction_time)