dotCodeTeam / dotCodeTeam/ams-project-database

SQL table 추가 및 culumn명 변경

Open

#1 opened on Feb 25, 2024 0 comments 0 reactions 1 assignee Claimed by @nunu1101 View on GitHub

good first issue

Dominant language: No language data
Stars: 0
Forks: 0
PR merge metrics: No merged PRs in 30d

Description

> EMPLOYEE
1. CURRENT_STATUS culumn 순서 변경
![employee_table_순서변경](https://github.com/dotCodeTeam/ams-project-database/assets/90615404/627e8fe5-75e6-4cb3-b1bd-c55c2b4ab9d0)

> STATUS_CATEGORY
1. table 추가
![status_table추가](https://github.com/dotCodeTeam/ams-project-database/assets/90615404/ddb4a1dc-5353-4fd7-bb55-7eecb2c1b395)

> VACANT
1. culumn 추가
1-1, VACANT_NO ( PK ) : 기존 PK VACANT_CATEGORY
1-2. VACANT_APPLY_DATE : 부재 신청한 날짜
1-3. VACANT_DAY_DATE : 부재 당일 날짜
2. culumn 변경 : VACANT_CATEGORY -> STATUS_CODE ( FK from STATUS_CATEGORY)
3. culumn 제거 : VACANT_NAME -> STATUS_CATEGORY 테이블에서 STATUS_NAME으로 관리할것이기 때문
![vacant_table_culumn추가변경](https://github.com/dotCodeTeam/ams-project-database/assets/90615404/06d14d62-3044-49d3-9929-a1e2a4634581)

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

SQL table 추가 및 culumn명 변경

Description

Contributor guide

Assessment

Get new issues in your inbox