sql创建数据库表结构-- Create table
create table MNT_USER
(
id NVARCHAR2(50) not null,
name NVARCHAR2(50),
phone NVARCHAR2(50),
idcard NVARCHAR2(50),
email NVARCHAR2(100),
data_status NVARCHAR2(12) default0,
mnt_org_no NVARCHAR2(50)
)
tablespace DTER_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64
next 1
minextents 1
maxextents unlimited
);
-
- Add comments to the table
comment on table MNT_USER
sql数据库创建表步骤is'维保⼈员表';
-- Add comments to the columns
comment on column MNT_USER.id
is'主键';
comment on column MNT_USER.name
is'姓名';
comment on column MNT_USER.phone
is'电话';
comment on column MNT_USER.idcard
is'⾝份证';
comment on column ail
is'邮箱';
comment on column MNT_USER.data_status
is'数据状态';
comment on column _org_no
is'维保单位id';
-- Create/Recreate primary, unique and foreign key constraints
alter table MNT_USER
add constraint PK_MNT_0001 primary key (ID)
using index
tablespace DTER_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。