market_kruly

Tables (20)

Ad

  • ad_idx — bigint — Primary key — NOT NULL
  • url — text
  • image — text
  • category_idx — bigint — Foreign key → Category.category_idx — NOT NULL

Address

  • address_idx — bigint — Primary key — NOT NULL
  • desc (address_desc) — text
  • default_yn — varchar(2)
  • recevied_name — varchar(20)
  • recevied_phone — varchar(20)
  • user_idx — bigint — Foreign key → User.user_idx — NOT NULL

Brand

  • brand_idx — bigint — Primary key — NOT NULL
  • brand_name — varchar(40)
  • delete_yn — varchar(2)

Cart

  • user_idx — bigint — Foreign key → User.user_idx — NOT NULL
  • product_idx — bigint — Foreign key → Product.product_idx — NOT NULL
  • product_amount — tinyint

CategortProductMapping

  • product_idx — bigint — Foreign key → Product.product_idx — NOT NULL
  • category_idx — bigint — Foreign key → Category.category_idx — NOT NULL

Category

  • category_idx — bigint — Primary key — NOT NULL
  • create_at — timestamp — NOT NULL
  • update_at — timestamp — NOT NULL
  • delete_yn — varchar(2) — NOT NULL
  • name — varchar(40)
  • category_parent — bigint

Coupon

  • coupon_idx — bigint — Primary key — NOT NULL
  • name (coupon_name) — varchar(40) — NOT NULL
  • allowable_price — int
  • specific_yn — varchar(2)
  • start_time — timestamp
  • end_time — timestamp
  • codition — varchar(100)

Favorite

  • product_idx — bigint — Foreign key → Product.product_idx — NOT NULL
  • user_idx — bigint — Foreign key → User.user_idx — NOT NULL
  • create_at — timestamp
  • update_at — timestamp
  • delete_yn — varchar(2)

Order

  • order_idx — bigint — Primary key — NOT NULL
  • product_price — int
  • delivery_fee — varchar(20)
  • product_discount — int
  • coupon_discount — int
  • use_point — int
  • final_fee (payment_fee) — bigint
  • earn point — int
  • pay_method — varchar(20)
  • user_idx — bigint — Foreign key → User.user_idx — NOT NULL
  • orderer — varchar(40)
  • sender — varchar(40)
  • recevied_name — varchar(20)
  • recevied_phone (recipient_phone) — varchar(20)
  • deliver_method — varchar(20)
  • address_desc — text
  • pickup_location — varchar(40)
  • entrance_method — varchar(40)
  • packaging_method — varchar(40)
  • notify_time — varchar(40)
  • non_release — varchar(40)
  • create_at — timestamp
  • update_at — timestamp
  • delete_yn — varchar(2)

OrderProductMapping

  • order_idx — bigint — Foreign key → Order.order_idx — NOT NULL
  • product_idx — bigint — Foreign key → Product.product_idx — NOT NULL
  • price — int
  • discount — int
  • amount — int

Product

  • product_idx — bigint — Primary key — NOT NULL
  • create_at — timestamp
  • update_at — timestamp
  • delete_yn — varchar(2)
  • brand_idx — bigint — Foreign key → Brand.brand_idx — NOT NULL
  • discount — int
  • discount_price — int
  • price — int
  • name — varchar(40)
  • subname — varchar(40)
  • sales_unit — varchar(40)
  • weight — varchar(40)
  • type — varchar(40)
  • packaging_type — varchar(40)
  • Allergie_info — text
  • distinct_delivery — varchar(40)
  • source — varchar(40)
  • notice — varchar(100)
  • desc_html — text

ProductDetailList

  • product_idx — bigint — Foreign key → Product.product_idx — NOT NULL
  • name — varchar(40)
  • origin_price — int
  • discount_price — int
  • save_point_yn — varchar(2)
  • index — int

ProductImage

  • productimage_idx — bigint — Primary key — NOT NULL
  • product_idx — bigint — Foreign key → Product.product_idx — NOT NULL
  • url — text

ProductQnA

  • qna_idx — bigint — Primary key — NOT NULL
  • product_idx — bigint — Foreign key → Product.product_idx — NOT NULL
  • user_idx — bigint — Foreign key → User.user_idx — NOT NULL
  • praent_idx — bigint
  • qna_desc — text
  • create_at — timestamp — NOT NULL
  • update_at — timestamp
  • delete_yn — varchar(2)

ProductReview

  • review_idx — bigint — Primary key — NOT NULL
  • review_desc — text
  • user_idx — bigint — Foreign key → User.user_idx — NOT NULL
  • product_idx — bigint — Foreign key → Product.product_idx — NOT NULL
  • create_at — timestamp — NOT NULL
  • update_at — timestamp
  • delete_yn — varchar(2)

Untitled

    User

    • user_idx — bigint — Primary key — NOT NULL
    • create_at — timestamp — NOT NULL
    • update_at — timestamp
    • delete_yn — varchar(2)
    • id — varchar(20)
    • pwd — text
    • email — varchar(20)
    • phone — varchar(20)
    • birth — varchar(20)
    • sex — varchar(2)
    • grade — varchar(5)
    • name (Field) — varchar(20)

    UserCouponMapping

    • coupon_idx — bigint — Foreign key → Coupon.coupon_idx — NOT NULL
    • user_idx — bigint — Foreign key → User.user_idx — NOT NULL
    • create_at — timestamp — NOT NULL
    • update_at — timestamp
    • use_yn — varchar(2)

    UserPointLog (Userpointlog)

    • point_log_idx (pointlog_idx) — bigint — Primary key — NOT NULL
    • user_idx — bigint — Foreign key → User.user_idx — NOT NULL
    • create_at — timestamp
    • is_minus — varchar(2)
    • point_amount — int

    UserProductMapping (UserLog)

    • product_idx — bigint — Foreign key → Product.product_idx — NOT NULL
    • user_idx — bigint — Foreign key → User.user_idx — NOT NULL