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 )