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)