movie_erd
Tables (3)
DVD (Untitled2)
- movie_num (Key) — Primary key — NOT NULL
- movie_name (Field)
- nation (Field2)
- pubyear (Field3)
- rent_price (Field4)
- rent (Field5)
- rent_user (Field6)
- user_num (Key2) — Foreign key → USER.user_num — NOT NULL
ORDER (Untitled3)
- movie_num (Key) — Primary key — NOT NULL
- movie_name (Field)
- user_name (Field2)
- user_phone_num (Field3)
- rent_date (Field4)
- return_date (Field5)
- over_due_day (Field6)
- overdue_charge (Field7)
USER (Untitled)
- user_num (Key) — Primary key — NOT NULL
- user_name (Field)
- user_phone_num (Field2)
- user_grade (Field3)
- total_price (Field4)
- rent_list (Field5)