tt
Tables (5)
T_GOODS_DETAIL_IMAGE (Untitled)
- IMAGE_ID (Key) — NUMBER(20,0) — Primary key — NOT NULL
- GOODS_ID (Key2) — NUMBER(20,0) — Foreign key → T_SHOPPING_GOODS.GOODS_ID — NOT NULL
- GOODS_ID (Field) — NUMBER(20,0)
- FILENAME (Field2) — VARCHAR2(50 BYTE)
- REG_ID (Field3) — VARCHAR2(20 BYTE)
- FILETYPE (Field4) — VARCHAR2(40 BYTE)
- Field5 — DATE
T_SHOPPING_CART (Untitled5)
- CART_ID (Key) — NUMBER(10,0) — Primary key — NOT NULL
- MEMBER_ID (Key2) — VARCHAR2(20 BYTE) — Foreign key → T_SHOPPING_MEMBER.MEMBER_ID — NOT NULL
- GOODS_ID (Field) — NUBMER(20,0)
- MEMBER_ID (Field2) — VARCHAR2(20 BYTE)
- DEL_YN (Field3) — VARCHAR2(20 BYTE)
- CREDATE (Field4) — DATE
- CART_GOODS_QTY (Field5) — NUMBER(4,0)
T_SHOPPING_GOODS (Untitled2)
- GOODS_ID (Key) — NUMBER(20,0) — Primary key — NOT NULL
- GOODS_SORT (Field) — VARCHAR2(50 BYTE)
- GOODS_TITLE (Field2) — VARCHAR2(100 BYTE)
- GOODS_WRITER (Field3) — VARCHAR2(50 BYTE)
- GOODS_PRICE (Field4) — NUMBER(10,0)
- GOODS_SALES_PRICE (Field5) — NUMBER(10,0)
- GOODS_POINT (Field6) — NUMBER(10,0)
- GOODS_PUBLISHED_DATE (Field7) — DATE
- GOODS_DELIVERY_PRICE (Field8) — NUMBER(10,0)
- GOODS_DELIVERY_DATE (Field9) — DATE
- GOODS_STATUS (Field10) — VARCHAR2(50 BYTE)
- GOODS_INTRO (Field11) — VARCHAR2(2000 BYTE)
- GOODS_PUBLISHER_COMMNET (Field12) — VARCHAR2(2000 BYTE)
- GOODS_RECOMMENDATION (Field13) — VARCHAR2(2000 BYTE)
- GOODS_CREDATE (Field14) — DATE
T_SHOPPING_MEMBER (Untitled3)
- MEMBER_ID (Key) — VARCHAR2(20 BYTE) — Primary key — NOT NULL
- MEMBER_PW (Field) — VARCHAR2(30 BYTE)
- MEMBER_NAME (Field2) — VARCHAR2(50 BYTE)
- MEMBER_GENDER (Field3) — VARCHAR2(10 BYTE)
- TEL1 (Field4) — VARCHAR2(20 BYTE)
- TEL2 (Field5) — VARCHAR2(20 BYTE)
- TEL3 (Field6) — VARCHAR2(20 BYTE)
- HP1 (Field7) — VARCHAR2(20 BYTE)
- HP2 (Field8) — VARCHAR2(20 BYTE)
- HP3 (Field9) — VARCHAR2(20 BYTE)
- SMSSTS_YN (Field10) — VARCHAR2(20 BYTE)
- EMAIL1 (Field11) — VARCHAR2(20 BYTE)
- EMAIL2 (Field12) — VARCHAR2(20 BYTE)
- EMAILSTS_YN (Field13) — VARCHAR2(20 BYTE)
- ZIPCODE (Field14) — VARCHAR2(20 BYTE)
- ROADADDRESS (Field15) — VARCHAR2(500 BYTE)
- JIBUNADDRESS (Field16) — VARCHAR2(500 BYTE)
- NAMUJIADDRESS (Field17) — VARCHAR2(500 BYTE)
- MEMBER_BIRTH_Y (Field18) — VARCHAR2(20 BYTE)
- MEMBER_BIRTH_M (Field19) — VARCHAR2(20 BYTE)
- MEMBER_BIRTH_D (Field20) — VARCHAR2(20 BYTE)
- MEMBER_BIRTH_GN (Field21) — VARCHAR2(20 BYTE)
- JOINDATE (Field22) — DATE
T_SHOPPING_ORDER (Untitled4)
- ORDER_SEQ_NUM (Key) — NUMBER(20,0) — Primary key — NOT NULL
- MEMBER_ID (Key2) — VARCHAR2(20 BYTE) — Foreign key → T_SHOPPING_MEMBER.MEMBER_ID — NOT NULL
- ORDER_ID (Field) — NUMBER(20,0)
- MEMBER_ID (Field2) — VARCHAR2(20 BYTE)
- GOODS_ID (Field3) — NUMBER(20,0)
- ORDERER_NAME (Field4) — VARCHAR2(50 BYTE)
- GOODS_TITLE (Field5) — VARCHAR2(100 BYTE)
- ORDER_GOODS_QTY (Field6) — NUMBER(5,0)
- GOODS_SALES_PRICE (Field7) — NUMBER(5,0)
- GOODS_FILENAME (Field8) — VARCHAR2(60 BYTE)
- RECEIVER_NAME (Field9) — VARCHAR2(50 BYTE)
- RECEIVER_HP1 (Field10) — VARCHAR2(20 BYTE)
- RECEIVER_HP2 (Field11) — VARCHAR2(20 BYTE)
- RECEIVER_HP3 (Field12) — VARCHAR2(20 BYTE)
- RECEIVER_TEL1 (Field13) — VARCHAR2(20 BYTE)
- RECEIVER_TEL2 (Field14) — VARCHAR2(20 BYTE)
- RECEIVER_TEL3 (Field15) — VARCHAR2(20 BYTE)
- DELIVERY_ADDRESS (Field16) — VARCHAR2(500 BYTE)
- DELIVERY_METHOD (Field17) — VARCHAR2(40 BYTE)
- DELIVERY_MESSAGE (Field18) — VARCHAR2(300 BYTE)
- GIFT_WRAPPING (Field19) — VARCHAR2(20 BYTE)
- PAY_METHOD (Field20) — VARCHAR2(200 BYTE)
- CARD_COM_NAME (Field21) — VARCHAR2(50 BYTE)
- CARD_PAY_MONTH (Field22) — VARCHAR2(20 BYTE)
- PAY_ORDERER_HP_NUM (Field23) — VARCHAR2(20 BYTE)
- PAY_ORDER_TIME (Field24) — DATE