Table: JTF_CAL_SHIFT_ASSIGN

Product:	JTF - CRM Foundation
Description:	Assign Shifts to a Calendar.
Implementation/DBA Data:	JTF.JTF_CAL_SHIFT_ASSIGN

Primary Key: JTF_CAL_SHIFTA_PK

1. CAL_SHIFT_ASSIGN_ID

Primary Key: JTF_CAL_SHIFTA_U1

1. CALENDAR_ID
2. SHIFT_ID
3. SHIFT_SEQUENCE_NUMBER

Primary Key: JTF_CAL_SHIFT_ASSIGN_PK

1. CAL_SHIFT_ASSIGN_ID

Primary Key: JTF_CAL_SHIFT_ASSIGN_U1

1. CALENDAR_ID
2. SHIFT_SEQUENCE_NUMBER
3. SHIFT_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
JTF_CAL_SHIFT_ASSIGN		JTF_CALENDARS_B	JTF_CAL_SHIFT_ASSIGN.CALENDAR_ID
JTF_CAL_SHIFT_ASSIGN		JTF_CAL_SHIFTS_B	JTF_CAL_SHIFT_ASSIGN.SHIFT_ID
JTF_CAL_SHIFT_ASSIGN		JTF_CALENDARS_B	JTF_CAL_SHIFT_ASSIGN.CALENDAR_ID
JTF_CAL_SHIFT_ASSIGN		JTF_CAL_SHIFTS_B	JTF_CAL_SHIFT_ASSIGN.SHIFT_ID