Table without FKs
|
NTDFK
|
Table with one FK
|
NTFK
|
Table with more than 2 FKs
|
NTMTWOFK
|
Tables that contain exactly 2 foreign keys with presence of independent attributes
|
NTEXTWOFK
|
Attributes that are FK + NULL + Not UNIQUE
|
NAFKNNU
|
Attributes that are FK + NOT NULL + NOT UNIQUE
|
NAFKNNNU
|
Attributes that are FK + NOT NULL + UNIQUE
|
NAFKNNU
|
Attributes that are FK + NOT NULL + UNIQUE + NOT PK (FK is not equal to the PK)
|
NANNUNPK
|
Attribute (neither PK nor FK)
|
NA
|
Attribute + NOT NULL
|
NAN
|
Attribute NOT FK + UNIQUE
|
NANFKU
|
PK
|
NPK
|
Attribute with constraint with an integer greater than 0
|
NACHECK
|
CHECK constraint with enumeration
|
CHECK constraint
|
Attribute with Default Value constraint
|
NADef
|
Tables with tables share the same primary key
|
NTSAMEPK
|
FK is a reference to the same table
|
NUnaryRel
|
FK that is a reference to the same table, but it is accompanied by a trigger ON DELETE CASCADE
|
NTrRel
|