PIS
Tables (3)
TB_MG_OUT
- PJT_CODE — VARCHAR2(10) — Primary key — NOT NULL — 프로젝트ID
- CONTRACT_DIV — VARCHAR2(20) — Primary key — NOT NULL — 계약구분
- OUT_ID — NUMBER — Primary key — NOT NULL — 매출ID
- Key — Primary key — NOT NULL
- OUT_CO — VARCHAR2(100) — NOT NULL — 매출사
- CONTRACT_DATE — VARCHAR2(10) — 계약일
- CONTRACT_COST — VARCHAR2(50) — 계약금
- CONTRACT_START — VARCHAR2(10) — 계약시작일
- CONTRACT_END — VARCHAR2(10) — 계약종료일
- CHANGE_DATE — VARCHAR2(19) — 변경일
- STATUS — VARCHAR2(30) — 진행상태
- PJT_DIV — VARCHAR2(30)
- PJT_NAME — VARCHAR2(300)
- IMP_YN — VARCHAR2(1) — 수입여부
- Field
lll (ppp)
- Key — Primary key — NOT NULL
- Key2 — Primary key — NOT NULL
- Field
- Field2
- Field3
llllll (ppppp)
- Key (py) — Primary key — NOT NULL
- Key2 — Primary key — NOT NULL
- Key (Key3) — Foreign key → lll.Key — NOT NULL
- Key2 (Key22) — Foreign key → lll.Key2 — NOT NULL
- Field
- Key (Key4) — Foreign key → lll.Key — NOT NULL
- Key2 (Key23) — Foreign key → lll.Key2 — NOT NULL
- Field2