U++ framework: U++ SQL » How can .sch express a many-to-many relationship ?

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 :: Polls :: Message Navigator
E-mail to friend

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
Messages: 14291
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

[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) ] [

] [

]

Current Time: Sun Jul 12 13:38:37 GMT+2 2026

Total time taken to generate the page: 0.00556 seconds