Æ÷ÀÎƮīµå ½Ã½ºÅÛ Å×ÀÌºí ¸í¼¼¼­Index

Sr	Object	Type
1	[dbo].[aegistransmsg]	Table
2	[dbo].[Agents]	Table
3	[dbo].[BankCount]	Table
4	[dbo].[Cards]	Table
5	[dbo].[Custom]	Table
6	[dbo].[dtproperties]	Table
7	[dbo].[FAQ]	Table
8	[dbo].[HZoneInfo]	Table
9	[dbo].[Members]	Table
10	[dbo].[Members_151220]	Table
11	[dbo].[Menus]	Table
12	[dbo].[Modify]	Table
13	[dbo].[News]	Table
14	[dbo].[Notice]	Table
15	[dbo].[Stores]	Table
16	[dbo].[sysdiagrams]	Table
17	[dbo].[TradeAcc]	Table
18	[dbo].[TradeCard]	Table
19	[dbo].[tradeCard_bak_20130307]	Table
20	[dbo].[TradeHando]	Table
21	[dbo].[VAccounts]	Table
22	[dbo].[VAccounts_Edit]	Table
23	[dbo].[WEBMenus]	Table
24	[dbo].[WEBStoreList]	Table
25	[dbo].[view_point_detail_info]	View

Index
Table:[dbo].[aegistransmsg]

Description

°¡»ó°èÁ ÀÔ±ÝÅ뺸 Àü¹® Å×À̺í

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	RECORDTYPE	VARCHAR(1)	Y	Record±¸ºÐ ("D" ÀÔ·Â)
2	SERVICEID	VARCHAR(8)	Y	°¡¸ÍÁ¡ÄÚµå
3	WORKFIELD	VARCHAR(1)	Y	󸮳»¿ª(½Å±Ô : 'N', Ãß°¡ : 'A', ¼öÁ¤ : 'U', »èÁ¦ : 'D')
4	SUCCESSYN	VARCHAR(1)	Y	󸮰á°ú
5	RESULTCD	VARCHAR(4)	Y	°á°úÄÚµå
6	RESULTMSG	VARCHAR(30)	Y	°á°ú¸Þ½ÃÁö
7	TRNO	VARCHAR(30)	Y	û±¸°Å·¡¹øÈ£
8	VANO	VARCHAR(20)	Y	µî·Ï±¸ºÐ(¼ö³³°á°ú½Ã °¡»ó°èÁ¹øÈ£)
9	PAYMASMONTH	VARCHAR(6)	Y	û±¸¿ù (YYYYMM)
10	PAYMASDT	VARCHAR(8)	Y	û±¸ÀÏÀÚ (YYYYMMDD)
11	RCPSTARTDT	VARCHAR(8)	Y	³³ºÎ½ÃÀÛÀÏ (YYYYMMDD)
12	RCPSTARTTM	VARCHAR(4)	Y	³³ºÎ½ÃÀ۽ð£(»ç¿ë¾ÈÇÔ)
13	RCPENDDT	VARCHAR(8)	Y	³³ºÎ¸¶°¨ÀÏ(YYYYMMDD)
14	RCPENDTM	VARCHAR(4)	Y	³³ºÎ¸¶°¨½Ã°£(»ç¿ë¾ÈÇÔ)
15	RCPPRTENDDT	VARCHAR(8)	Y	Ãâ·Â³³ºÎ¸¶°¨ÀÏ(YYYYMMDD)
16	RCPPRTENDTM	VARCHAR(4)	Y	Ãâ·Â³³ºÎ¸¶°¨½Ã°£(»ç¿ë¾ÈÇÔ)
17	CUSNM	VARCHAR(30)	Y	°í°´¸í
18	SMSYN	VARCHAR(1)	Y	SMSÀü¼Û¿©ºÎ(»ç¿ë¾ÈÇÔ) 'N'°ª ¼ÂÆÃ
19	MOBILENO	VARCHAR(12)	Y	°í°´ÈÞ´ëÆù¹øÈ£
20	EMAILYN	VARCHAR(1)	Y	À̸ÞÀÏÀü¼Û¿©ºÎ(»ç¿ë¾ÈÇÔ) 'N'°ª ¼ÂÆÃ
21	EMAIL	VARCHAR(50)	Y	°í°´À̸ÞÀÏÁÖ¼Ò(»ç¿ë¾ÈÇÔ)
22	CONTENT1	VARCHAR(30)	Y	ÂüÁ¶1
23	CONTENT2	VARCHAR(30)	Y	ÂüÁ¶2
24	CONTENT3	VARCHAR(30)	Y	ÂüÁ¶3
25	CONTENT4	VARCHAR(30)	Y	ÂüÁ¶4
26	REGSEQ	INT	N	Àü¹®¹øÈ£
27	CHATRNO	VARCHAR(30)	Y	Ç׸ñ°Å·¡¹øÈ£
28	ADJFIGRPCD	VARCHAR(5)	Y	ºÐÇÒÀÔ±ÝKEY
29	PAYITEMNM	VARCHAR(50)	Y	Ç׸ñ¸í
30	PAYITEMAMT	VARCHAR(10)	Y	Ç׸ñ±Ý¾×
31	PAYITEMYN	VARCHAR(1)	Y	Ç׸ñÇʼö¿©ºÎ(Y : Çʼö, N : Çʼö¾Æ´Ô)
32	RCPITEMYN	VARCHAR(1)	Y	Çö±Ý¿µ¼öÁõ¹ßÇà¿©ºÎ(Y : ¼Òµæ°øÁ¦¿ë, X : ÁöÃâÁõºù¿ë, N : ºñ´ë»ó)
33	RCPBUSINESSNO	VARCHAR(10)	Y	Çö±Ý¿µ¼öÁõ¹ßÇà»ç¾÷ÀÚÁ¤º¸
34	RCPPERSONNO	VARCHAR(20)	Y	Çö±Ý¿µ¼öÁõ¹ßÇà°í°´Á¤º¸ (ÁֹιøÈ£/ÇÚµåÆù)
35	PRTPAYITEMNM	VARCHAR(50)	Y	Ãâ·ÂÇ׸ñ¸í
36	PRTCONTENT1	VARCHAR(50)	Y	Ãâ·Âºñ°í³»¿ë
37	PRTSEQ	VARCHAR(2)	Y	Ãâ·Â¼ø¼­
38	TRANST	VARCHAR(2)	Y	Àü¼Û»óÅÂ(Àü¼Û»óÅÂ 01:Àü¼ÛÀü 02:Àü¼ÛÁß 07:Àü¼Û¿Ï·á 03:¼ö³³)
39	REGDT	DATETIME	Y	Àü¹®µî·ÏÀÏ
40	PAYDAY	VARCHAR(14)	Y	¼ö³³ÀϽÃ(YYYYMMDDHH24MISS)
41	RCPUSRNAME	VARCHAR(20)	Y	¼ö³³ÀÚ¸í
42	VANOBNKCD	VARCHAR(3)	Y	°¡»ó°èÁÂÀºÇà
43	BNKCD	VARCHAR(3)	Y	¼ö³³ÀºÇàÄÚµå
44	BCHCD	VARCHAR(4)	Y	¼ö³³ÁöÁ¡ÄÚµå
45	MDGUBN	VARCHAR(1)	Y	¸Åü±¸ºÐ
46	TRNDAY	VARCHAR(14)	Y	ó¸®ÀϽÃ(YYYYMMDDHH24MISS)
47	RCPAMT	VARCHAR(10)	Y	¼ö³³±Ý¾×
48	SVECD	VARCHAR(3)	Y
49	ReadYN	VARCHAR(1)	Y	ÀÐÀº°ÇÀÎÁö È®ÀÎÇÑ´Ù

