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