Original Calendar

Tables (18)

Alarm (Untitled11)

  • Alarm ID (Key) — VARCHAR(36) — Primary key — NOT NULL
  • Event ID (Key2) — VARCHAR(36) — Foreign key → Event.Event ID — NOT NULL
  • Alarm Time (Field)
  • Alarm Type (Field2)
  • Cron Expression (Field3)
  • Trigger Timestamp (Field4) — TIMESTAMP WITH TIME ZONE(6, 6)

Alarm Ongoing (CopyOfUntitled11)

  • Alarm ID (Key) — VARCHAR(36) — Foreign key → Alarm.Alarm ID — NOT NULL
  • Trigger Timestamp (Field) — TIMESTAMP WITH TIME ZONE(6, 6)
  • Event ID (Field2)
  • Target Start (Field3) — TIMESTAMP WITH TIME ZONE(6, 6)
  • Target End (Field4) — TIMESTAMP WITH TIME ZONE(6, 6)
  • Target Timestamp (Field5) — TIMESTAMP WITH TIME ZONE(6, 6)

Anniversary (Untitled14)

    Calendar

    • Calendar ID (Key) — VARCHAR(36) — Primary key — NOT NULL
    • name (Field) — VARCHAR(100)
    • color (Field2) — VARCHAR(7)
    • zone ID (Field5) — VARCHAR(36)
    • File ID (Field3) — VARCHAR(36)
    • type (Field4) — VARCHAR(10) — 'main' or 'sub' or 'url'
    • domain name (Field6) — VARCHAR(100)
    • url (Field7) — VARCHAR(300)
    • App ID (Key2) — VARCHAR(36) — Foreign key → MAP CH.App ID — NOT NULL
    • 생성 날짜 (Field8) — TIMESTAMP WITH TIME ZONE(6, 6)
    • 수정 날짜 (Field9) — TIMESTAMP WITH TIME ZONE(6, 6)
    • use YN (Field10) — VARCHAR(1)

    Calendar Scheduler (Untitled15)

    • Scheduler ID (Key) — VARCHAR(36) — Foreign key → UCS Scheduler.Scheduler ID — NOT NULL
    • Calendar ID (Key2) — VARCHAR(36) — Foreign key → Calendar.Calendar ID — NOT NULL
    • User ID (Field) — VARCHAR(36) — 외부 캘린더를 추가한 유저 ID
    • url (Field2) — VARCHAR(300)

    Calendar Share (Untitled7)

    • App ID (Key22) — VARCHAR(36) — Foreign key → MAP CH.App ID — NOT NULL
    • ICal ID (Key4) — VARCHAR(36) — Foreign key → Calendar.Calendar ID — NOT NULL
    • Shared Calendar ID (Field4) — VARCHAR(36)
    • color (Field) — VARCHAR(7)
    • 권한 (Field2) — 'editable' == 3 'read/only' == 2 'busy' == 1
    • 공유한 User ID (Key5) — VARCHAR(36) — Foreign key → User.User ID — NOT NULL
    • 공유 날짜 (Field3)
    • flag (Field5) — VARCHAR(7) — 'inShare' or 'url'

    Calendar User (Untitled)

    • App ID (Key2) — VARCHAR(36) — Foreign key → MAP CH.App ID — NOT NULL
    • User ID (Key) — VARCHAR(36) — Foreign key → User.User ID — NOT NULL

    Calendar User Setting (Untitled13)

    • Calendar ID (Key) — VARCHAR(36) — Foreign key → Calendar.Calendar ID — NOT NULL
    • User ID (Key2) — VARCHAR(36) — Foreign key → User.User ID — NOT NULL
    • name (Field) — VARCHAR(100)
    • Color (Field2) — deprecated
    • 수정 날짜 (Field3)

    Event (Untitled2)

    • Event ID (Key2) — VARCHAR(36) — Primary key — NOT NULL
    • Calendar ID (Key5) — VARCHAR(36) — Foreign key → Calendar.Calendar ID — NOT NULL
    • name (Field) — VARCHAR(100)
    • color (Field2) — VARCHAR(7)
    • start (Field3) — TIMESTAMP WITH TIME ZONE(6, 6)
    • end (Field4) — TIMESTAMP WITH TIME ZONE(6, 6)
    • description (Field5) — VARCHAR(3000)
    • location (Field6) — VARCHAR(3000)
    • allday (Field7) — VARCHAR(5)
    • importance (Field8) — VARCHAR(5)
    • meeting (Field9) — VARCHAR(5)
    • Created User ID (Key) — VARCHAR(36) — Foreign key → User.User ID — NOT NULL
    • 생성 날짜 (Field10)
    • 수정 날짜 (Field11)

    Event Share (Untitled8)

    • Event ID (Key2) — VARCHAR(36) — Foreign key → Event.Event ID — NOT NULL
    • Shared Target ID (Field) — VARCHAR(36)
    • 권한 (Field2) — VARCHAR(1)
    • 공유한 User ID (Field3) — VARCHAR(36)
    • type (Field4) — 'cal' or 'user'
    • 공유 날짜 (Field5)
    • Color (Field6) — VARCHAR(7)

    File (Untitled12)

    • File ID (Key) — VARCHAR(36) — Primary key — NOT NULL
    • Event ID (Key2) — VARCHAR(36) — Foreign key → Event.Event ID — NOT NULL

    Filter (Untitled3)

    • App ID (Key22) — VARCHAR(36) — Foreign key → MAP CH.App ID — NOT NULL
    • User ID (Key4) — VARCHAR(36) — Foreign key → User.User ID — NOT NULL
    • Calendar ID (Key5) — VARCHAR(36) — Foreign key → Calendar.Calendar ID — NOT NULL
    • Shared Calendar ID (Field) — VARCHAR(36)

    MAP CH (Untitled9)

    • App ID (Key2) — VARCHAR(36) — Primary key — NOT NULL
    • WS ID (Key) — VARCHAR(36) — NOT NULL

    Repeat Exception (Untitled6)

    • Exception Date (Field) — DATE — Primary key
    • RepeatGrp ID (Key3) — VARCHAR(36) — Foreign key → Repeat Range.RepeatGrp ID — NOT NULL
    • Repeat Range ID (Key2) — VARCHAR(36) — Foreign key → Repeat Range.Repeat Range ID — NOT NULL — == EVENT ID
    • Event ID (Field2) — VARCHAR(36)
    • Flag Removed (Field3)

    Repeat Group (Untitled4)

    • RepeatGrp ID (Key) — VARCHAR(36) — Primary key — NOT NULL
    • frequency (Field) — Integer
    • interval (Field2) — Integer
    • byDWM (Field3) — Integer
    • until (Field6) — TIMESTAMP WITH TIME ZONE(6, 6)

    Repeat Range (Untitled5)

    • RepeatGrp ID (Key3) — VARCHAR(36) — Foreign key → Repeat Group.RepeatGrp ID — NOT NULL
    • Repeat Range ID (Key2) — VARCHAR(36) — Foreign key → Event.Event ID — NOT NULL — == EVENT ID
    • start (Field) — TIMESTAMP WITH TIME ZONE(6, 6)
    • end (Field2) — TIMESTAMP WITH TIME ZONE(6, 6)

    UCS Scheduler (Untitled16)

    • Scheduler ID (Key) — VARCHAR(36) — Primary key — NOT NULL

    User (Untitled10)

    • User ID (Key) — VARCHAR(36) — Primary key — NOT NULL