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