IDX int primary key identity(1,1), --인덱스
FIDX int, -- 참조인덱스(0)
SerialKey varchar(30) Unique, --회원간 아이템 거래시 사용되는 시리얼키(중복불가)
UserID varchar(12) Unique not null, --아이디 ( ID )(집전화,핸드폰)
GsIDX int, --서버선택
Title varchar(100) not null, --제목
Price money, --판매금액
SettleType varchar(15), --결제방식(현금/카드,현금,카드,마일리지)
SettleCD int Default(0), --거래진행없슴(0), 입금전(1), 입금확인(2), 신용카드(11), 마일리지(51)
Contents text, --상세내용
RegDate DateTime default(GetDate()),--등록일자/등록시간
DoStatusCD int Default(0), --상태코드(인수(1),인계*(1),출금요청(1,1),거래완료(2,2))
BusinessType int) --판매(1), 구매(2)
Create Proc SubDeal_Insert
@FIDX int
, @SerialKey varchar(30)
, @UserID varchar(12)
, @GsIDX int
, @Title varchar(100)
, @Price money
, @SettleType varchar(15)
, @SettleCD int
, @Contents varchar(8000)
, @DoStatusCD int
, @BusinessType int
as
if @FIDX='' Begin
Insert ForDealing(SerialKey, UserID, GsIDX, Title, Price, SettleType, SettleCD, Contents, DoStatusCD, BusinessType)
Values (@SerialKey, @UserID, @GsIDX, @Title, @Price, @SettleType, @SettleCD, @Contents, 100, @BusinessType)
End
Else Begin
Insert ForDealing(FIDX, SerialKey, UserID, GsIDX, Title, Price, SettleType, SettleCD, Contents, DoStatusCD, BusinessType)
Values (@FIDX, @SerialKey, @UserID, @GsIDX, @Title, @Price, @SettleType, @SettleCD, @Contents, @DoStatusCD, @BusinessType)
End
Create Proc SubDeal_Update
@IDX int
, @GsIDX int
, @Title varchar(100)
, @Price money
, @SettleType varchar(15)
, @Contents varchar(8000)
as
Update ForDealing Set GsIDX=@GsIDX, Title=@Title, Price=@Price, SettleType=@SettleType, Contents=@Contents
Where IDX=@IDX
/* 추가 개발 테이블
Create Table Settle(
SettleCD int,
SettleDESC varchar(30)
)
Insert Settle values(0,'거래가능')
Insert Settle values(1,'입금전')
Insert Settle values(2,'입금확인')
Insert Settle values(11,'신용카드')
Insert Settle values(51,'마일리지')
*/
