TEAM_FAVORITES_USERS

The table stores

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

TEAM_TEAMS

TEAM_ID

TEAM_ID

KNTA_USERS

USER_ID

USER_ID

Column Descriptions

Column Name

Null?

Data Type

Description

TEAM_ID

NOT NULL

NUMBER

ID of the favorite team

USER_ID

NOT NULL

NUMBER

 ID of the user who added the team as favorite

FAVORITE_TIME

NULLABLE

TIMESTAMP(6)

 Time when the team was added as favorite

Indexes

Index Name

Index Type

Sequence

Column Name

TEAM_FAVORITES_USERS_N1

NONUNIQUE

1

TEAM_ID

TEAM_FAVORITES_USERS_N2

NONUNIQUE

1

USER_ID

Sequences

This table does not have sequences.