WYFT 2.0

Tables (17)

gift

  • giftkey — BIGINT — Primary key — NOT NULL
  • gifttype (typekey) — bigint — Foreign key → gift_type.typekey — NOT NULL
  • senderuuid (memberkey) — varchar(36) — Foreign key → member.memberkey — NOT NULL
  • receiveruuid (memberkey2) — varchar(36) — Foreign key → member.memberkey — NOT NULL
  • giftname — varchar(255) — NOT NULL
  • status — tinyint — NOT NULL
  • opendt (Field) — TIMESTAMP
  • insertdt — TIMESTAMP — NOT NULL
  • updatedt — TIMESTAMP — NOT NULL

gift_event (gift_arevent)

  • areventkey — BIGINT — Primary key — NOT NULL
  • giftkey — BIGINT — Foreign key → gift.giftkey — NOT NULL
  • eventtype (Field2) — bigint — NOT NULL
  • contenturl (Field) — varchar(255)
  • insertdt — TIMESTAMP
  • updatedt — TIMESTAMP

gift_location

  • locationkey — BIGINT — Primary key — NOT NULL
  • giftkey — BIGINT — Foreign key → gift.giftkey — NOT NULL
  • locationname — varchar(255) — NOT NULL
  • latitude — double(10,7) — NOT NULL
  • longitude — double(10,7) — NOT NULL
  • status (Field) — tinyint — NOT NULL
  • insertdt — TIMESTAMP
  • updatedt — TIMESTAMP

gift_period

  • periodkey — BIGINT — Primary key — NOT NULL
  • giftkey — BIGINT — Foreign key → gift.giftkey — NOT NULL
  • startdt — datetime — NOT NULL
  • enddt — datetime — NOT NULL
  • insertdt — TIMESTAMP
  • updatedt — TIMESTAMP

gift_type

  • typekey — BIGINT — Primary key — NOT NULL
  • typename — VARCHAR(255) — NOT NULL
  • usable — tinyint — NOT NULL
  • insertdt — TIMESTAMP
  • updatedt — TIMESTAMP

gift_type_parameter (CopyOfgift_type)

  • typekey (typekey2) — BIGINT — Foreign key → gift_type.typekey — NOT NULL
  • paramtername (typename) — VARCHAR(255) — NOT NULL
  • usable — tinyint — NOT NULL
  • insertdt — TIMESTAMP
  • updatedt — TIMESTAMP

item (CopyOfproduct_gifticon)

  • itemkey (gifticonkey) — BIGINT — Primary key — NOT NULL
  • recevieruuid (memberkey2) — varchar(36) — Foreign key → member.memberkey
  • goods_nm (Field2) — VARCHAR(255) — NOT NULL
  • itemimage (Field) — varchar(500) — NOT NULL
  • sponsor (Field11) — VARCHAR(50) — NOT NULL
  • expirationdate (expirationDate) — timestamp — NOT NULL
  • game_type (Field3) — varchar(50) — NOT NULL
  • status — tinyint — NOT NULL
  • insertdt — TIMESTAMP — NOT NULL
  • updatedt — TIMESTAMP — NOT NULL

log_batch (CopyOflog_server2)

  • seq — BIGINT — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • request — varchar(5000)
  • response — varchar(5000)
  • processdt — datetime

log_interfacer (CopyOfCopyOflog_server)

  • seq — BIGINT — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • request — varchar(5000)
  • response — varchar(5000)
  • processdt — datetime

log_msg (CopyOflog_server)

  • seq — BIGINT — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • receive (request) — varchar(5000)
  • send (response) — varchar(5000)
  • processdt — datetime

log_server

  • seq — BIGINT — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • request — varchar(5000)
  • response — varchar(5000)
  • processdt — datetime

