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