erd

Tables (6)

T_CODE

  • CODE_ID — INT(11) — NOT NULL
  • GRP_ID — VARCHAR(50)
  • CODE_NAME — VARCHAR(100)
  • CODE_DESC — VARCHAR(100)
  • INORDER — INT(11)
  • CREDATE — DATE

T_GOODS_DETAIL_IMAGE

  • IMAGE_ID — INT(11) — NOT NULL
  • GOODS_ID — INT(11)
  • FILENAME — VARCHAR(50)
  • REG_ID — VARCHAR(20)
  • FILETYPE — VARCHAR(40)
  • CREDATE — DATE

T_SHOPPING_CART

  • CART_ID — INT(11) — NOT NULL
  • GOODS_ID — INT(11)
  • MEMBER_ID — VARCHAR(20 )
  • DEL_YN — VARCHAR(20 )
  • CREDATE — DATE
  • CART_GOODS_QTY — INT(11)

T_SHOPPING_GOODS

  • GOODS_ID — INT(11) — NOT NULL
  • GOODS_SORT — VARCHAR(50 )
  • GOODS_TITLE — VARCHAR(100 )
  • GOODS_WRITER — VARCHAR(50 )
  • GOODS_PUBLISHER — VARCHAR(50 )
  • GOODS_PRICE — INT(11)
  • GOODS_SALES_PRICE — INT(11)
  • GOODS_POINT — INT(11)
  • GOODS_PUBLISHED_DATE — DATE
  • GOODS_TOTAL_PAGE — INT(11)
  • GOODS_ISBN — VARCHAR(50 )
  • GOODS_DELIVERY_PRICE — INT(11)
  • GOODS_DELIVERY_DATE — DATE
  • GOODS_STATUS — int
  • GOODS_INTRO — VARCHAR(2000 )
  • GOODS_WRITER_INTRO — VARCHAR(2000 )
  • GOODS_PUBLISHER_COMMENT — VARCHAR(2000 ) — ARCHAR(2000
  • GOODS_RECOMMENDATION — VARCHAR(2000 )
  • GOODS_CONTENTS_ORDER — MEDIUMTEXT
  • GOODS_CREDATE — DATE

T_SHOPPING_MEMBER

  • MEMBER_PW — VARCHAR(30 ) — Primary key
  • MEMBER_ID — VARCHAR(20) — NOT NULL
  • MEMBER_NAME — VARCHAR(50 )
  • MEMBER_GENDER — VARCHAR(10 )
  • TEL1 — VARCHAR(20 )
  • TEL2 — VARCHAR(20 )
  • TEL3 — VARCHAR(20 )
  • HP1 — VARCHAR(20 )
  • HP2 — VARCHAR(20 )
  • HP3 — VARCHAR(20 )
  • SMSSTS_YN — VARCHAR(20 )
  • EMAIL1 — VARCHAR(20 )
  • EMAIL2 — VARCHAR(20 )
  • EMAILSTS_YN — VARCHAR(20 )
  • ZIPCODE — VARCHAR(20 )
  • ROADADDRESS — VARCHAR(500 )
  • JIBUNADDRESS — VARCHAR(500 )
  • NAMUJIADDRESS — VARCHAR(500 )
  • MEMBER_BIRTH_Y — VARCHAR(20 )
  • MEMBER_BIRTH_M — VARCHAR(20 )
  • MEMBER_BIRTH_D — VARCHAR(20 )
  • MEMBER_BIRTH_GN — VARCHAR(20 )
  • JOINDATE — DATE
  • DEL_YN — VARCHAR(20 )

T_SHOPPING_ORDER

  • ORDER_SEQ_NUM — INT(11) — NOT NULL
  • ORDER_ID — INT(11)
  • MEMBER_ID — VARCHAR(20 )
  • GOODS_ID — INT(11)
  • ORDERER_NAME — VARCHAR(50 )
  • GOODS_TITLE — VARCHAR(100 )
  • ORDER_GOODS_QTY — INT(11)
  • GOODS_SALES_PRICE — INT(11)
  • GOODS_FILENAME — VARCHAR(60 )
  • RECEIVER_NAME — VARCHAR(50 )
  • RECEIVER_HP1 — VARCHAR(20 )
  • RECEIVER_HP2 — VARCHAR(20 )
  • RECEIVER_HP3 — VARCHAR(20 )
  • RECEIVER_TEL1 — VARCHAR(20 )
  • RECEIVER_TEL2 — VARCHAR(20 )
  • RECEIVER_TEL3 — VARCHAR(20 )
  • DELIVERY_ADDRESS — VARCHAR(500 )
  • DELIVERY_METHOD — VARCHAR(40 )
  • DELIVERY_MESSAGE — VARCHAR(300 )
  • GIFT_WRAPPING — VARCHAR(20 )
  • PAY_METHOD — VARCHAR(200 )
  • CARD_COM_NAME — VARCHAR(50 )
  • CARD_PAY_MONTH — VARCHAR(20 )
  • PAY_ORDERER_HP_NUM — VARCHAR(20 )
  • DELIVERY_STATE — int
  • PAY_ORDER_TIME — DATE
  • ORDERER_HP — VARCHAR(50 )