create.sql

来自「一个上网上购物系统,它简单明确,如果你是一个jsp和JAVA的初学者,它是一个好」· SQL 代码 · 共 52 行

create table ResourceInfo(
	ResourceID char(10) not null,
	primary key(ResourceID)
);

create table AuthorityInfo(
	AuthorityID char(10) not null,
	primary key(AuthorityID)
);

create table UserDetail(
	UserID char(10) not null,
	UserName varchar2(255) not null,
	primary key(UserID)
);

create table GroupDetail(
	GroupID char(10) not null,
	GroupName varchar2(255) not null,
	primary key(GroupID)
);

create table UserInfo(
	UserID char(10) not null,
	GroupID char(10) not null,
	primary key(UserID,GroupID),
	constraint foreign key(UserID) references UserDetail(UserID),
	constraint foreign key(GroupID) references GroupDetail(GroupID)
);

create table GroupInfo(
	GroupID char(10) not null,
	SuperGroupID char(10) not null,
	primary key(GroupID,SuperGroupID),
	constraint foreign key(GroupID) references GroupDetail(GroupID),
	constraint foreign key(SuperGroupID) references GroupDetail(GroupID)
);

create table UserAclInfo(
	UserID char(10) not null,
	PermissionType char(1) not null,
	ResourceID char(10) not null,
	AuthorityID char(10) not null
);

create table GroupAclInfo(
	GroupID char(10) not null,
	PermissionType char(1) not null,
	ResourceID char(10) not null,
	AthorityID char(10) not null
);