member

  • memberkey — BIGINT — Primary key — NOT NULL
  • phonenumber — VARCHAR(20) — NOT NULL
  • nickname — VARCHAR(255) — NOT NULL
  • memberuuid — VARCHAR(36) — NOT NULL
  • profile — varchar(255) — NOT NULL
  • email (Field) — VARCHAR(45)
  • usable — tinyint
  • insertdt — TIMESTAMP
  • updatedt — TIMESTAMP

member_follow

  • seq — BIGINT — Primary key — NOT NULL
  • memberkey (memberkey2) — bigint — Foreign key → member.memberkey — NOT NULL
  • followingkey (memberkey3) — bigint — Foreign key → member.memberkey — NOT NULL
  • status — tinyint
  • insertdt — TIMESTAMP
  • updatedt — TIMESTAMP

product

  • productkey — BIGINT — Primary key — NOT NULL
  • categorytype (categorykey) — bigint — Foreign key → product_category.categorykey — NOT NULL
  • goods_nm (Field9) — VARCHAR(100) — NOT NULL
  • goods_img (Field10) — VARCHAR(255) — NOT NULL
  • normal_sale_price (Field11) — INT — NOT NULL
  • affiliate (Field4) — VARCHAR(50) — NOT NULL
  • limit_date (Field16) — VARCHAR(10) — NOT NULL
  • category1 (Field2) — VARCHAR(50)
  • usable — tinyint — NOT NULL
  • insertdt — TIMESTAMP
  • updatedt — TIMESTAMP
  • goods_id (Field) — VARCHAR(12)
  • category2 (Field3) — VARCHAR(50)
  • affiliate_category (Field5) — VARCHAR(50)
  • headswap_cd (Field6) — VARCHAR(50)
  • swap_cd (Field7) — VARCHAR(50)
  • description (Field8) — TEXT
  • normal_sale_vat (Field12) — INT
  • sale_price (Field13) — INT
  • total_price (Field14) — INT
  • period_end (Field15) — TIMESTAMP
  • end_date (Field17) — TIMESTAMP
  • delivery_url (Field18) — VARCHAR(255)

product_category

  • categorykey — BIGINT — Primary key — NOT NULL
  • categoryname — VARCHAR(255) — NOT NULL
  • insertdt — TIMESTAMP
  • updatedt — TIMESTAMP

product_gifticon

  • gifticonkey — BIGINT — Primary key — NOT NULL
  • pinno (code) — varchar(36) — NOT NULL
  • productkey — bigint — Foreign key → product.productkey — NOT NULL
  • giftkey — BIGINT — Foreign key → gift.giftkey — NOT NULL
  • gifticonimage (Field) — varchar(500) — NOT NULL
  • buyeruuid (memberkey) — varchar(36) — Foreign key → member.memberkey — NOT NULL
  • recevieruuid (memberkey2) — varchar(36) — Foreign key → member.memberkey
  • expirationdate (expirationDate) — timestamp — NOT NULL
  • goods_nm (Field2) — VARCHAR(255) — NOT NULL
  • affiliate (Field11) — VARCHAR(50) — NOT NULL
  • status — tinyint — NOT NULL
  • insertdt — TIMESTAMP — NOT NULL
  • updatedt — TIMESTAMP — NOT NULL
  • mdn (Field3) — VARCHAR(50)
  • trid (Field4) — VARCHAR(50)
  • ctrid (Field5) — VARCHAR(50)
  • expirationdate_pin (Field6) — VARCHAR(50)
  • stampoffice (Field7) — VARCHAR(50)
  • stampcode (Field8) — VARCHAR(50)
  • stamptype (Field9) — VARCHAR(50)
  • pinsubinfo (Field10) — VARCHAR(50)

product_option (CopyOfproduct_category)

  • optionkey (categorykey) — BIGINT — Primary key — NOT NULL
  • goods_id (productkey) — VARCHAR(12) — Foreign key → product.productkey — NOT NULL
  • optionname (Field) — VARCHAR(100) — NOT NULL
  • optionvalue (Field2) — VARCHAR(100) — NOT NULL
  • insertdt — TIMESTAMP
  • updatedt — TIMESTAMP