market_kurly

Tables (7)

admin_user (Untitled)

  • application_record (Key) — Primary key — NOT NULL
  • log_data (Field)

cart (Untitled2)

  • user_id (Key) — Primary key — NOT NULL
  • product_id (Key3) — Primary key — NOT NULL
  • order_id (Key2) — Primary key — NOT NULL
  • cart_id (Key4) — Primary key — NOT NULL
  • total_price (Field)
  • total_quantity (Field2)

order (Untitled3)

  • credit_id (Key) — Primary key — NOT NULL
  • product_id (Key2) — Primary key — NOT NULL
  • user_id (Key3) — Primary key — NOT NULL
  • order_id (Key5) — Primary key — NOT NULL
  • user_id (primary) — Foreign key → user.user_id — NOT NULL
  • cart_id (Key4) — Foreign key → user.cart_id — NOT NULL
  • product_id (Key22) — Foreign key → user.product_id — NOT NULL
  • order_id (Key32) — Foreign key → user.order_id — NOT NULL
  • order_date (Field)
  • quantity (Field2)
  • number_to_currency (Field3)

payment (Untitled5)

  • credit_id (Key) — Primary key — NOT NULL
  • card_title (Field)
  • card_text (Field2)
  • payment information (Field3)
  • payment_date (Field4)

point (Untitled7)

  • point (Key) — Primary key — NOT NULL
  • user_id (Key2) — Primary key — NOT NULL
  • point reason (Field)
  • point_log (Field2)

product (pack)

  • cart_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Primary key — NOT NULL
  • order_id (Key3) — Primary key — NOT NULL
  • product_id (primary) — Primary key — NOT NULL
  • price (Field)
  • product_name (Field3)
  • company (Field2)

user (Untitled4)

  • user_id (primary) — Primary key — NOT NULL
  • cart_id (Key) — Primary key — NOT NULL
  • product_id (Key2) — Primary key — NOT NULL
  • order_id (Key3) — Primary key — NOT NULL
  • user_name (Field)
  • user_num (Field2)
  • user_ address (Field3)