ff

Tables (5)

Event (Untitled2)

  • id (아이디) — Long — Primary key — NOT NULL
  • userId (유저아이디) — Long — Foreign key → User.id — NOT NULL
  • eventType (연차/당직) — varchar
  • createAt (생성일) — date
  • updateAt (수정일) — date
  • Field

Holiday (CopyOfCopyOfUntitled2)

  • id (아이디) — Long — Primary key — NOT NULL
  • eventId (이벤트아이디) — Long — Foreign key → Event.id — NOT NULL
  • userId (유저아이디) — Long — Foreign key → Event.userId — NOT NULL
  • startDate (시작일) — date
  • endDate (종료일) — date

Night (CopyOfUntitled2)

  • id (아이디) — Long — Primary key — NOT NULL
  • eventId (이벤트아이디) — Long — Foreign key → Event.id — NOT NULL
  • userId (유저아이디) — Long — Foreign key → Event.userId — NOT NULL
  • date (당직일) — date

Order (Untitled3)

  • id (아이디) — Primary key — NOT NULL
  • eventId (이벤트아이디) — Long — Foreign key → Event.id — NOT NULL
  • userId (유저아이디) — Long — Foreign key → Event.userId — NOT NULL
  • approval (승인여부) — varchar

User (Untitled)

  • id (아이디) — Long — Primary key — NOT NULL
  • name (이름) — varchar
  • email (이메일) — varchar
  • password (비밀번호) — varchar
  • tel (연락처) — varchar
  • image? (이미지) — varchar
  • annual (남은연차) — number
  • role (권한) — varchar
  • status (활성여부) — boolean
  • createAt (생성일) — date
  • updateAt (수정일) — date