쿠폰로직ERD

테이블 (6)

TCouponMst (CopyOfUntitled3)

  • CouponNo (nvarchar(50)) — tinyint — 기본 키 — NOT NULL
  • CouponID (Key) — NULL — 외래 키 → TCouponPubMst.CouponID — NOT NULL
  • GameCode (Field) — NULL — NOT NULL
  • CouponSeqNo (int) — int — NOT NULL
  • GameCode (varchar(15)) — varchar(15) — NOT NULL
  • UserNo (tinyint) — NULL — NOT NULL
  • UserID (Field5) — NOT NULL
  • SeqNo (Field7) — NULL
  • HExpYMD (Field8)
  • CExpYMD (Field9)
  • ChargeNo (Field10)
  • CashNo (Field11) — NOT NULL
  • UseState (Field19) — NOT NULL
  • YMD (Field13) — NOT NULL
  • RYMD (Field14) — NOT NULL
  • IPAddr (Field15) — NOT NULL
  • UsedTitle (Field16) — NOT NULL
  • RegDate (Field20) — NOT NULL
  • UpdDate (Field21)

TCouponPubDtl (CopyOfCopyOfCopyOfUntitled)

  • CouponID (Key2) — NULL — 외래 키 → TCouponPubMst.CouponID — NOT NULL
  • SeqNo (Field) — NULL — NOT NULL
  • AvailType (Field3) — NULL
  • PriceID (Field4) — NULL
  • CategoryID (Field5) — NULL
  • UseState (Field7) — NULL — NOT NULL
  • AdminID (Field9) — NOT NULL
  • RegDate (Field6) — NOT NULL
  • UpdDate (Field10)

TCouponPubHist (CopyOfCopyOfUntitled3)

  • CouponID (Key) — NULL — 외래 키 → TCouponPubMst.CouponID — NOT NULL
  • SeqNo (Field7) — NULL — NOT NULL
  • HExpYMD (Field8) — NOT NULL
  • CExpYMD (Field9) — NOT NULL
  • PubCnt (int) — int — NOT NULL
  • Email (varchar(15)) — NOT NULL
  • AdminID (tinyint) — NOT NULL
  • UseState (Field19) — NOT NULL
  • RegDate (Field20) — NOT NULL
  • UpdDate (Field21)

TCouponPubMst (Untitled)

  • CouponID (Key) — NULL — 기본 키 — NOT NULL
  • GameCode (Field) — NULL — NOT NULL
  • CouponName (nvarchar(50)) — tinyint — NOT NULL
  • CouponType (tinyint) — tinyint — NOT NULL
  • ExpireType (Field5) — NOT NULL
  • ApplyDetail (Field6)
  • CashAttr (Field7)
  • ItemOrPackage (Field8)
  • DiscountArea (Field9)
  • MinPrice (Field10)
  • MHoldAvail (Field11) — NOT NULL
  • PerUserMaxRegCnt (Field12) — NOT NULL
  • EYMD (Field13) — NOT NULL
  • DurationType (Field14) — NOT NULL
  • Duration (Field15) — NOT NULL
  • TotalPubCnt (Field16) — NOT NULL
  • TotalUseCnt (Field17) — NOT NULL
  • AdminID (Field18) — NOT NULL
  • UseState (Field19) — NOT NULL
  • RegDate (Field20) — NOT NULL
  • UpdDate (Field21)
  • CouponPubDesc (Field22)
  • EventDCFlag (Field23)

TCouponRegMsg (CopyOfCopyOfUntitled32)

  • CouponNo (nvarchar(50)) — tinyint — 외래 키 → TCouponMst.CouponNo — NOT NULL
  • UserNo (tinyint) — NULL
  • UserID (Field5)
  • Reason (Field16)
  • AdminID (Field9)
  • RegDate (Field20) — NOT NULL
  • UpdDate (Field21)

TGameCodeMst (CopyOfUntitled)

  • GameCode (Field) — NULL — NOT NULL
  • GameAttrib (Field2) — NOT NULL
  • GameName (Field3) — NOT NULL
  • CPID (Field4) — NOT NULL
  • CPGameCode (Field5) — NULL — NOT NULL
  • RegDate (Field6) — NOT NULL
  • UpdDate (Field7)