search

salk31 / RedQueryBuilder

SQL Query Builder UI JavaScript component
http://redquerybuilder.appspot.com/
Eclipse Public License 1.0
96 stars 22 forks source link

ForeignKey JavaScript meta names are poor #11

Closed salk31 closed 10 years ago

salk31 commented 10 years ago

fk is the column(s) in the referencing table (called pk at the moment!?) pk, as used now, doesn't make sense.

Definition SQL is: FOREIGN KEY(col3) REFERENCES other_table(key_col)

A) fkColumnNames, referencedTableName and referencedColumnNames?

B) foreignKeyNames, references.tableName and references.columnNames CON - another object

C) columnNames, refTableName, refColumnNames PRO - same as H2 PRO - short

D) foreignKeyNames, referencedKeyNames, referencedTableName http://docs.oracle.com/cd/E11882_01/server.112/e40540/datainte.htm#CNCPT1649 http://publib.boulder.ibm.com/infocenter/soliddb/v6r3/index.jsp?topic=/com.ibm.swg.im.soliddb.sql.doc/doc/foreign.keys.html PRO - seems wide acceptance that referencing columns are the foreign keys PRO - "referenced" seems widely used.

E) foreignKeyNames, referenceKeyNames, referenceTableName http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/apex/r41/apexstart_a/apexstart_a.htm?cid=5707&ssid=5449720430072 CON - "reference" has other meanings, not clear that is being "referenced"

dmexia commented 10 years ago

thanks a lot for this explanation

salk31 commented 10 years ago

Hi Dmexia, Any preference between the options above? I think I'm leaning towards D