OpenPrj

Tables (5)

T_PRJ_MNG (CopyOfUntitled)

  • PRJ_ID (Key) — NUMBER — Primary key — NOT NULL
  • PRJ_NAME (Field) — VARCHAR2
  • PRJ_CONTENT (Field2) — VARCHAR2
  • CUSTOMER (Field5) — VARCHAR2
  • ATTCH_FILE (Field6) — VARCHAR2
  • START_DATE (Field7) — DATE
  • END_DATE (Field4) — DATE
  • USE_YN (Field3) — CHAR

T_PRJ_MNG_REPL (프로젝트댓글테이블)

  • REPLY_ID (Key) — NUMBER — Primary key — NOT NULL
  • PRJ_ID (Key2) — NUMBER — Foreign key → T_PRJ_MNG_TEMP.PRJ_ID — NOT NULL
  • UPPER_REPLY_ID (Field) — NUMBER
  • REPLY_CN (Field2) — VARCHAR2
  • REG_NM (Field3) — VARCHAR2
  • REG_DATE (Field4) — DATE
  • UPD_DATE (Field5) — DATE
  • USE_YN (Field7) — CHAR

T_PRJ_MNG_TEMP (프로젝트관리테이블)

  • PRJ_ID (Key) — NUMBER — Primary key — NOT NULL
  • PRJ_NAME (Field6) — VARCHAR2
  • PRJ_MANAGER (Field) — VARCHAR2
  • PRJ_CONTENT (Field2) — VARCHAR2
  • CLIENT_NAME (Field3) — VARCHAR2
  • START_DATE (Field4) — DATE
  • END_DATE (Field5) — DATE
  • PRJ_STATUS (Field7) — VARCHAR2
  • ATTCH_FILE (Field8) — VARCHAR2
  • REG_DATE (Field9) — DATE
  • UPD_DATE (Field10) — DATE
  • USE_YN (Field11) — CHAR
  • ORGN_FILE_NM (Field12) — VARCHAR2

T_PRJ_USER (Untitled)

  • USER_NO (Key) — NUMBER — Primary key — NOT NULL
  • LOGIN_ID (Field6) — VARCHAR2
  • PASSWORD (Field) — VARCHAR2
  • AUTH (Field2) — VARCHAR2
  • CREATE_DATE (Field3) — DATE
  • PHO_NUM (Field4) — VARCHAR
  • USER_NAME (Field5) — VARCHAR2
  • USE_YN (Field7) — CHAR

T_PRJ_USER_MAP (CopyOfUntitled2)

  • USER_NO (Key) — NUMBER — Foreign key → T_PRJ_USER.USER_NO — NOT NULL
  • PRJ_ID (Key3) — NUMBER — Foreign key → T_PRJ_MNG.PRJ_ID — NOT NULL
  • ROLE_CODE (Field) — VARCHAR2