Package org.odpi.openmetadata.adapters.connectors.resource.jdbc.ddl.postgres

Interface PostgreSQLForeignKey

All Known Implementing Classes:

RepositoryForeignKey

public interface PostgreSQLForeignKey

Defines a foreign key relationship between two tables.

Method Summary

Modifier and Type	Method	Description
String	getConstraintName()	Return the name of the constraint.
PostgreSQLColumn	getForeignKeyColumn()	Return the column in the table that is the foreign key.
PostgreSQLColumn	getReferenceColumn()	Return the primary key column in the reference table.
PostgreSQLTable	getReferenceTable()	Return details of the table where the primary key is located.
boolean	isDeleteCascade()	If the row with the primary key is deleted, should the rows with the foreign key also be deleted?
boolean	isUpdateCascade()	If the primary key value is changed, should the foreign key values change too?

Method Details

getConstraintName

String getConstraintName()

Return the name of the constraint.

Returns:

name

getForeignKeyColumn

PostgreSQLColumn getForeignKeyColumn()

Return the column in the table that is the foreign key.

Returns:

column

getReferenceTable

PostgreSQLTable getReferenceTable()

Return details of the table where the primary key is located.

Returns:

table

getReferenceColumn

PostgreSQLColumn getReferenceColumn()

Return the primary key column in the reference table.

Returns:

column

isDeleteCascade

boolean isDeleteCascade()

If the row with the primary key is deleted, should the rows with the foreign key also be deleted?

Returns:

boolean

isUpdateCascade

boolean isUpdateCascade()

If the primary key value is changed, should the foreign key values change too?

Returns:

boolean