create_table.sql

来自「oracle技术手册供初学者」· SQL 代码 · 共 21 行

create table user_info
(
    loginname                   char(12) not null,
    create_ts 			date not null,
    update_ts 			date not null,
    status                     	char(1) not null,
    password			char(6) not null,
    register_dt			char(8) not null,
    nickname			char(20) not null,
    age				number(6) not null,
    income			number(12) not null,
    email			char(30) not null,
    address			varchar2(100) not null,
    introduction		varchar2(500) not null
) tablespace tbsdata;

create unique index user_info_x00 on user_info(loginname) tablespace tbsindex;

create unique index user_info_x01 on user_info(nickname) tablespace tbsindex;
create index user_info_x02 on user_info(register_dt) tablespace tbsindex;