Default Constraints

Sr.	Name	Column	Value
1	DF_aegistransmsg_ReadYN_1	ReadYN	('N')

Indexes

Sr.	Name	Type	Columns
1	PK_aegistransmsg	Clustered	REGSEQ

Index
Table:[dbo].[Agents]

Description

À¯Åë¸ÁÁ¤º¸ Å×À̺í

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	AgentCode	VARCHAR(10)	N	À¯Åë»çÄÚµå
2	AgentName	VARCHAR(50)	Y	À¯Åë¸Á¸í
3	ID	VARCHAR(16)	N	·Î±×ÀÎ ¾ÆÀ̵ð
4	AgentLevel	VARCHAR(1)	N	À¯Åë»ç ·¹º§
5	OwnerName	VARCHAR(50)	Y	´ëÇ¥ÀÚ¸í
6	CompanyName	VARCHAR(50)	Y	»óÈ£
7	CompanyCode	VARCHAR(10)	Y	»ç¾÷ÀÚ¹øÈ£
8	CompanyStyleCd	VARCHAR(10)	Y	¾÷Á¾ÄÚµå
9	CompanyStyle	VARCHAR(50)	Y	¾÷Á¾¸í
10	ZipCode	VARCHAR(6)	N	¿ìÆí¹øÈ£
11	Address	VARCHAR(100)	N	ÁÖ¼Ò
12	Address2	VARCHAR(50)	Y	»ó¼¼ÁÖ¼Ò
13	Phone	VARCHAR(20)	N	ÀüÈ­¹øÈ£
14	Mobile	VARCHAR(20)	Y	ÈÞ´ëÆù¹øÈ£
15	Fax	VARCHAR(20)	Y	Æѽº¹øÈ£
16	UpAgentCode	VARCHAR(10)	N	»óÀ§À¯Åë¸ÁÄÚµå
17	P_BankCd	CHAR(2)	Y	ÀÔ±ÝÀºÇàÄÚµå
18	P_AccountCd	CHAR(15)	Y	ÀÔ±ÝÀºÇà °èÁ¹øÈ£
19	P_BankOwner	VARCHAR(20)	Y	ÀÔ±ÝÁÖ¸í
20	P_Point	FLOAT	Y
21	P_Money	FLOAT	Y
22	Fee	FLOAT	Y	°¡¸ÍÁ¡À¯Ä¡¼ö¼ö·á
23	Kind	CHAR(1)	Y
24	del_flg	CHAR(1)	N	¿î¿µ±¸ºÐ(N:¿î¿µ, Y:ÁßÁö)
25	RegDate	DATETIME	N	µî·ÏÀÏÀÚ
26	ACardNum	VARCHAR(16)	Y	À¯Åë¸Á ¼ö¼ö·á Àû¸³Ä«µå

Refrence Keys

Sr.	Name	Column	Reference To
1	FK_Agents_Members	ID	[Members_151220].[ID]

Default Constraints

