c2c

Tables (12)

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
  • 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

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
  • productname — varchar(50) — NOT NULL
  • usable — tinyint — NOT NULL
  • insertdt — TIMESTAMP
  • updatedt — TIMESTAMP
  • goods_id (Field) — VARCHAR(12)
  • category1 (Field2) — VARCHAR(50)
  • category2 (Field3) — VARCHAR(50)
  • affiliate (Field4) — VARCHAR(50)
  • affiliate_category (Field5) — VARCHAR(50)
  • headswap_cd (Field6) — VARCHAR(50)
  • swap_cd (Field7) — VARCHAR(50)
  • description (Field8) — TEXT
  • goods_nm (Field9) — VARCHAR(100)
  • goods_img (Field10) — VARCHAR(255)
  • normal_sale_price (Field11) — INT
  • normal_sale_vat (Field12) — INT
  • sale_price (Field13) — INT
  • total_price (Field14) — INT
  • period_end (Field15) — TIMESTAMP
  • limit_date (Field16) — INT
  • 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
  • productkey — bigint — Foreign key → product.productkey — NOT NULL
  • giftkey — BIGINT — Foreign key → gift.giftkey — NOT NULL
  • buyeruuid (memberkey) — varchar(36) — Foreign key → member.memberkey — NOT NULL
  • recevieruuid (memberkey2) — varchar(36) — Foreign key → member.memberkey
  • code — varchar(36) — NOT NULL
  • expirationDate — timestamp — NOT NULL
  • gifticonimage (Field) — varchar(500) — NOT NULL
  • status — tinyint
  • insertdt — TIMESTAMP
  • updatedt — TIMESTAMP
  • pinno (Field2) — VARCHAR(50)
  • 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)