apt_zengin_data_kanren.sql

日本pjman公司erp系统 银行支付的DB和VB代码 BASE

/*
--########################################################
--#------------------------------------------------------#
--#丂丂丂僥乕僽儖柤丗慡嬧僨乕僞娭楢僩儔儞         丂丂丂 #
--#丂僆僽僕僃僋僩柤丗APT_ZENGIN_DATA_KANREN              #
--#------------------------------------------------------#
--#丂僶乕僕儑儞丗1.0.0                                   #
--#丂丂  嶌惉幰丗彫愇丂峎巎                              #
--#丂  丂嶌惉擔丗2002/08/21                              #
--#  嵟廔峏怴擔丗2002/08/26丂丂丂丂丂                    #
--########################################################
*/
DROP TABLE APT_ZENGIN_DATA_KANREN;

CREATE TABLE APT_ZENGIN_DATA_KANREN(
	FURIKOMI_NO			VARCHAR2(6),
	FURIKOMI_GYO_NO			VARCHAR2(6),
	SHIHARAI_NO			VARCHAR2(6),
	SHIHARAI_GYO_NO			VARCHAR2(3),
	SHIHARAI_CD			VARCHAR2(7),
	SHIHARAI_YMD			DATE,
	GINKOU_CD			VARCHAR2(2),
	SHIHARAI_BUNRUI			VARCHAR2(1)		DEFAULT '0',
	SHIHARAI_SEIKYU_MEMO	        VARCHAR2(30),
	DEL_FLG				VARCHAR2(1)		DEFAULT '0',
	INS_RECORD			VARCHAR2(27),
	UPD_RECORD			VARCHAR2(27),
CONSTRAINT PK_APT_ZENGIN_DATA_KANREN PRIMARY KEY (
	FURIKOMI_NO,
	FURIKOMI_GYO_NO,
	SHIHARAI_NO,
	SHIHARAI_GYO_NO,
	SHIHARAI_BUNRUI	
)
USING INDEX
PCTFREE 10
TABLESPACE ADMAN_INDEX
STORAGE(INITIAL 40K
	NEXT 1000K
	MINEXTENTS 1
	MAXEXTENTS 300
	PCTINCREASE 0
)
)
PCTFREE 10
PCTUSED 40
TABLESPACE ADMAN_DATA
STORAGE(INITIAL 40K
	NEXT 1000K
	MINEXTENTS 1
	MAXEXTENTS 300
	PCTINCREASE 0
);