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 )