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)