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/
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.