E-SHOP

Tables (11)

stock_allsum (Untitled9)

  • goods_no (primary) — int — Primary key — NOT NULL
  • allsum_qty (Field) — decimal

stock_insum (Untitled10)

  • goods_no (primary) — int — Primary key — NOT NULL
  • insum_qty (Field) — decimal

stock_outsum (Untitled11)

  • goods_no (primary) — int — Primary key — NOT NULL
  • outsum_qty (Field) — decimal

t_delivery (Untitled7)

  • delivery_no (primary) — int — Primary key — NOT NULL
  • member_id (Field) — varchar
  • title (Field2) — varchar
  • receiver_name (Field3) — varchar
  • receiver_hp (Field4) — varchar
  • receiver_tel (Field5) — varchar
  • zipcode (Field6) — varchar
  • roadAddress (Field7) — varchar
  • namujiAddress (Field8) — varchar
  • yn (Field9) — varchar
  • cart_no (primary2) — int — Foreign key → t_shopping_cart.cart_no — NOT NULL

t_goods_detail_image (Untitled8)

  • image_no (primary) — int — Primary key — NOT NULL
  • goods_no (Field) — int
  • filename (Field2) — varchar
  • filetype (Field3) — varchar

t_orderer_goods (Untitled6)

  • order_seq_no (primary) — int — Primary key — NOT NULL
  • order_no (Field) — int
  • goods_no (Field2) — int
  • order_goods_qty (Field3) — int

t_shopping_cart (Untitled4)

  • cart_no (primary) — int — Primary key — NOT NULL
  • goods_no (Field) — int
  • member_id (Field2) — varchar
  • cart_goods_qty (Field3) — int

t_shopping_goods (Untitled3)

  • goods_no (primary) — int — Primary key — NOT NULL
  • goods_categori (Field) — varchar
  • goods_name (Field2) — varchar
  • goods_company (Field3) — varchar
  • goods_price (Field4) — int
  • goods_wholesale_price (Field5) — int
  • goods_release (Field6) — date
  • goods_intro (Field7) — varchar
  • goods_credate (Field8) — date
  • goods_status (Field9) — varchar
  • image_no (primary2) — int — Foreign key → t_goods_detail_image.image_no — NOT NULL
  • stock_no (primary3) — int — Foreign key → t_stock.stock_no — NOT NULL
  • order_seq_no (primary4) — int — Foreign key → t_orderer_goods.order_seq_no — NOT NULL

t_shopping_member (Untitled)

  • member_id (primary) — varchar — Primary key — NOT NULL
  • member_pw (Field) — varchar
  • member_name (Field2) — varchar
  • member_gender (Field3) — varchar
  • tel (Field4) — varchar
  • hp (Field5) — varchar
  • smssts_yn (Field6) — char
  • email (Field9) — varchar
  • emailsts_yn (Field10) — char
  • zipcode (Field7) — varchar
  • roadAddress (Field8) — varchar
  • namujiAddress (Field11) — varchar
  • member_birth_y (Field12) — varchar
  • member_birth_m (Field13) — varchar
  • member_birth_d (Field14) — varchar
  • joindate (Field15) — date
  • del_yn (Field16) — char
  • order_no (primary2) — int — Foreign key → t_shopping_order.order_no — NOT NULL

t_shopping_order (Untitled2)

  • order_no (primary) — int — Primary key — NOT NULL
  • member_id (Field) — varchar
  • receiver_name (Field2) — varchar
  • receiver_hp (Field3) — varchar
  • delivery_no (Field4) — int
  • delivery_method (Field5) — varchar
  • delivery_message (Field6) — varchar
  • pay_method (Field7) — varchar
  • card_com_name (Field8) — varchar
  • card_pay_month (Field9) — varchar
  • pay_orderer_hp_num (Field10) — varchar
  • pay_amount (Field11) — int
  • delivery_status (Field12) — varchar
  • pay_order_time (Field13) — date
  • delivery_no (primary3) — int — Foreign key → t_delivery.delivery_no — NOT NULL
  • order_seq_no (primary2) — int — Foreign key → t_orderer_goods.order_seq_no — NOT NULL

t_stock (Untitled5)

  • stock_no (primary) — int — Primary key — NOT NULL
  • goods_no (Field) — int
  • order_no (Field2) — int
  • stock_status (Field3) — char
  • cur_qty (Field4) — int
  • stock_creDate (Field5) — datetime
  • goods_no (primary2) — int — Foreign key → stock_allsum.goods_no — NOT NULL
  • goods_no (primary3) — int — Foreign key → stock_outsum.goods_no — NOT NULL
  • goods_no (primary4) — int — Foreign key → stock_insum.goods_no — NOT NULL