NIKESHOE
Tables (12)
Untitled (user)
- Key (user_id(INT)) — Primary key — NOT NULL
- Field (user_name)
- Field2 (email)
- Field3 (phone_num)
Untitled (general_user)
- Key (g_user_id(INT)) — Primary key — NOT NULL
- Key (user_id(INT)) — Foreign key → Untitled.Key — NOT NULL
- Field2 (favorite_shipping_address)
- Field3 (my_card_num)
- Field4 (my_bank_account)
Untitled (wish)
- Key (wish_id(INT)) — Primary key — NOT NULL
- Key (g_user_id(INT)2) — Foreign key → Untitled.Key — NOT NULL
- Key (model_id(INT)2) — Foreign key → Untitled.Key — NOT NULL
- Field2 (model_id(INT))
- Field3 (expected_replenishment_date)
- Field (wish_at)
- Field
Untitled (sneaker)
- Key (model_id(INT)) — Primary key — NOT NULL
- Field (price)
Untitled (sneaker_traits)
- Key (trait_id) — Primary key — NOT NULL
- Field (description)
- Field2 (english_desc)
Untitled (abroad_inventory)
- Key (model_id(INT)) — Primary key — NOT NULL
- Key (model_id(INT)2) — Foreign key → Untitled.Key — NOT NULL
- Field (stock)
- Field (expected_delivered_day)
Untitled2 (admin_user)
- Key (admin_id(INT)) — Primary key — NOT NULL
- Key (user_id(INT)) — Foreign key → Untitled.Key — NOT NULL
Untitled2 (payment)
- Key (payment_id(INT)) — Primary key — NOT NULL
- Key (g_user_id(INT)2) — Foreign key → Untitled.Key — NOT NULL
- Key (user_id(INT)22) — Foreign key → Untitled.Key — NOT NULL
- Field (g_user_id(INT))
- Field2 (order_id)
- Field3 (type)
- Field (pay_at)
- Field
Untitled2 (sneaker_model_traits)
- Key (model_trait_id(INT)) — Primary key — NOT NULL
- Key (model_id(INT)) — Foreign key → Untitled.Key — NOT NULL
- Key (trait_id2) — Foreign key → Untitled.Key — NOT NULL
Untitled3 (orders)
- Key (order_id(INT)) — Primary key — NOT NULL
- Key (g_user_id(INT)2) — Foreign key → Untitled.Key — NOT NULL
- Key (user_id(INT)22) — Foreign key → Untitled.Key — NOT NULL
- Key (model_id(INT)2) — Foreign key → Untitled.Key — NOT NULL
- Field (g_user_id(INT))
- Field2 (model_id(INT))
- Field3 (sneaker_size)
- Field4 (shipping_address)
- Field5 (total_price)
- Field6 (order_status)
- Field7 (order_at)
- Field
Untitled3 (korea_inventory)
- Key (model_id(INT)) — Primary key — NOT NULL
- Key (model_id(INT)2) — Foreign key → Untitled.Key — NOT NULL
- Field (stock)
Untitled4 (shipping)
- Key (shipping_id(INT)) — Primary key — NOT NULL
- Key (model_id(INT)) — Foreign key → Untitled.Key — NOT NULL
- Key (admin_id(INT)2) — Foreign key → Untitled2.Key — NOT NULL
- Key (payment_id(INT)) — Foreign key → Untitled2.Key — NOT NULL
- Key (g_user_id(INT)2) — Foreign key → Untitled2.Key — NOT NULL
- Key (user_id(INT)22) — Foreign key → Untitled2.Key — NOT NULL
- Field (admin_id(INT))
- Field3 (order_id(INT))
- Field4 (shipping_address)
- Field5 (shipping_at)