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