shopping

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_ID) — VARCHAR(20) — NOT NULL
  • (MEMBER_PW) — VARCHAR(30 )
  • (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 )
  • (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 )