create table T_USER_INFO
(
ID VARCHAR2(20) not null,
ACCOUNT VARCHAR2(255) not null,
PASSWORD VARCHAR2(255) not null,
NAME VARCHAR2(20) not null,
DEPARTMENT_ID VARCHAR2(20) not null,
SEX CHAR(1) not null,
BIRTHDAY VARCHAR2(10),
MOBILE VARCHAR2(11) not null,
EMAIL VARCHAR2(255),
MYLEVEL CHAR(1) not null,
CREATE_TIME DATE default SYSDATE not null,
STATE CHAR(1) not null,
USER_TYPE CHAR(1)
)
;
alter table T_USER_INFO
add constraint PK_USERINFO primary key (ACCOUNT);
create table T_DEPARTMENT
(
DEPARTMENT_ID VARCHAR2(20) not null,
DEPARTMENT_NAME VARCHAR2(255),
MANAGER VARCHAR2(255),
TOTAL_USER NUMBER(3) not null,
CREATE_TIME DATE default sysdate not null
)
;
comment on column T_DEPARTMENT.DEPARTMENT_ID
is ‘自增主键’;
comment on column T_DEPARTMENT.DEPARTMENT_NAME
is ‘部门名称’;
comment on column T_DEPAR