vip

Tables (14)

NONE_MEMBER_BUY (Untitled11)

  • none_member_phone (Field) — varchar2(13)
  • reproduct_id (Field2) — varchar2(20)
  • buy_price (Field3) — number

NONE_MEMBER_LIST (Untitled9)

  • none_member_phone (Key) — varchar2(13) — Primary key — NOT NULL

OCTION (Untitled10)

  • suggested_price (Field) — number
  • oction_suggested_date (Field2) — timestamp
  • oction_end_date (Field3) — timestamp
  • REPRODUCT_ID (Key) — VARCHAR2(100) — Foreign key → REPRODUCT_INFO.REPRODUCT_ID — NOT NULL
  • PROMPT_OWNER (Key2) — varchar2(13) — Foreign key → NONE_MEMBER_LIST.none_member_phone — NOT NULL

REPRODUCT_INFO (Untitled8)

  • REPRODUCT_ID (Key) — VARCHAR2(100) — Primary key — NOT NULL
  • reproduct_name (Field) — varchar2(100)
  • highest_price (Field2) — number
  • least_price (Field3) — number
  • highest_age (Field4) — number
  • least_age (Field5) — number
  • brand (Field6) — varchar2(100)
  • gender (Field7) — varchar2(1)
  • big_key (Field8) — varchar2(1)
  • small_key (Field9) — varchar2(100)
  • color (Field10) — varchar2(50)
  • image (Field11) — varchar2(50)
  • generic_size (Field12) — varchar2(2)
  • specific_size (Field13) — varchar2(18)
  • saler (Field14) — varchar2(20)
  • oction_start_date (Field15) — timestamp
  • oction_end_date (Field16) — timestamp

VIP_BUY (Untitled2)

  • product_id (Field) — varchar2(100)
  • buy_price (Field2) — number
  • buy_date (Field3) — varchar2(19)
  • VIP_ID (Key) — VARCHAR2(20) — Foreign key → VIP_INFO.VIP_ID — NOT NULL

VIP_COUPON (Untitled4)

  • COUPON_ID (Key) — VARCHAR2(20) — Primary key — NOT NULL
  • discount (Field) — number
  • apparal_type (Field2) — varchar2(1)
  • end_date (Field3) — varchar2(20)
  • Field4
  • OWNER (Key2) — VARCHAR2(20) — Foreign key → VIP_INFO.VIP_ID — NOT NULL

VIP_COUPON_TRADE (Untitled5)

  • coupon_id (Field) — varchar2(20)
  • discount (Field2) — number
  • apparal_type (Field3) — varchar2(1)
  • end_date (Field4) — varchar2(19)
  • owner (Field5) — varchar2(20)

VIP_COUPON_TRADE_INFO (Untitled6)

  • host_coupon_id (Field) — varchar2(20)
  • guest_coupon_id (Field2) — varchar2(20)
  • HOST_VIP_ID (Key) — VARCHAR2(20) — Foreign key → VIP_INFO.VIP_ID — NOT NULL
  • GUEST_VIP_ID (Key2) — VARCHAR2(20) — Foreign key → VIP_INFO.VIP_ID — NOT NULL

VIP_INFO (Untitled)

  • VIP_ID (Key) — VARCHAR2(20) — Primary key — NOT NULL
  • name (Field) — varchar2(20)
  • email (Field3) — varchar2(30)
  • home (Field4) — varchar2(50)
  • password (Field5) — varchar2(30)
  • hint (Field6) — varchar2(100)
  • answer (Field7) — varchar2(100)
  • PHONE (Key2) — VARCHAR2(13) — Foreign key → VIP_WALL.VIP_PHONE — NOT NULL

VIP_INTEREST (Untitled3)

  • product_id (Field2) — varchar2(100)
  • interest_price (Field3) — number
  • interest_date (Field4) — varchar2(19)
  • Field5
  • VIP_ID (Key) — VARCHAR2(20) — Foreign key → VIP_INFO.VIP_ID — NOT NULL

VIP_PRODUCT_FOR_MATURE (CopyOfUntitled72)

  • PRODUCT_ID (Key) — VARCHAR2(100) — Primary key — NOT NULL
  • product_name (Field) — varchar2(100)
  • price (Field2) — number
  • brand (Field3) — varchar2(50)
  • gender (Field4) — varchar2(1)
  • big_key (Field5) — varchar2(1)
  • small_key (Field6) — varchar2(100)
  • amount (Field7) — number
  • color (Field8) — varchar2(50)
  • image (Field9) — varchar2(50)
  • generic_size (Field10) — varchar2(2)
  • specific_size (Field11) — varchar2(18)
  • season (Field12) — varchar2(10)

VIP_PRODUCT_FOR_SENIOR (CopyOfUntitled7)

  • PRODUCT_ID (Key) — VARCHAR2(100) — Primary key — NOT NULL
  • product_name (Field) — varchar2(100)
  • price (Field2) — number
  • brand (Field3) — varchar2(50)
  • gender (Field4) — varchar2(1)
  • big_key (Field5) — varchar2(1)
  • small_key (Field6) — varchar2(100)
  • amount (Field7) — number
  • color (Field8) — varchar2(50)
  • image (Field9) — varchar2(50)
  • generic_size (Field10) — varchar2(2)
  • specific_size (Field11) — varchar2(18)
  • season (Field12) — varchar2(10)

VIP_PRODUCT_FOR_YOUNGER (Untitled7)

  • PRODUCT_ID (Key) — VARCHAR2(100) — Primary key — NOT NULL
  • product_name (Field) — varchar2(100)
  • price (Field2) — number
  • brand (Field3) — varchar2(50)
  • gender (Field4) — varchar2(1)
  • big_key (Field5) — varchar2(1)
  • small_key (Field6) — varchar2(100)
  • amount (Field7) — number
  • color (Field8) — varchar2(50)
  • image (Field9) — varchar2(50)
  • generic_size (Field10) — varchar2(2)
  • specific_size (Field11) — varchar2(18)
  • season (Field12) — varchar2(10)

VIP_WALL (*)

  • VIP_PHONE (Key) — VARCHAR2(13) — Primary key — NOT NULL
  • VIP_EMAIL (Field) — VARCHAR2(30)