Sr.	Name	Column	Value
1	DF_Agents_P_Point1	P_Point	(0)
2	DF_Point_Agents_del_flg	del_flg	('N')
3	DF_Point_Agents_Fax	Fax	('--')
4	DF_Point_Agents_Mobile	Mobile	('--')
5	DF_Point_Agents_Phone	Phone	('--')
6	DF_Point_Agents_RegDate	RegDate	(getdate())

Indexes

Sr.	Name	Type	Columns
1	PK_Point_Agents	Clustered	AgentCode

Index
Table:[dbo].[BankCount]

Description

¼¼Æ²¹ðÅ© Àü¹®¹øÈ£ Å×À̺í

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	BankTrdNum	VARCHAR(6)	N	Àü¹®¹øÈ£(ÀÚµ¿Áõ°¡ 00½Ã ¸®¼Â)

Default Constraints

Sr.	Name	Column	Value
1	DF_BankCount_BankTrdNum	BankTrdNum	((0))

Index
Table:[dbo].[Cards]

Description

Ä«µåÁ¤º¸ Å×À̺í

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	IDX	BIGINT	N
2	CardNum	VARCHAR(16)	N	Ä«µå¹øÈ£
3	CardPwd	VARCHAR(4)	N	Ä«µåºñ¹ø
4	CustomCode	VARCHAR(10)	Y	ȸ¿øÄÚµå
5	GayPoint	FLOAT	N	°¡¿ëÆ÷ÀÎÆ®
6	UseYN	CHAR(1)	N	»ç¿ëÀ¯¹«
7	HQFeeRate	FLOAT	N	±â°¡º»»ç ¼ö¼ö·áÀ²
8	AGCode1	VARCHAR(10)	Y	À¯Åë¸Á1ÄÚµå
9	AGFeeRate1	FLOAT	N	À¯Åë¸Á1¼ö¼ö·áÀ²
10	AGCode2	VARCHAR(10)	Y	À¯Åë¸Á2ÄÚµå
11	AGFeeRate2	FLOAT	N	À¯Åë¸Á2¼ö¼ö·áÀ²
12	AGCode3	VARCHAR(10)	Y	À¯Åë¸Á3ÄÚµå
13	AGFeeRate3	FLOAT	N	À¯Åë¸Á3¼ö¼ö·áÀ²
14	AGCode4	VARCHAR(10)	Y	À¯Åë¸Á4ÄÚµå
15	AGFeeRate4	FLOAT	N	À¯Åë¸Á4¼ö¼ö·áÀ²
16	AGCode5	VARCHAR(10)	Y	À¯Åë¸Á5ÄÚµå
17	AGFeeRate5	FLOAT	N	À¯Åë¸Á5¼ö¼ö·áÀ²
18	AGCode6	VARCHAR(10)	Y	À¯Åë¸Á6ÄÚµå
19	AGFeeRate6	FLOAT	N	À¯Åë¸Á6¼ö¼ö·áÀ²
20	AGCode7	VARCHAR(10)	Y	À¯Åë¸Á7ÄÚµå
21	AGFeeRate7	FLOAT	N	À¯Åë¸Á7¼ö¼ö·áÀ²
22	StoreCode	VARCHAR(10)	Y	°¡¸ÍÁ¡ÄÚµå
23	CustomFeeRate	FLOAT	N	ȸ¿øÀû¸³À²
24	RegDate	CHAR(8)	N	µî·ÏÀÏÀÚ
25	RegTime	CHAR(6)	N	µî·Ï½Ã
26	CardType	NVARCHAR(6)	Y

Default Constraints

Sr.	Name	Column	Value
1	DF_Cards_AG1FeeRate3	AGFeeRate3	(0)
2	DF_Cards_AG1FeeRate5	AGFeeRate5	(0)
3	DF_Cards_AGFeeRate1	AGFeeRate1	(0)
4	DF_Cards_AGFeeRate2	AGFeeRate2	(0)
5	DF_Cards_AGFeeRate4	AGFeeRate4	(0)
6	DF_Cards_AGFeeRate6	AGFeeRate6	(0)
7	DF_Cards_AGFeeRate7	AGFeeRate7	(0)
8	DF_Cards_CustomFeeRate	CustomFeeRate	(0)
9	DF_Cards_GayPoint	GayPoint	(0)
10	DF_Cards_HQFeeRate	HQFeeRate	(0)
11	DF_Cards_RegDate	RegDate	(convert(char(8),getdate(),112))
12	DF_Cards_RegTime	RegTime	(replace(convert(char(8),getdate(),108),':',''))
13	DF_Cards_UseYN	UseYN	('N')

Indexes

Sr.	Name	Type	Columns
1	PK_Cards	Clustered	CardNum

Index
Table:[dbo].[Custom]

Description

