commute
Tables (4)
Commute (출퇴근)
- 출퇴근고유id (Key) — long — Primary key — NOT NULL
- 회원고유id (Key2) — long — Foreign key → Member.회원고유id — NOT NULL
- 날짜 (Field) — LocalDate — NOT NULL
- 출근시간 (Field2) — LocalTime
- 퇴근시간 (Field3) — LocalTime
- 근무시간 (Field4) — LocalTime
- 지각시간 (Field5) — LocalTime
- 지각사유 (Field6) — VARCHAR(255)
- 퇴근비고 (Field7) — VARCHAR(255)
- 최종휴식시간 (Field8) — LocalTime
DinnerVote (밥투표)
- 밥투표고유id (Key) — Integer — Primary key — NOT NULL
- 밥투표날짜 (Field) — LocalDate — NOT NULL
- 메뉴시간 (Field4) — String — NOT NULL
- 회원목록 (Field2) — String
- 회원수 (Field3) — Integer — NOT NULL
Member (회원)
- 회원고유id (Key) — long — Primary key — NOT NULL
- 아이디 (Field) — VARCHAR(255) — NOT NULL
- 비밀번호 (Field2) — VARCHAR(255) — NOT NULL
- 팀 (Field3) — VARCHAR(255) — NOT NULL
- 이름 (Field4) — VARCHAR(255) — NOT NULL
Rest (휴식)
- 휴식고유id (Key) — long — Primary key — NOT NULL
- 회원고유id (Key2) — long — Foreign key → Member.회원고유id — NOT NULL
- 휴식시작시간 (Field) — LocalTime — NOT NULL
- 휴식종료시간 (Field4) — LocalTime
- 휴식조건 (Field2) — VARCHAR(255)
- 날짜 (Field3) — LocalDate