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