open:erd-작성 [EL]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

## 고려사항

- double precision 은 `int` 로 변경하였음
- not null 속성 추가해야 할 부분 확인
- foreign key 추가해야 할 부분 확인
- 데이터 타입 / 크기 확인
- 날짜를 varchar(14) 로 작성하였는데, 이 부분 유지 할지, 수정할지.
- Lineable 삭제 여부


## Alter table

```sql
ALTER TABLE ICP.EVENT_REPLY
ADD CONSTRAINT EVENT_REPLY_FK FOREIGN KEY (EVENT_SEQ) REFERENCES ICP.EVENT_INFO_PS (MISSING_SEQ)
```

```sql
ALTER TABLE ICP.MISSING_REPLY
ADD CONSTRAINT MISSING_REPLY_FK FOREIGN KEY (MISSING_SEQ) REFERENCES ICP.MISSING_INFO (MISSING_SEQ)
```

```sql
ALTER TABLE ICP.USER_SET
ADD CONSTRAINT USER_SET_FK FOREIGN KEY (USER_ID) REFERENCES ICP.USER_INFO (USER_ID)
```

```sql
ALTER TABLE ICP.WATCH_TARGET
ADD CONSTRAINT WATCH_TARGET_FK FOREIGN KEY (USER_ID) REFERENCES ICP.USER_INFO (USER_ID)
```