CREATE TABLE BLC_USER_INFO_T
(CDUSER VARCHAR(128) COLLATE Japanese_CS_AS_KS_WS NOT NULL PRIMARY KEY,
CDLOGINPASSWORD VARBINARY(20) NULL,
CDPERSONALNO VARCHAR(128) COLLATE Japanese_CS_AS_KS_WS NULL,
NMLASTNAMEJ VARCHAR(62) COLLATE Japanese_CS_AS_KS_WS NULL,
NMFIRSTNAMEJ VARCHAR(62) COLLATE Japanese_CS_AS_KS_WS NULL,
NMLASTNAMEK VARCHAR(62) COLLATE Japanese_CS_AS_KS_WS NULL,
NMFIRSTNAMEK VARCHAR(62) COLLATE Japanese_CS_AS_KS_WS NULL,
NMLASTNAMEE VARCHAR(62) COLLATE Japanese_CS_AS_KS_WS NULL,
NMFIRSTNAMEE VARCHAR(62) COLLATE Japanese_CS_AS_KS_WS NULL,
CDBELONGTO VARCHAR(128) COLLATE Japanese_CS_AS_KS_WS NOT NULL,
CDJOBTITLE VARCHAR(128) COLLATE Japanese_CS_AS_KS_WS NOT NULL,
NMMAILADDRESS VARCHAR(128) COLLATE Japanese_CS_AS_KS_WS NULL,
NMTELOUTSIDE VARCHAR(128) COLLATE Japanese_CS_AS_KS_WS NULL,
NMTELEXTENSION VARCHAR(128) COLLATE Japanese_CS_AS_KS_WS NULL,
NUADMINAUTHORITY SMALLINT DEFAULT 0 NOT NULL,
NUALTERNATEAUTHORITY SMALLINT DEFAULT 0 NOT NULL,
CFLOGINSTATUS SMALLINT DEFAULT 0 NOT NULL,
CFSHARESTATUS SMALLINT DEFAULT 0 NOT NULL);
CREATE INDEX BLC_USER_INFO_NMLASTNAMEJ ON BLC_USER_INFO_T (NMLASTNAMEJ);
CREATE INDEX BLC_USER_INFO_NMFIRSTNAMEJ ON BLC_USER_INFO_T (NMFIRSTNAMEJ);
CREATE INDEX BLC_USER_INFO_CDBELONGTO ON BLC_USER_INFO_T (CDBELONGTO); |