--PointHistory, MallUser 참조하는 객체 조사
Exec sp_depends PointHistory
Exec sp_depends MallUser
/*
dbo.Analysis_CustomerPoint view
dbo.mallAdminPermitCustReview stored procedure
dbo.mallAdminPermitNewCustReview stored procedure
dbo.mallDeleteUser stored procedure
dbo.mallGetSumUserPointBonus stored procedure
dbo.mallGetUserPointList stored procedure
dbo.mallInsertPoint stored procedure
dbo.mallInsertUser stored procedure
dbo.mallInsertUserInfo stored procedure
dbo.mallMp3Lucky stored procedure
dbo.MallTicketUpdateOk stored procedure
dbo.mallUpdateNewCustReview stored procedure
dbo.Shop_BonusBack stored procedure
dbo.shopmaster_InsertPointForReOrder stored procedure
dbo.usp_deleteuser stored procedure
dbo.vPointAccUser view
dbo.Analysis_JoinMember view
dbo.Analysis_JoinMember_BugsMusic view
dbo.Analysis_JoinMember_EduNet view
dbo.Angel_Insert_shop stored procedure
dbo.ArreoUserInfo view
dbo.eduMallGetCheckLogin stored procedure
dbo.eduMallInsertUserInfo stored procedure
dbo.eduMallUpdateUserInfo stored procedure
dbo.GetAllMembers stored procedure
dbo.increaseCusBonus stored procedure
dbo.mallAdminPermitCustReview stored procedure
dbo.mallAdminPermitNewCustReview stored procedure
dbo.mallBonusAdd stored procedure
dbo.mallBonusDeduct stored procedure
dbo.mallDeleteUser stored procedure
dbo.mallEntireMail_Hanmail stored procedure
dbo.mallGetAllMailingInfoList stored procedure
dbo.mallGetAllMailingList stored procedure
dbo.mallGetAllMailingList_ForBalentain stored procedure
dbo.mallGetCheckLogin stored procedure
dbo.mallGetCheckRegNo stored procedure
dbo.MallGetCheckUserID stored procedure
dbo.mallGetCurrentRecommandUserCount stored procedure
dbo.mallGetCurrentUserCount stored procedure
dbo.MallGetPiSP stored procedure
dbo.mallGetUserInfo stored procedure
dbo.mallGetUserInfoForManage stored procedure
dbo.mallGetUserMailAddress stored procedure
dbo.mallGetUserPassword stored procedure
dbo.mallInsertCSInfo stored procedure
dbo.mallInsertPoint stored procedure
dbo.mallInsertUser stored procedure
dbo.mallInsertUserInfo stored procedure
dbo.mallIserTendencyUpdate stored procedure
dbo.mallMP3Cnt stored procedure
dbo.mallMp3EventLuckyUser stored procedure
dbo.mallMp3EventRejectUser stored procedure
dbo.mallMp3Lucky stored procedure
dbo.mallMp3Target stored procedure
dbo.mallSearchUserList stored procedure
dbo.mallUpdateNewCustReview stored procedure
dbo.mallUpdateUser stored procedure
dbo.mallUpdateUserHAddress stored procedure
dbo.mallUpdateUserInfo stored procedure
dbo.mallUpdateUserOAddress stored procedure
dbo.mallUserGetCheckLogin stored procedure
dbo.mallUserInforForOrder stored procedure
dbo.mallUserTendencyUpdate stored procedure
dbo.MallUserUpdate stored procedure
dbo.MallUserUpdate_V1 stored procedure
dbo.OutSiteUserInfo view
dbo.Shop_BonusBack stored procedure
dbo.Shopmaster_ChangedState4000 stored procedure
dbo.shopmaster_InsertPointForReOrder stored procedure
dbo.TotalUserInfo view
dbo.usp_deleteuser stored procedure
dbo.vBonus10000 view
*/
Select * from MallUser Where UserID='icdtl'
--MallUser 필드조사
sp_help MallUser
UserID( char 13
Pwd char 10
UserName varchar 30
Email varchar 50
EmailPermit bit 1
RegNo char 13
NameCert int 4 --(실명인증)
EnablePhoneNo varchar 20 --휴대폰으로 바뀌어야 할 부분
JobCD int 4
HPostCode varchar 10
HAddress varchar 200
HPhoneNo varchar 20
OPostCode varchar 10
OAddress varchar 200
OPhoneNo varchar 20
marriedChk bit 1
WeddingDate varchar 10
RecommandID char 13 --추천인 아이디
JoinDate datetime 8 --가입일자
LastAccess datetime 8 --마지막 접속일자
TradeCount int 4 --뭔지 모르겠음
ITradeCount int 4 --뭔지 모르겠음
ATradeCount int 4 --뭔지 모르겠음
RTradeCount int 4 --뭔지 모르겠음
Point money 8 --적립된 마일리지
Bonus money 8 --사용가능한 마일리지
Closed bit 1 --탈퇴여부
DeletedDate smalldatetime 4 --탈퇴일자
RecommandCnt int 4 --추천받은 횟수
IP varchar 20
Path int 4
Cert char 1 --뭔지 모르겠음
CSTendency int 4 --뭔지 모르겠음
CSAccCnt int 4 --뭔지 모르겠음
saveId int 4 --지원하는 단체
BonusManageDate datetime 8 --처음 마일리지가 적용된 일자(JoinDate랑 동일)
SavePoint int 4 --뭔지 모르겠음
SaveBonus int 4 --뭔지 모르겠음
---------------------------------------------------------------------------------------------
sp_help PointHistory
UserID char 13
RegDate datetime 8
AccType int 4
Point money 8
AccDesc varchar 200
DoID char 10
Select Top 1000 * From PointHistory Where AccType not in (3,7)
Select * from AccType
Select ph.UserID, ph.RegDate, ph.Acctype, aty.AccDesc, ph.Point, ph.AccDesc From PointHistory as ph join AccType as aty
on ph.AccType=aty.AccType
Where UserID='delicoke'
Order by RegDate
Select ph.UserID, ph.RegDate, ph.Acctype, aty.AccDesc, ph.Point, ph.AccDesc From PointHistory as ph join AccType as aty
on ph.AccType=aty.AccType
Where UserID='icdtl'
Order by RegDate
Select * from sql2.logics.dbo.CusOrder Where OrderNum=1197278
Select * from sql2.logics.dbo.OrderGood Where OrderNum=1197278
Select * from sql2.logics.dbo.CusOrder Where OrderNum=1338041
Select * from sql2.logics.dbo.OrderGood Where OrderNum=1338041
