ProKAN
Tables (6)
FLOWCHART
- FLOWCHART_ID — Primary key — NOT NULL
- PROJECT_ID — Foreign key → PROJECT.PROJECT_ID — NOT NULL
- MEMBER_ID (ID2) — Foreign key → PROJECT.MEMBER_ID — NOT NULL
- Field
GANTT (간트)
- OBJECT_ID — Primary key — NOT NULL
- PROJECT_ID — Foreign key → PROJECT.PROJECT_ID — NOT NULL
- MEMBER_ID (ID2) — Foreign key → PROJECT.MEMBER_ID — NOT NULL
- MEMBER_ID (ID3) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
- STARTDATE (START)
- ENDDATE (END)
- MEMBER_ID
- DESCRIBE
MEMBER (회원)
- MEMBER_ID (ID) — Primary key — NOT NULL
- MEMBERPW (PW)
- NAME
- EMAIL
MINUTES (회의록)
- MINUTE_ID — Primary key — NOT NULL
- PROJECT_ID — Foreign key → PROJECT.PROJECT_ID — NOT NULL
- MEMBER_ID (ID2) — Foreign key → PROJECT.MEMBER_ID — NOT NULL
- Field
OBJECT (도형)
- OBJECT_ID — Primary key — NOT NULL
- OBJECT_NAME
- PATH (OBJECT_PATH)
- LABEL (OBJECT_LABEL)
PROJECT (프로젝트)
- PROJECT_ID — Primary key — NOT NULL
- MEMBER_ID (ID) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
- PRIVILEGE