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