ȸ¿øÁ¤º¸ Å×À̺í

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	CustomCode	VARCHAR(10)	N	ȸ¿øÄÚµå
2	CustomName	VARCHAR(50)	Y	ȸ¿ø¸í
3	CardNum	VARCHAR(16)	Y	Ä«µå¹øÈ£
4	ID	VARCHAR(16)	N	¾ÆÀ̵ð
5	ZipCode	VARCHAR(6)	Y	¿ìÆí¹øÈ£
6	Address	VARCHAR(100)	Y	ÁÖ¼Ò
7	Address2	VARCHAR(50)	Y	»ó¼¼ÁÖ¼Ò
8	Phone	VARCHAR(20)	N	ÀüÈ­¹øÈ£
9	Mobile	VARCHAR(20)	N	ÈÞ´ëÆù¹øÈ£
10	P_BankCd	CHAR(2)	Y	ÀÔ±ÝÀºÇàÄÚµå
11	P_AccountCd	CHAR(15)	Y	ÀԱݰèÁ¹øÈ£
12	P_BankOwner	VARCHAR(20)	Y	ÀÔ±ÝÁÖ¸í
13	RegDate	DATETIME	N	µî·ÏÀÏ
14	del_flg	CHAR(1)	N	¿î¿µ±¸ºÐ(N:Á¤»ó, Y:Áß´Ü)
15	AppUsePNum	VARCHAR(20)	Y	¾îÇûç¿ëÆù¹øÈ£
16	AppUseDate	CHAR(8)	Y	¾îÇÃÃÖÃÊ ·Î±×ÀÎÀÏÀÚ
17	AppUseTime	CHAR(6)	Y	¾îÇÃÃÖÃÊ ·Î±×ÀÎ ½Ã°£

Default Constraints

Sr.	Name	Column	Value
1	DF_Custom_del_flg	del_flg	('N')
2	DF_Custom_Mobile	Mobile	('--')
3	DF_Custom_Phone	Phone	('--')
4	DF_Custom_RegDate	RegDate	(getdate())

Indexes

Sr.	Name	Type	Columns
1	PK_Custom	Clustered	CustomCode

Index
Table:[dbo].[dtproperties]

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	id	INT	N
2	objectid	INT	Y
3	property	VARCHAR(64)	N
4	value	VARCHAR(255)	Y
5	uvalue	NVARCHAR(510)	Y
6	lvalue	IMAGE	Y
7	version	INT	N

Default Constraints

Sr.	Name	Column	Value
1	DF__dtpropert__versi__2C3393D0	version	(0)

Indexes

Sr.	Name	Type	Columns
1	pk_dtproperties	Clustered	id property

Index
Table:[dbo].[FAQ]

Description

FAQ Å×À̺í

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	seq	INT	N
2	title	VARCHAR(100)	Y
3	name	VARCHAR(100)	Y
4	sdate	DATETIME	N
5	visited	INT	Y
6	contents	TEXT	Y
7	password	VARCHAR(5)	Y
8	email	VARCHAR(100)	Y
9	userip	VARCHAR(20)	Y
10	ref_num	INT	Y
11	dep_num	INT	Y
12	seq_num	INT	Y
13	StoreID	VARCHAR(16)	Y
14	DelFlag	VARCHAR(1)	N

Default Constraints

Sr.	Name	Column	Value
1	DF_FAQ_DelFlag	DelFlag	('N')
2	DF_FAQ_sdate	sdate	(getdate())
3	DF_FAQ_visited	visited	('0')

Index
Table:[dbo].[HZoneInfo]

Description

¿ìÆí¹øÈ£ ¹× ÁÖ¼Ò Å×À̺í

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	HZone	VARCHAR(4)	N
2	ZipCode	VARCHAR(6)	Y
3	City	VARCHAR(10)	N
4	Gu	VARCHAR(20)	N
5	Dong	VARCHAR(20)	Y
6	Street	VARCHAR(50)	Y
7	FirstBunzi	VARCHAR(10)	Y
8	LastBunzi	VARCHAR(10)	Y

Index
Table:[dbo].[Members]

Description

¸ðµç±ÇÇÑÀÇ ±âº»Á¤º¸ Å×À̺í

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ID	VARCHAR(16)	N	¾ÆÀ̵ð
2	Passwd	VARCHAR(16)	N	ºñ¹Ð¹øÈ£
3	NameKr	VARCHAR(20)	N	±ÇÇѸí
4	PeopleCode	VARCHAR(13)	Y	ÁֹιøÈ£
5	SelfStory	VARCHAR(4000)	Y	ºñ°í
6	Type	VARCHAR(10)	N	񀀥

Indexes

Sr.	Name	Type	Columns
1	PK_Point_Members	Clustered	ID

Index
Table:[dbo].[Members_151220]

Description

¸ðµç±ÇÇÑÀÇ ±âº»Á¤º¸ Å×À̺í

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ID	VARCHAR(16)	N	¾ÆÀ̵ð
2	Passwd	VARCHAR(16)	N	ºñ¹Ð¹øÈ£
3	NameKr	VARCHAR(20)	N	±ÇÇѸí
4	PeopleCode	VARCHAR(13)	N	ÁֹιøÈ£
5	SelfStory	VARCHAR(4000)	Y	ºñ°í
6	Type	VARCHAR(10)	N	񀀥

Indexes

Sr.	Name	Type	Columns
1	PK_Point_Members_1	Clustered	ID

Index
Table:[dbo].[Menus]

Description

°ü¸®ÀÚ »ó´Ü ¸Þ´º±¸¼º Å×À̺í

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	IDX	INT	N
2	menuCode	CHAR(5)	N	¸Þ´ºÄÚµå
3	menuName	VARCHAR(30)	N	¸Þ´º¸í
4	menuUrl	VARCHAR(100)	Y	¸Þ´ºURL
5	menuImg	VARCHAR(50)	Y	Ãâ·ÂÀ̹ÌÁö
6	menuAuth	VARCHAR(10)	N	¸Þ´º»ç¿ë·¹º§

