java/sql

pblic class User {
 private String  userName;
 private String name;
 private String address;
 private Set billingDetails;
......
}

public class BillingDetails {
 private String accountNumber;
 private String accountType;
 private User user;
....
}

create table USER (
 USERNAME VARCHAR(15) NOT NULL  PRIMARY KEY,
 NAME VARCHAR(50) NOT NULL,
 ADDRSS VARCHAR(100)
}

create table BILLIN_DETAILS (
 ACCOUNT_NUMBER VARCHAR(10) NOT　NULL PRIMARY Key,
 ACCOUNT_NAME VARCHAR(50) NOT　NULL,
 ACCOUNT_TYPE VARCHAR(2) NOT　NULL,
 USERNAME VARCHAR(15) FOREIGN KEY REFERENCES USER
)

back