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