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