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