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