example_schema.ddl

关于HEBERNATE使用的一个简单例子

drop table Books;
drop table Users;
drop table Book_User_Link;
drop table Address2;
drop table Contacts;
drop sequence seq restrict;
create table Books (
   ID BIGINT not null,
   Name VARCHAR(255),
   primary key (ID)
);
create table Users (
   LogonID VARCHAR(255) not null,
   EmailAddress VARCHAR(255),
   LastLogon DATE,
   Password VARCHAR(255),
   Name VARCHAR(255),
   primary key (LogonID)
);
create table Book_User_Link (
   BookID BIGINT not null,
   UserID VARCHAR(255)
);
create table Address2 (
   ID VARCHAR(255) not null,
   City VARCHAR(255),
   State VARCHAR(255),
   Zip VARCHAR(255),
   primary key (ID)
);
create table Contacts (
   ID BIGINT not null,
   EmailAddress VARCHAR(255),
   Name VARCHAR(255),
   User_ID VARCHAR(255),
   primary key (ID)
);
alter table Book_User_Link add constraint FK6A78EA3876F019E4 foreign key (BookID) references Books;
alter table Book_User_Link add constraint FK6A78EA3897901A46 foreign key (UserID) references Users;
create index IX6A78EA3897901A46 on Book_User_Link (UserID);
create index IX6A78EA3876F019E4 on Book_User_Link (BookID);
alter table Contacts add constraint FKE207C4735A7381EF foreign key (User_ID) references Users;
create index IXE207C4735A7381EF on Contacts (User_ID);
create sequence seq;