deffpuzzl-STVM
/
tbl_user_info.def

set TABLE=20
set TABLESPACE=1000

create table TBL_USER_INFO
(
    acct_id	long,
    user_no	char(21),
    user_type	char[2],
    user_nm	char[81],
    user_addr	char[161],
    user_phone	char[31]
);

-- Create indexes
create unique index (user_no, user_type);
create index  (acct_id);