SOORE

Tables (8)

ATTACH (Untitled7)

  • POST_ID (Key) — VARCHAR2 — Foreign key → POST.POST_ID — NOT NULL
  • AC_FILE_NAME (Field) — VARCHAR2
  • REAL_FILE_NAME (Field5) — VARCHAR2

CALENDAR (Untitled6)

  • CD_ID (Key) — VARCHAR2 — Primary key — NOT NULL
  • CD_TITLE (Field) — VARCHAR2
  • CD_PLACE (Field2) — VARCHAR2
  • CD_START_DATE (Field3) — DATA
  • CD_END_DATE (Field4) — DATA
  • CD_CONTENT (Field5) — VARCHAR2
  • PROJECT_ID (Key2) — VARCHAR2 — Foreign key → TEAM_PROJECT.PROJECT_ID — NOT NULL

GANTT (Untitled8)

  • GANTT_ID (Field) — VARCHAR2 — Primary key
  • USER_ID (Field2) — VARCHAR2
  • START_DATE (Field3) — DATA
  • DUR (Field4) — NUMBER
  • GT_TYPE (Field5) — VARCHAR2
  • GT_PARENT (Field6) — VARCHAR2
  • TITLE (Field7) — VARCHAR2
  • USER_ID (Key) — VARCHAR2 — Foreign key → USER_INFO.USER_ID — NOT NULL

MENT (Untitled5)

  • POST_ID (Key) — VARCHAR2 — Foreign key → POST.POST_ID — NOT NULL
  • CM_DETAIL (Field) — VARCHAR2
  • CM_WRITER (Field2) — VARCHAR2
  • CM_INDATE (Field3) — DATE

POST (Untitled4)

  • POST_ID (Key) — VARCHAR2 — Primary key — NOT NULL
  • POST_TITLE (Field) — VARCHAR2
  • POST_DETAIL (Field2) — VARCHAR2
  • POST_WRITER (Field3) — VARCHAR2
  • INDATE (Field4) — DATE
  • PROJECT_NAME (Field6) — VARCHAR2 — Foreign key → TEAM_PROJECT.PROJECT_NAME

TEAM_PROJECT (Untitled)

  • PROJECT_ID (Key) — VARCHAR2 — Primary key — NOT NULL
  • PROJECT_NAME (Field) — VARCHAR2 — Primary key
  • PROJECT_START (Field2) — VARCHAR2
  • PROJECT_END (Field3) — VARCHAR2
  • PROJECT_COM (Field4) — VARCHAR2
  • USER_ID (Key2) — VARCHAR2 — Foreign key → USER_INFO.USER_ID — NOT NULL

USER_INFO (Untitled2)

  • USER_ID (Key) — VARCHAR2 — Primary key — NOT NULL
  • USER_PW (Field) — VARCHAR2
  • USER_NAME (Field2) — VARCHAR2

WORK_LIST (Untitled3)

  • WL_ID (Key) — VARCHAR2 — Primary key — NOT NULL
  • WL_DETAIL (Field2) — VARCHAR2
  • WL_PROGRESS (Field3) — VARCHAR2
  • WL_PRIORITY (Field4) — VARCHAR2
  • PROJECT_ID (Key3) — VARCHAR2 — Foreign key → TEAM_PROJECT.PROJECT_ID — NOT NULL
  • USER_ID (Key2) — VARCHAR2 — Foreign key → USER_INFO.USER_ID — NOT NULL