BM

Tables (7)

Album (Artist)

  • Key (artist_id) — Primary key — NOT NULL
  • Field (artist_name) — NOT NULL
  • Field (age) — NOT NULL
  • Field (gender) — NOT NULL
  • Field (article_id)

Customer

  • customer_id — Primary key — NOT NULL
  • customer_name — NOT NULL
  • id (ID) — NOT NULL
  • password — NOT NULL
  • social_security_number — NOT NULL
  • address — NOT NULL
  • phone_number — NOT NULL
  • birthday — NOT NULL
  • occupation
  • wedding_anniversary
  • default_payment_method — NOT NULL
  • registration_date (registrationd_date) — NOT NULL
  • email_address — NOT NULL

Order (Album)

  • order_id (album_id) — Primary key — NOT NULL
  • Field (artist_id) — NOT NULL
  • order_date (album_title) — NOT NULL
  • total_purchase_price (label) — NOT NULL
  • payment_method (release_date) — NOT NULL
  • delivery (category) — NOT NULL
  • Field (inventory) — NOT NULL
  • Field6 (prime_cost) — NOT NULL
  • Field (sales_price) — NOT NULL

Untitled (Order)

  • Key (order_id) — Primary key — NOT NULL
  • customer_id — Foreign key → Customer.customer_id — NOT NULL
  • Field (order_date) — NOT NULL
  • Field (total_purchase_price) — NOT NULL
  • Field (payment_method) — NOT NULL
  • Field (delivery) — NOT NULL

Untitled (Article)

  • Field (article_id) — Primary key — NOT NULL
  • Key (artist_id) — Foreign key → Album.Key — NOT NULL
  • Field (type) — NOT NULL
  • Field (article_title) — NOT NULL
  • Field (publish_date) — NOT NULL
  • Field (content) — NOT NULL

Untitled (Artist_Album)

  • order_id (album_id) — Foreign key → Order.order_id — NOT NULL
  • Key (artist_id) — Foreign key → Album.Key — NOT NULL

Untitled (Order_detail)

  • Key (order_detail_id) — Primary key — NOT NULL
  • Key (order_id) — Foreign key → Untitled.Key — NOT NULL
  • order_id (album_id) — Foreign key → Order.order_id — NOT NULL
  • Field (quantity) — NOT NULL