Indexes

Sr.	Name	Type	Columns
1	PK_Menus	Clustered	IDX

Index
Table:[dbo].[Modify]

Description

Á¤º¸¼öÁ¤ ³»¿ª Å×À̺í

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	Modify_Idx	INT	N
2	Modify_ID	VARCHAR(20)	N	¼öÁ¤´ë»ó ¾ÆÀ̵ð
3	Modify_Name	VARCHAR(20)	N	¼öÁ¤ÇÑ ±ÇÇѸí
4	Modify_IP	VARCHAR(20)	N	¼öÁ¤ÇÑIP
5	Modify_Code	VARCHAR(20)	Y	¼öÁ¤´ë»ó ÄÚµå
6	Modify_ActLog	VARCHAR(800)	N	¼öÁ¤³»¿ë
7	Modify_Date	DATETIME	N	¼öÁ¤ÀϽÃ

Default Constraints

Sr.	Name	Column	Value
1	DF_point_Modify_Modify_Date	Modify_Date	(getdate())

Index
Table:[dbo].[News]

Description

À̺¥Æ®&News Å×À̺í

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	seq	INT	N
2	title	VARCHAR(100)	Y
3	name	VARCHAR(100)	Y
4	sdate	DATETIME	N
5	visited	INT	Y
6	contents	TEXT	Y
7	password	VARCHAR(5)	Y
8	email	VARCHAR(100)	Y
9	userip	VARCHAR(20)	Y
10	ref_num	INT	Y
11	dep_num	INT	Y
12	seq_num	INT	Y
13	StoreID	VARCHAR(16)	Y
14	DelFlag	VARCHAR(1)	N

Default Constraints

Sr.	Name	Column	Value
1	DF_News_DelFlag	DelFlag	('N')
2	DF_News_sdate	sdate	(getdate())
3	DF_News_visited	visited	('0')

Index
Table:[dbo].[Notice]

Description

°øÁö»çÇ× Å×À̺í

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	seq	INT	N
2	title	VARCHAR(100)	Y
3	name	VARCHAR(100)	Y
4	sdate	DATETIME	N
5	visited	INT	Y
6	contents	TEXT	Y
7	password	VARCHAR(5)	Y
8	email	VARCHAR(100)	Y
9	userip	VARCHAR(20)	Y
10	ref_num	INT	Y
11	dep_num	INT	Y
12	seq_num	INT	Y
13	StoreID	VARCHAR(16)	Y
14	DelFlag	VARCHAR(1)	N

Default Constraints

Sr.	Name	Column	Value
1	DF_Notice_DelFlag	DelFlag	('N')
2	DF_Notice_sdate	sdate	(getdate())
3	DF_Notice_visited	visited	('0')

Index
Table:[dbo].[Stores]

Description

°¡¸ÍÁ¡Á¤º¸ Å×À̺í

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	StoreCode	VARCHAR(12)	N	°¡¸ÍÁ¡ÄÚµå
2	Patm_id	VARCHAR(10)	Y
3	StoreName	VARCHAR(50)	Y	°¡¸ÍÁ¡¸í
4	ID	VARCHAR(16)	N	¾ÆÀ̵ð
5	OwnerName	VARCHAR(50)	Y	´ëÇ¥ÀÚ¸í
6	CompanyCode	VARCHAR(10)	Y	»ç¾÷ÀÚ¹øÈ£
7	CompanyStyleCd	VARCHAR(10)	Y
8	CompanyStyle	VARCHAR(50)	Y
9	ZipCode	VARCHAR(6)	N	¿ìÆí¹øÈ£
10	Address	VARCHAR(100)	N	ÁÖ¼Ò
11	Address2	VARCHAR(50)	Y	»ó¼¼ÁÖ¼Ò
12	Phone	VARCHAR(20)	N	ÀüÈ­¹øÈ£
13	Mobile	VARCHAR(20)	Y	ÈÞ´ëÆù¹øÈ£
14	Fax	VARCHAR(20)	Y	Æѽº¹øÈ£
15	AgentCode	VARCHAR(10)	N	¼Ò¼Ó»çÄÚµå
16	P_BankCd	CHAR(2)	Y	ÀÔ±ÝÀºÇàÄÚµå
17	P_AccountCd	CHAR(15)	Y	ÀԱݰèÁ¹øÈ£
18	P_BankOwner	VARCHAR(20)	Y	ÀÔ±ÝÁÖ¸í
19	TabCnt	INT	Y
20	Kind	CHAR(1)	Y
21	del_flg	CHAR(1)	N	¿î¿µ(N) ÇØÁö(Y) ±¸ºÐ
22	upfile	VARCHAR(100)	Y
23	upfile1	VARCHAR(100)	Y
24	upfile2	VARCHAR(100)	Y
25	upfile3	VARCHAR(100)	Y
26	upfile4	VARCHAR(100)	Y
27	upfile5	VARCHAR(100)	Y
28	RegDate	DATETIME	N	µî·ÏÀϽÃ
29	TestFlg	VARCHAR(1)	N
30	P_Point	FLOAT	N	°¡¸ÍÁ¡Çѵµ
31	P_Money	FLOAT	N
32	Fee	FLOAT	Y
33	DCCouponCnt	FLOAT	Y
34	DCRate	FLOAT	N
35	EventYN	VARCHAR(1)	N
36	DCYN	VARCHAR(1)	Y
37	HomepageYN	VARCHAR(1)	N
38	TabUseMax	INT	N
39	JukFeeRate	FLOAT	N	Çö±ÝÀû¸³ ¼ö¼ö·áÀ²
40	UseFeeRate	FLOAT	N	»ç¿ë ¼ö¼ö·áÀ²
41	VanCompany	VARCHAR(20)	Y
42	VanCode	VARCHAR(20)	Y	KSNET °Å·¡ °¡¸ÍÁ¡¹øÈ£
43	VanCode_JTNet	VARCHAR(20)	Y	JTNET °Å·¡ °¡¸ÍÁ¡¹øÈ£
44	VanCode_Smartro	VARCHAR(20)	Y	Firstdata °Å·¡ °¡¸ÍÁ¡¹øÈ£
45	CardJukFeeRate	FLOAT	Y	Ä«µåÀû¸³ ¼ö¼ö·áÀ²
46	JasaJukFeeRate	FLOAT	Y	ÀÚ»çÄ«µåÀû¸³ ¼ö¼ö·áÀ²
47	HCardNum	VARCHAR(16)	Y	°¡¸ÍÁ¡ ÇѵµÁ¶È¸¿ë Ä«µå¹øÈ£

