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)