U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » How can .sch express a many-to-many relationship ? (A minimal DDL example is provided -- how should this be expressed in .sch?)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Return to the default flat view

Create a new topic

Submit Reply

Re: How can .sch express a many-to-many relationship ? [message #47694 is a reply to message #47468]

Tue, 07 March 2017 13:03

mirek is currently offline

mirek
Messages: 14260
Registered: November 2005

Ultimate Member

There might be errors, doing it from the head:

TABLE_(USER_ACCOUNT)
   ISERIAL  (ID) PRIMARY_KEY
   STRING_  (NAME, 255)
END_TABLE

TABLE_(ROLE)
   ISERIAL  (ID) PRIMARY_KEY
   INT_     (ASPECT)
   STRING_  (DESCRIPTION, 255)
END_TABLE

TABLE_(USER_ROLE)
   INT_     (USER_ACCOUNT_ID) REFERENCES(USER_ACCOUNT)
   INT_     (ROLE_ID) REFERENCES(ROLE)
   DUAL_PRIMARY_KEY (USER_ACCOUNT_ID, ROLE_ID)
END_TABLE

(I suspect it is too late for you to help, but putting it here for future reference...)

Report message to a moderator

Send a private message to this user

[Message index]

		How can .sch express a many-to-many relationship ? By: jfranks on Thu, 19 January 2017 23:48
		Re: How can .sch express a many-to-many relationship ? By: mirek on Tue, 07 March 2017 13:03

Previous Topic:	Huge error of Postgresql! Double fields by transmission to the program lose a fractional part!
Next Topic:	How to connect to ODBC??

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Mon Jun 02 16:03:31 CEST 2025

Total time taken to generate the page: 0.02773 seconds