Database > Schema PUBLIC > Table JOINTABLE

Table JOINTABLE

Looks like a join table

Summary

Columns

Name Type Comment
ID_TABLE1 INTEGER(10,0)*
ID_TABLE3 INTEGER(10,0)*

Relations

Table Type
TABLE1 N-1
TABLE3 N-1
TABLE5 1-N

Constraints, Indexes and Triggers

Table Type
TABLE5_FK1 Primary Key
JOINTABLE_FK1 Foreign Key To table TABLE1
JOINTABLE_FK2 Foreign Key To table TABLE3
TABLE5_FK1 Reverse Foreign Key From table TABLE5
PRIMARY_KEY_8 Index
JOINTABLE_FK2_INDEX_8 Index Unique

Columns

ID_TABLE1

ID_TABLE3

Primary Key

TABLE5_FK1

Foreign Keys

JOINTABLE_FK1

JOINTABLE_FK2

Reverse Foreign Keys

TABLE5_FK1

Indexes

PRIMARY_KEY_8

JOINTABLE_FK2_INDEX_8