쿠폰로직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)