How to create tables with foreign keys correctly?

blzkz

Hello again!

As I said before, I'm creating an application (to create "Jams"), i'm trying to understand now the database structure file (creation scripts).
By now I have this for foreign keys:

$Construct->Table('GroupUser');

$Construct
  ->PrimaryKey('GroupUserID')
    ->Column('UserID', 'int', FALSE, 'key')
    ->Column('GroupID', 'int', FALSE, 'key')
    ->Column('DateCreated', 'datetime', NULL)
    ->Column('DateUpdated', 'datetime', NULL)
    ->Column('IsPublic', 'tinyint(1)', '1')
    ->Set($Explicit, $Drop);

But I use also this when a FK is a PK member in another table:
->Column('GroupID', 'int', FALSE, array('primary', 'key'))

Although, in other applications I see they don't use "key" for FK's in some cases.

How's the better way to do it?

Thank you!

Off-topic: I ask under this category because I can't select "development", and I just upgraded to v2.2

Bleistivt

Vanilla doesn't make use of foreign key contraints in the database, so adding key or index is for optimization only.

whu606

@blzkz

I think @Linc or @Adrian can give you access to the Development category if you want it.

Linc

@whu606 done.

blzkz

Thank you @whu606 and @Linc

Bleistivt

Vanilla doesn't make use of foreign key contraints in the database, so adding key or index is for optimization only.