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)
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