Hi..
A bit stumped here.
My database structure is something like
this...
1) There can be several domains in the
system
2) Each user can be assigned to one or more
domains
3) For each of these assigned domains, the user can
have one or more assigned roles for the domain.
How do I efficiently model the USER_DOMAIN_ROLES table in terms of objects?
For simple one-many relationship it would be easy but I'm not sure how this
is done using hibernate.
PS: Table structure below
Thanks!
Regards
Kenneth
CREATE TABLE DOMAINS
(
ID NUMERIC(18,0) NOT NULL PRIMARY KEY, NAME VARCHAR(100) CHARACTER SET UNICODE_FSS, PARENT_ID NUMERIC(18,0) REFERENCES DOMAINS(ID) ON UPDATE CASCADE ON DELETE CASCADE, CREATE_TIME TIMESTAMP DEFAULT 'NOW' ); CREATE TABLE ROLES
(
ID SMALLINT NOT NULL, NAME VARCHAR(20) NOT NULL, ); CREATE TABLE USERS
(
ID NUMERIC(18,0) PRIMARY KEY, NAME VARCHAR(100), PASSWORDHASH CHAR(32) );
CREATE TABLE USER_DOMAIN_ROLES
(
USER_ID NUMERIC(18,0) REFERENCES USERS(ID) ON UPDATE CASCADE ON DELETE CASCADE, DOMAIN_ID NUMERIC(18,0) NOT NULL REFERENCES DOMAINS(ID) ON UPDATE CASCADE ON DELETE CASCADE, ROLE_ID SMALLINT NOT NULL REFERENCES ROLES(ID) ON UPDATE CASCADE ON DELETE CASCADE, PRIMARY KEY (USER_ID, DOMAIN_ID, ROLE_ID) ); ------------
My try at the object model ...
------------
class Domain {
private long
id;
private String
name;
private Timestamp
createTime;
}
class Roles {
private long
id;
private String
name;
}
class User {
private long
id;
private String
name;
private String
password; }
class UserDomainRoles {
??
};
|