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