Refrence Keys

Sr.	Name	Column	Reference To
1	FK_Stores_Members	ID	[Members_151220].[ID]

Default Constraints

Sr.	Name	Column	Value
1	DF_point_Stores_del_flg	del_flg	('N')
2	DF_point_Stores_Fax	Fax	('--')
3	DF_point_Stores_Mobile	Mobile	('--')
4	DF_point_Stores_P_Money	P_Money	(0)
5	DF_point_Stores_P_Point	P_Point	(0)
6	DF_point_Stores_Phone	Phone	('--')
7	DF_point_Stores_RegDate	RegDate	(getdate())
8	DF_Stores_DCCouponCnt	DCCouponCnt	(0)
9	DF_Stores_DCRate	DCRate	(0)
10	DF_Stores_DCYN	DCYN	('N')
11	DF_Stores_DCYN1	TabUseMax	(0)
12	DF_Stores_EventYN	EventYN	('N')
13	DF_Stores_HomepageYN	HomepageYN	('Y')
14	DF_Stores_JukFeeRate	JukFeeRate	(0)
15	DF_Stores_JukFeeRate1	CardJukFeeRate	(0)
16	DF_Stores_JukFeeRate2	JasaJukFeeRate	(0)
17	DF_Stores_P_Point1	TestFlg	('N')
18	DF_Stores_TabCnt	TabCnt	(0)
19	DF_Stores_UseFeeRate	UseFeeRate	(0)

Indexes

Sr.	Name	Type	Columns
1	PK_point_Stores	Clustered	StoreCode

Index
Table:[dbo].[sysdiagrams]

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	name	SYSNAME	N
2	principal_id	INT	N
3	diagram_id	INT	N
4	version	INT	Y
5	definition	VARBINARY	Y

Indexes

Sr.	Name	Type	Columns
1	PK__sysdiagr__C2B05B614CC05EF3	Clustered	diagram_id
2	UK_principal_name	Nonclustered	name principal_id

Index
Table:[dbo].[TradeAcc]

Description

ȸ¿ø Æ÷ÀÎÆ®->°èÁ ÀÌü³»¿ª Å×À̺í

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	IDX	INT	N
2	CardNum	VARCHAR(16)	N	ÀÌü´ë»óÄ«µå¹øÈ£
3	TranPoint	INT	N	ÀÌü±Ý¾×
4	P_BankCd	CHAR(2)	N	ÀÌüÀºÇàÄÚµå
5	P_AccountCd	VARCHAR(15)	N	ÀÌü°èÁ¹øÈ£
6	RegDate	CHAR(8)	N	ÀÌüÀÏÀÚ
7	RegTime	CHAR(6)	N	ÀÌü½Ã°£
8	AccTranFee	INT	N

Default Constraints

Sr.	Name	Column	Value
1	DF_TradeAcc_AccTranFee	AccTranFee	((0))
2	DF_TradeAcc_RegDate	RegDate	(CONVERT([char](8),getdate(),(112)))
3	DF_TradeAcc_RegTime	RegTime	(replace(CONVERT([char](8),getdate(),(108)),':',''))
4	DF_TradeAcc_TranPoint	TranPoint	((0))

Indexes

Sr.	Name	Type	Columns
1	PK_TradeAcc	Clustered	IDX

Index
Table:[dbo].[TradeCard]

Description

