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)