Help with record definition
"john_price_137" <[email protected]>
| Newsgroups | gmane.comp.java.orm.simpleorm |
|---|---|
| Message-ID | <[email protected]> |
Help, I have a table with the following definition:
CREATE TABLE USER_ROLES (
USER_NAME VARCHAR(20) NOT NULL,
ROLE_ID INTEGER NOT NULL
);
PRIMARY KEY (USER_NAME, ROLE_ID);
FOREIGN KEY (USER_NAME) REFERENCES USERS (USER_NAME);
FOREIGN KEY (ROLE_ID) REFERENCES "ROLE" (ROLE_ID);
and have defined a class for it as:
public class UserRole extends SRecordInstance
{
public static final SRecordMeta meta = new
RecordMeta(UserRole.class, "USER_ROLES");
public static final SFieldString USER_NAME = new
SFieldString(meta, "USER_NAME", 20, SCon.SFD_PRIMARY_KEY);
public static final SFieldLong ROLE_ID = new SFieldLong(meta,
"ROLE_ID", SCon.SFD_PRIMARY_KEY);
}
is it possible to define references to the USERS and ROLE tables ?
and how do I do it!
------------------------ Yahoo! Groups Sponsor --------------------~-->
Yahoo! Groups gets a make over. See the new email design.
http://us.click.yahoo.com/hOt0.A/lOaOAA/yQLSAA/5cFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/SimpleORM/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/SimpleORM/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[email protected]
mailto:[email protected]
<*> To unsubscribe from this group, send an email to:
[email protected]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/