Ä«µå°Å·¡³»¿ª Å×À̺í

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	IDX	INT	N
2	StoreCode	VARCHAR(10)	N	°¡¸ÍÁ¡ÄÚµå
3	CardNum	VARCHAR(16)	N	Ä«µå¹øÈ£
4	PayType	VARCHAR(2)	Y	±¸ºÐ(01:Çö±Ý 02:½Å¿ë 03:Á÷ºÒ 04:ÀÚ»ç)
5	AuthNum	VARCHAR(12)	N	½ÂÀιøÈ£
6	ChujukNum	VARCHAR(12)	Y	ÃßÀû¹øÈ£
7	VAN	VARCHAR(10)	Y	¹ê»ç±¸ºÐ
8	TrdType	VARCHAR(20)	N	°Å·¡±¸ºÐ(»ç¿ë0500 »ç¿ëÃë¼Ò0600 Àû¸³0300 Àû¸³Ãë¼Ò0400 ÃæÀü0800)
9	TrdMoney	FLOAT	N	°Å·¡±Ý¾×
10	MakeFee	FLOAT	N	¹ß»ý¼ö¼ö·á(°¡¸ÍÁ¡Â÷°¨, °í°´Â÷°¨)
11	TakeFee	FLOAT	N	°í°´Àû¸³, °í°´»ç¿ë ¼ö¼ö·á
12	TradeDate	VARCHAR(8)	N	°Å·¡ÀÏÀÚ
13	TradeTime	VARCHAR(6)	Y	°Å·¡½Ã°£
14	AccTrdYN	VARCHAR(1)	N	»ç¿ë½Ã ÀÌü¼º°ø¿©ºÎ
15	HQFee	FLOAT	N	±â°¡º»»ç¼ö¼ö·á
16	AGCode1	VARCHAR(10)	Y	À¯Åë¸Á1ÄÚµå
17	AGFee1	FLOAT	N	À¯Åë¸Á1¼ö¼ö·á
18	AGCode2	VARCHAR(10)	Y	À¯Åë¸Á2ÄÚµå
19	AGFee2	FLOAT	N	À¯Åë¸Á2¼ö¼ö·á
20	AGCode3	VARCHAR(10)	Y	À¯Åë¸Á3ÄÚµå
21	AGFee3	FLOAT	N	À¯Åë¸Á3¼ö¼ö·á
22	AGCode4	VARCHAR(10)	Y	À¯Åë¸Á4ÄÚµå
23	AGFee4	FLOAT	N	À¯Åë¸Á4¼ö¼ö·á
24	AGCode5	VARCHAR(10)	Y	À¯Åë¸Á5ÄÚµå
25	AGFee5	FLOAT	N	À¯Åë¸Á5¼ö¼ö·á
26	AGCode6	VARCHAR(10)	Y	À¯Åë¸Á6ÄÚµå
27	AGFee6	FLOAT	N	À¯Åë¸Á6¼ö¼ö·á
28	AGCode7	VARCHAR(10)	Y	À¯Åë¸Á7ÄÚµå
29	AGFee7	FLOAT	N	À¯Åë¸Á7¼ö¼ö·á
30	AgentCode	VARCHAR(10)	Y	À¯Ä¡À¯Åë¸ÁÄÚµå
31	AgentFee	FLOAT	N	À¯Ä¡À¯Åë¸Á¼ö¼ö·á
32	CanCelYN	VARCHAR(1)	N	Ãë¼ÒÀ¯¹«
33	RegDate	CHAR(8)	N	µî·ÏÀÏÀÚ
34	RegTime	CHAR(6)	N	µî·Ï½Ã°£

Default Constraints

Sr.	Name	Column	Value
1	DF_TradeCard_AccTrdYN	AccTrdYN	('N')
2	DF_TradeCard_AgentFee	AgentFee	((0))
3	DF_TradeCard_AGFeeRate1	AGFee1	((0))
4	DF_TradeCard_AGFeeRate2	AGFee2	((0))
5	DF_TradeCard_AGFeeRate3	AGFee3	((0))
6	DF_TradeCard_AGFeeRate4	AGFee4	((0))
7	DF_TradeCard_AGFeeRate5	AGFee5	((0))
8	DF_TradeCard_AGFeeRate6	AGFee6	((0))
9	DF_TradeCard_AGFeeRate7	AGFee7	((0))
10	DF_TradeCard_CanCelYN	CanCelYN	('N')
11	DF_TradeCard_CustomFee	TakeFee	((0))
12	DF_TradeCard_HQFeeRate	HQFee	((0))
13	DF_TradeCard_PayType	PayType	((1))
14	DF_TradeCard_RegDate	RegDate	(CONVERT([char](8),getdate(),(112)))
15	DF_TradeCard_RegTime	RegTime	(replace(CONVERT([char](8),getdate(),(108)),':',''))
16	DF_TradeCard_TakeFee	MakeFee	((0))
17	DF_TradeCard_TrdMoney	TrdMoney	((0))

Indexes

Sr.	Name	Type	Columns
1	PK_TradeCard	Clustered	IDX

Index
Table:[dbo].[tradeCard_bak_20130307]

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	IDX	INT	N
2	StoreCode	VARCHAR(10)	N
3	CardNum	VARCHAR(16)	N
4	PayType	VARCHAR(2)	Y
5	AuthNum	VARCHAR(12)	N
6	ChujukNum	VARCHAR(12)	Y
7	VAN	VARCHAR(10)	Y
8	TrdType	VARCHAR(20)	N
9	TrdMoney	FLOAT	N
10	MakeFee	FLOAT	N
11	TakeFee	FLOAT	N
12	TradeDate	VARCHAR(8)	N
13	TradeTime	VARCHAR(6)	Y
14	AccTrdYN	VARCHAR(1)	N
15	HQFee	FLOAT	N
16	AGCode1	VARCHAR(10)	Y
17	AGFee1	FLOAT	N
18	AGCode2	VARCHAR(10)	Y
19	AGFee2	FLOAT	N
20	AGCode3	VARCHAR(10)	Y
21	AGFee3	FLOAT	N
22	AGCode4	VARCHAR(10)	Y
23	AGFee4	FLOAT	N
24	AGCode5	VARCHAR(10)	Y
25	AGFee5	FLOAT	N
26	AGCode6	VARCHAR(10)	Y
27	AGFee6	FLOAT	N
28	AGCode7	VARCHAR(10)	Y
29	AGFee7	FLOAT	N
30	AgentCode	VARCHAR(10)	Y
31	AgentFee	FLOAT	N
32	CanCelYN	VARCHAR(1)	N
33	RegDate	CHAR(8)	N
34	RegTime	CHAR(6)	N

