TeamProject
Tables (13)
DATADICTIONARY (데이터 사전)
- DICTIONARY_SEQ (PK) — NUMBER — Primary key — NOT NULL
- PROJECT_SEQ (FK_PROJECT) — NUMBER — Foreign key → PROJECT.PROJECT_SEQ — NOT NULL
- EMP_NO (FK_MEMBER) — NUMBER — Foreign key → Member.Member_SEQ — NOT NULL
- UPDATE_DATE (DEFAULT_SYSDATE) — DATE
DETAILED (세부일정)
- DETAILED_SEQ (PK) — NUMBER — Primary key — NOT NULL
- PROJECT_SEQ (FK_PROJECT) — NUMBER — Foreign key → PROJECT.PROJECT_SEQ — NOT NULL
- EMP_NO (FK_MEMBER) — VARCHAR — Foreign key → PROJECT.EMP_NO — NOT NULL
- DETAILED_STARTDATE (DEFAULT_SYSDATE) — DATE
- DETAILED_DEADLINE (Field3) — DATE
- DETAILED_ENDDATE (DEFAULT_SYSDATE_) — DATE
DETAILEDMEMBER (세부일정별 담당자)
- DETAILMEMBER_SEQ (PK) — NUMBER — Primary key — NOT NULL
- EMP_NO (FK_MEMBER) — VARCHAR — Foreign key → Member.Member_SEQ — NOT NULL
- DETAILED_SEQ (FK_DETAILED) — NUMBER — Foreign key → DETAILED.DETAILED_SEQ — NOT NULL
- TODO (NOTNULL) — VARCHAR
DICT_DATATYPE (데이터 사전_변수)
- DICT_DATATYPE_SEQ (PK) — NUMBER — Primary key — NOT NULL
- DICTIONARY_SEQ (FK_DATADICTIONARY) — NUMBER — Foreign key → DATADICTIONARY.DICTIONARY_SEQ — NOT NULL
- DATATYPE (Field) — VARCHAR
- MEANS (Field2) — VARCHAR
DICT_ECT (데이터사전_기타약속)
- DICT_ECT_SEQ (PK) — NUMBER — Primary key — NOT NULL
- DICTIONARY_SEQ (FK_DATADICTIONARY) — NUMBER — Foreign key → DATADICTIONARY.DICTIONARY_SEQ — NOT NULL
- COMMENT (Field)
DICT_METHOD (데이터사전_메서드)
- DICT_METHOD_SEQ (PK) — NUMBER — Primary key — NOT NULL
- DICTIONARY_SEQ (FK_DATADICTIONARY) — NUMBER — Foreign key → DATADICTIONARY.DICTIONARY_SEQ — NOT NULL
- PARAMETERTYPE (Field) — VARCHAR
- RETURNTYPE (Field2) — VARCHAR
- FACILITY (Field3) — VARCHAR
ERD (ER다이어그램)
- ERD_SEQ (PK) — NUMBER — Primary key — NOT NULL
- SAVE_SEQ (FK_SAVED_SEQ) — NUMBER — Foreign key → savedFigure.SAVED_SEQ — NOT NULL
- PROJECT_SEQ (PK2) — NUMBER — Foreign key → PROJECT.PROJECT_SEQ — NOT NULL
FIGURE (도형DB)
- FIGURE_SEQ (PK) — NUMBER — Primary key — NOT NULL
- FIGURE_NAME (Field) — VARCHAR
- FIGURE_PATH (Field2) — VARCHAR
- CLASS (Field3) — VARCHAR
MINUTES (회의록)
- MUNUETES_SEQ (PK) — NUMBER — Primary key — NOT NULL
- PROJECT_SEQ (FK_PROJECT) — NUMBER — Foreign key → PROJECT.PROJECT_SEQ — NOT NULL
- SAVE_SEQ (FK_SAVEDFIGURE) — NUMBER — Foreign key → savedFigure.SAVED_SEQ — NOT NULL
- RESENTDATE (NOT_UPDATE) — DATE
- CREATEDATE (NOT_UPDATE_) — DATE
Member (회원)
- Member_SEQ (Key) — NUMBER — Primary key — NOT NULL
- NAME (Field) — VARCHAR
- DEPART (Field2) — VARCHAR
- PHONENUM (Field3) — VARCHAR
PROJECT (프로젝트목록)
- PROJECT_SEQ (PK) — NUMBER — Primary key — NOT NULL
- EMP_NO (FK_MEMBER) — NUMBER — Foreign key → Member.Member_SEQ — NOT NULL
- PROJECT_NAME (NOTNULL) — VARCHAR2
- PROJECT_STARTDATE (DEFAULT_SYSDATE) — DATE
- PROJECT_DEADLINE (Field4) — DATE
- PROJECT_ENDDATE (DEFAULT_SYSDATE_) — DATE
SharedDocument (공동작업코드)
- PROJECT_CODE_SEQ (PK) — NUMBER — Primary key — NOT NULL
- PROJECT_SEQ (FK_PROJECT) — NUMBER — Foreign key → PROJECT.PROJECT_SEQ — NOT NULL
- EMP_NO (FK_MEMBER) — VARCHAR — Foreign key → Member.Member_SEQ — NOT NULL
- CONNTENT (VARCHAR) — VARCHAR
savedFigure (도형 저장)
- SAVED_SEQ (PK) — NUMBER — Primary key — NOT NULL
- FIGURE_SEQ (FK_FIGURE) — NUMBER — Foreign key → FIGURE.FIGURE_SEQ — NOT NULL
- START_POINT (Field) — VARCHAR
- END_POINT (Field2) — VARCHAR
- DEEP (Field3) — VATCHAR
- TEXT (Field4) — VARCHAR