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