Index
Table:[dbo].[TradeHando]

Description

°¡¸ÍÁ¡Çѵµ ÃæÀü³»¿ª Å×À̺í

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	IDX	INT	N
2	StoreCode	VARCHAR(10)	N	°¡¸ÍÁ¡ÄÚµå
3	TrdAM	VARCHAR(10)	Y	ÀÚµ¿¼öµ¿ ±¸ºÐ
4	TrdType	VARCHAR(20)	N	ÃæÀü Â÷°¨ ±¸ºÐ
5	TrdMoney	BIGINT	N	ÃæÀü¹× Â÷°¨ ±Ý¾×
6	RegDate	CHAR(8)	N	µî·ÏÀÏÀÚ
7	RegTime	CHAR(6)	N	µî·Ï½Ã°£

Default Constraints

Sr.	Name	Column	Value
1	DF_HandoTrade_RegDate	RegDate	(CONVERT([char](8),getdate(),(112)))
2	DF_HandoTrade_RegTime	RegTime	(replace(CONVERT([char](8),getdate(),(108)),':',''))

Indexes

Sr.	Name	Type	Columns
1	PK_HandoTrade	Clustered	IDX

Index
Table:[dbo].[VAccounts]

Description

°¡»ó°èÁ¹øÈ£ Å×À̺í

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	IDX	INT	N
2	VAccNum	VARCHAR(20)	N	°¡»ó°èÁ¹øÈ£
3	MemberCode	VARCHAR(20)	Y	Ä«µå¹øÈ£ ȤÀº »ç¿ë±ÇÇÑÄÚµå
4	VAccBankCd	VARCHAR(2)	N	°¡»ó°èÁ ÀºÇàÄÚµå
5	GayPoint	FLOAT	N	°èÁÂÀܾ×
6	UseFlg	VARCHAR(1)	N	1:»ç¿ëÁß(Ä«µåµî·Ï½Ã 1·Îµî·Ï), 0:°¡¸ÍÁ¡ºÎ¿©¿ë(°¡¸ÍÁ¡ Ä«µåµî·Ï½Ã 0·Îµî·Ï)

Default Constraints

Sr.	Name	Column	Value
1	DF_StoresVAcc_GayPoint	GayPoint	(0)
2	DF_VAccounts_UseFlg	UseFlg	(0)

Indexes

Sr.	Name	Type	Columns
1	PK_VAccounts	Clustered	VAccNum

Index
Table:[dbo].[VAccounts_Edit]

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	IDX	INT	N
2	VAccNum	VARCHAR(20)	N
3	MemberCode	VARCHAR(20)	Y
4	VAccBankCd	VARCHAR(2)	N
5	GayPoint	FLOAT	N
6	UseFlg	VARCHAR(1)	N

Indexes

Sr.	Name	Type	Columns
1	PK_VAccounts_Edit	Clustered	VAccNum

Index
Table:[dbo].[WEBMenus]

Description

ȨÆäÀÌÁö °¡¸ÍÁ¡°ü¸®ÀÚ »ó´Ü ¸Þ´º Å×À̺í

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	IDX	INT	N
2	menuCode	CHAR(5)	N
3	menuName	VARCHAR(30)	N
4	menuUrl	VARCHAR(100)	Y
5	menuImg	VARCHAR(50)	Y
6	menuAuth	VARCHAR(10)	N

Indexes

Sr.	Name	Type	Columns
1	PK_WEBMenus	Clustered	IDX

Index
Table:[dbo].[WEBStoreList]

Description

ȨÆäÀÌÁö °¡¸ÍÁ¡ ³ëÃâ ¼³Á¤ Å×À̺í

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	IDX	INT	N
2	StoreCode	VARCHAR(12)	N
3	Flg_Giga	VARCHAR(1)	N
4	Flg_Damoa	VARCHAR(1)	N
5	Flg_Double	NCHAR(2)	N

Default Constraints

Sr.	Name	Column	Value
1	DF_WEBStoreList_Flg_Damoa	Flg_Damoa	('N')
2	DF_WEBStoreList_Flg_Double	Flg_Double	('N')
3	DF_WEBStoreList_Flg_Giga	Flg_Giga	('N')

Index
View:[dbo].[view_point_detail_info]

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	CardNum	VARCHAR(16)	N
2	tradeDate	VARCHAR(8)	N
3	reg_date	VARCHAR(33)	Y
4	point_gubun	VARCHAR(6)	N
5	TrdMoney	FLOAT	N
6	fee_0300	FLOAT	N
7	fee_0400	FLOAT	N
8	fee_0500	FLOAT	N
9	fee_0600	FLOAT	N
10	fee_0800	FLOAT	N
11	StoreCode	VARCHAR(10)	N