purple-groupware

Tables (17)

Account (Untitled12)

  • id (Key) — long — Primary key — NOT NULL — 회원 기능 개발시 계정 관리
  • email (Field) — string
  • createdAt (Field2) — datetime
  • updatedAt (Field3) — datetime
  • deletedAt (Field4) — datetime

CalendarStatus (Untitled16)

  • id (Key) — long — Primary key — NOT NULL
  • date (Field) — datetime
  • departmentId (Field2) — long
  • partId (Field3) — long
  • officeUserCount (Field4) — int
  • submiType (Field5) — enum
  • createdAt (Field6) — datetime
  • updatedAt (Field7) — datetime

Departments (Untitled2)

  • id (Key) — long — Primary key — NOT NULL — 실질적으로 파트id
  • upperDepartmentId (Field6) — long — (팀 -> 파트 tree 구조 재귀호출처리)
  • departmentName (Field7) — string — 정규화 안했다 일단 안고 해보자
  • departmentColor (Field3) — enum
  • craetedAt (Field4) — datetime
  • updatedAt (Field5) — datetime

Facility (Untitled11)

  • id (Key) — long — Primary key — NOT NULL
  • facilityType (Field) — enum
  • totalCount (Field2) — int
  • unUsedCount (Field3) — int
  • createdAt (Field4) — datetime
  • updatedAt (Field5) — datetime

FacilityManagement (Untitled7)

  • id (Key) — long — Primary key — NOT NULL
  • facilityId (Key2) — string — Foreign key → Facility.id — NOT NULL
  • facilityType (Field) — enum — 조인 안해도 되게 반정규화 해본다
  • statusType (Field8) — enum
  • displayName (Field3) — string
  • createdAt (Field6) — datetime
  • updatedAt (Field7) — datetime
  • sectionId (Field2) — int
  • x (Field4) — int
  • y (Field5) — int

Holiday (Untitled5)

  • id (Key) — long — Primary key — NOT NULL
  • date (Field) — date
  • holiday (Field2) — string
  • holidayType (Field5) — enum
  • createdAt (Field3) — datetime
  • updatedAt (Field4) — datetime

PartWorkSchedules (Untitled17)

  • id (Key) — long — Primary key — NOT NULL
  • departmentId (Key2) — long — Foreign key → Departments.id — NOT NULL — 실질적으로 파트id
  • month (Field2) — date
  • countOfWeek (Field3) — int
  • createdAt (Field) — datetime
  • updatedAt (Field4) — datetime

PushTokens (Untitled3)

  • id (Key) — long — Primary key — NOT NULL
  • userId (Key2) — long — Foreign key → Workers.id — NOT NULL
  • token (Field) — string
  • deviceName (Field2) — string
  • updatedAt (Field3) — datetime
  • updatedAt (Field4) — datetime

ReservationShareProducts (Untitled9)

  • id (Key) — logn — Primary key — NOT NULL
  • userIdd (Key2) — long — Foreign key → Workers.id — NOT NULL
  • productId (Key3) — long — Foreign key → ShareProducts.id — NOT NULL
  • date (Field3) — date
  • createdAt (Field2) — datetime
  • updatedAt (Field) — datetime

ShareProducts (Untitled8)

  • id (Key) — long — Primary key — NOT NULL
  • productCode (Key2) — string — Foreign key → Facility.id — NOT NULL
  • productType (Field) — enum
  • name (Field2) — string
  • totalCount (Field3) — int
  • lendCount (Field6) — int
  • createdAt (Field4) — datetime
  • updatedAt (Field5) — datetime

Tream (Untitled6)

  • id (Key) — long — Primary key — NOT NULL
  • teamName (Field) — string
  • createdAt (Field2) — datetime
  • updatedAt (Field3) — datetime

UserFixFacility (Untitled15)

  • id (Key) — long — Primary key — NOT NULL
  • facilityManagementId (Key3) — long — Foreign key → FacilityManagement.id — NOT NULL
  • userId (Key2) — long — Foreign key → Workers.id — NOT NULL — 반고정인 경우 스케줄 테이블을 보고 예약에 항상 우선
  • reason (Field) — string — 디자이너 4k 반고정 자리
  • createdAt (Field2) — datetime
  • updatedAt (Field3) — datetime

UserOfficePreWorkSchedules (Untitled14)

  • id (Key) — long — Primary key — NOT NULL
  • userId (Key2) — long — Foreign key → Workers.id — NOT NULL
  • departmentId (Key3) — long — Foreign key → Departments.id — NOT NULL — 실질적으로 파트id
  • date (Field) — date
  • createType (Field2) — enum — 유저(파트협의시간), 리더(리더 수정타입)

UserReservationFacility (Untitled10)

  • id (Key) — long — Primary key — NOT NULL
  • facilityManagementId (Key2) — long — Foreign key → FacilityManagement.id — NOT NULL
  • userId (Key4) — long — Foreign key → Workers.id — NOT NULL
  • date (Field5) — date
  • createdAt (Field) — datetime
  • updatedAt (Field2) — datetime
  • createdBy (Field3) — string
  • updatedBy (Field4) — string

UserReservationHistoryLog (Untitled13)

  • id (Key) — long — Primary key — NOT NULL
  • date (Field2) — date
  • reservation (Field) — json — 일 별 총 예약 현황
  • createdAt (Field3) — datetiem

UserWorkSchedules (Untitled4)

  • id (Key) — long — Primary key — NOT NULL
  • userId (Key2) — long — Foreign key → Workers.id — NOT NULL
  • departmentId (Key3) — long — Foreign key → Departments.id — NOT NULL — 실질적으로 파트id
  • date (Field) — date
  • startedAt (Field2) — time — nullable
  • endedAt (Field3) — time — nullable
  • officeType (Field4) — enum — nullable
  • workTime (Field9) — int — nullable
  • workType (Field10) — enum — nullable
  • createdAt (Field5) — datetime
  • updatedAt (Field6) — datetime
  • createdBy (Field7) — string
  • updatedBy (Field8) — string
  • SubmitStatus (Field11) — enum — PRE / SUBMIT

Workers (Untitled)

  • id (Key) — long — Primary key — NOT NULL
  • departmentId (Key2) — long — Foreign key → Departments.id — NOT NULL — 실질적으로 파트id
  • userType (Field) — enum — 실질적으로 권한컬럼
  • email (Field2) — string
  • password(인증) (Field3) — string — Auth 에서 가져 옴
  • displayName (Field4) — string
  • photoUrl (Field5) — string
  • createdAt (Field6) — datetime
  • updatedAt (Field7) — datetime