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