CalendarSharing

Tables (5)

TB_MAP_CALENDAR_LABEL

  • CD_ID (Key1) — Primary key — NOT NULL
  • LABEL_ID (Key2) — Primary key — NOT NULL
  • LABEL_NAME (Field)
  • LABEL_ROLE (Field2)
  • N_TASK (Field3)
  • MODI_DATE (Field4)
  • MODIFIER_ID (Field5)

TB_MAP_LABEL_TASK

  • TASK_ID (Field)
  • LABEL_ID (Key2) — Foreign key → TB_MAP_CALENDAR_LABEL.LABEL_ID — NOT NULL

TB_MAP_USER_LABEL_FILTER

  • USER_ID (Field)
  • CD_ID (Key1) — Foreign key → TB_MAP_CALENDAR_LABEL.CD_ID — NOT NULL
  • LABEL_ID (Key22) — Foreign key → TB_MAP_CALENDAR_LABEL.LABEL_ID — NOT NULL
  • ON_OFF (Field2)

TB_MAP_USER_USER_FILTER

  • USER_ID (Field)
  • CD_ID (Key1) — Foreign key → TB_MAP_CALENDAR_LABEL.CD_ID — NOT NULL
  • CREATOR_ID (Field2)
  • ON_OFF (Field3)

TB_SHARE_ADMIN

  • CREATOR_CD_ID (Key1) — Foreign key → TB_MAP_CALENDAR_LABEL.CD_ID — NOT NULL
  • LABEL_ID (Key2) — Foreign key → TB_MAP_CALENDAR_LABEL.LABEL_ID — NOT NULL
  • SHARED_CD_ID (Field)
  • SHARE_DATE (Field2)
  • SHARE_USER_ID (Field3)
  • SHARE_STATUS (Field4)