dotCodeTeam / dotCodeTeam/AMS

DB culumn 추가 요청

Open
#6 0 comments 0 reactions 1 assignee Assigned to @nunu1101 View on GitHub
good first issue help wanted
Dominant language
Java
Stars
0
Forks
0
PR merge metrics
No merged PRs in 30d

Description

## 작업 상세 내용

## 추가 요청

- [x] VACANT 테이블
(부재신청허가여부) **ACCEPT_STATUS** : varchar culumn 추가 요청
1. "Y" or "N" CHECK문으로 해당 값 외에는 입력 못받게 제한

- [x] #11
(현재날짜)**CURRENT_DATE** : date culumn 추가 요청

- [x] EMPLOYEE 테이블
(근무상태)**CURRENT_STATUS** : varchar culumn 추가 요청

- [x] ATTENDANCE 테이블
**TOTAL_DAY_COUNT** : integer culumn 추가 요청

## 수정 요청

- [x] ATTENDANCE 테이블
**EMP_NO** : integer culumn 순서 첫번째로 수정 요청

- [x] ATTENDANCE 테이블
TOTAL_ATTENDANCE_SCORE
>> **TOTAL_SCORE** 컬럼명 변경 요청

## 참고할만한 자료(선택)

VACANT table
![vacant_table_culumn_request](https://github.com/dotCodeTeam/AMS/assets/90615404/e6afb3be-a9cb-4bdc-9ca7-32ae53237d4f)

EMPLOYEE table
![employee_table_culumn_request](https://github.com/dotCodeTeam/AMS/assets/90615404/0a320463-8533-4929-8e52-b2fb2156bfd0)

ATTENDANCE table
![attendance_table_culumn_request](https://github.com/dotCodeTeam/AMS/assets/90615404/c7e67345-5d02-4a61-bb06-24458e8526a6)

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.