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