calendar 테이블
테이블 (9)
Calendar (캘린더1)
- no (PK) — bigint(20) — 기본 키 — NOT NULL
- office_no (Field5) — bigint(20) — NOT NULL
- subject (Field1) — varchar — NOT NULL
- type (Field2) — enum('PERSONAL', 'TEAM', 'OFFICE') — NOT NULL
- created_at (Field3) — datetime — NOT NULL
- is_deleted (Field4) — tinyint(1) — NOT NULL
- is_shared (Field6) — tinyint(1) — NOT NULL
Calendar (캘린더2)
- no (PK) — bigint(20) — 기본 키 — NOT NULL
- office_no (Field5) — bigint(20) — NOT NULL
- subject (Field1) — varchar — NOT NULL
- type (Field2) — enum('PERSONAL', 'TEAM', 'OFFICE') — NOT NULL
- created_at (Field3) — datetime — NOT NULL
- is_deleted (Field4) — tinyint(1) — NOT NULL
Calendar (캘린더3)
- no (PK) — bigint(20) — 기본 키 — NOT NULL
- office_no (Field5) — bigint(20)
- subject (Field1) — varchar — NOT NULL
- type (Field2) — enum('PERSONAL', 'TEAM', 'OFFICE') — NOT NULL
- created_at (Field3) — datetime — NOT NULL
- is_deleted (Field4) — tinyint(1) — NOT NULL
- is_shared (Field6) — tinyint(1) — NOT NULL
CalendarAuthority (캘린더 권한)
- no (PK) — bigint(20) — 기본 키 — NOT NULL
- write_authority (Field1) — tinyint(1) — NOT NULL
- is_admin (Field2) — tinyint(1) — NOT NULL
CalendarMember (캘린더 멤버2)
- no (PK) — bigint(20) — 기본 키 — NOT NULL
- calendar_no (FK) — bigint(20) — 외래 키 → Calendar.no — NOT NULL
- calendar_authority_no (FK2) — bigint(20) — 외래 키 → CalendarAuthority.no — NOT NULL
- user_no (Field2) — bigint(20) — NOT NULL
- office_no (Field3) — bigint(20) — NOT NULL
- is_default_calendar (Field4) — tinyint(1) — NOT NULL
- is_deleted (Field5) — tinyint(1) — NOT NULL
- show_calendar (Field6) — tinyint(1) — NOT NULL
- created_at (Field7) — datetime — NOT NULL
CalendarMembers (캘린더 멤버1)
- no (PK) — bigint(20) — 기본 키 — NOT NULL
- calendar_no (FK) — bigint(20) — 외래 키 → Calendar.no — NOT NULL
- user_no (Field2) — bigint(20) — NOT NULL
- office_no (Field3) — bigint(20) — NOT NULL
- write_authority (Field4) — tinyint(1) — NOT NULL
- is_default_calendar (Field5) — tinyint(1) — NOT NULL
- is_admin (Field6) — tinyint(1) — NOT NULL
- is_deleted (Field7) — tinyint(1) — NOT NULL
- show_calendar (Field8) — tinyint(1) — NOT NULL
- created_at (Field9) — datetime — NOT NULL
OfficeCalendarMembers (오피스 캘린더 멤버)
- no (PK) — bigint(20) — 기본 키 — NOT NULL
- calendar_no (FK) — bigint(20) — 외래 키 → Calendar.no — NOT NULL
- user_no (Field2) — bigint(20) — NOT NULL
- office_no (Field3) — bigint(20) — NOT NULL
- is_admin (Field4) — tinyint(1) — NOT NULL
- is_deleted (Field5) — tinyint(1) — NOT NULL
- is_default_calendar (Field6) — tinyint(1) — NOT NULL
- write_authority (Field7) — tinyint(1) — NOT NULL
- show_calendar (Field8) — tinyint(1) — NOT NULL
- created_at (Field9) — datetime — NOT NULL
PersonalCalendarMembers (개인 캘린더 멤버)
- no (PK) — bigint(20) — 기본 키 — NOT NULL
- calendar_no (FK) — bigint(20) — 외래 키 → Calendar.no — NOT NULL
- user_no (Field2) — bigint(20) — NOT NULL
- office_no (Field3) — bigint(20) — NOT NULL
- is_admin (Field4) — tinyint(1) — NOT NULL
- is_deleted (Field5) — tinyint(1) — NOT NULL
- is_default_calendar (Field6) — tinyint(1) — NOT NULL
- write_authority (Field7) — tinyint(1) — NOT NULL
- show_calendar (Field8) — tinyint(1) — NOT NULL
- created_at (Field9) — datetime — NOT NULL
TeamCalendarMembers (팀 캘린더 멤버)
- no (PK) — bigint(20) — 기본 키 — NOT NULL
- calendar_no (FK) — bigint(20) — 외래 키 → Calendar.no — NOT NULL
- user_no (Field2) — bigint(20) — NOT NULL
- office_no (Field3) — bigint(20) — NOT NULL
- is_admin (Field4) — tinyint(1) — NOT NULL
- is_deleted (Field5) — tinyint(1) — NOT NULL
- is_default_calendar (Field6) — tinyint(1) — NOT NULL
- write_authority (Field7) — tinyint(1) — NOT NULL
- show_calendar (Field8) — tinyint(1) — NOT NULL
- created_at (Field9) — datetime — NOT NULL