project practice

Tables (5)

Subscribe (subscribe)

  • Subscribe_ID (subscribe) — Primary key — NOT NULL
  • Year_month (year_month)
  • User_ID (user) — Foreign key → User.User_ID — NOT NULL

Product (product)

  • Product_ID (product) — Primary key — NOT NULL
  • Product_name (name)

Subscribe_ID (Prodcut_ID)

  • Subscribe_ID (product_ID) — Primary key — NOT NULL
  • Subscribe_ID (subscribe) — Foreign key → Subscribe.Subscribe_ID — NOT NULL
  • Product_ID (product2) — Foreign key → Product.Product_ID — NOT NULL

User (user)

  • User_ID (user) — Primary key — NOT NULL
  • Subscribe_ID (subscribe)

User_Profile (profile)

  • User_ID (user) — Primary key — NOT NULL
  • User_email (email)
  • User_Password (password)
  • User_Nickname (nickname)
  • User_Phone (phone)
  • User_ID (user2) — Foreign key → User.User_ID — NOT NULL