Neodigm-project-manager

Tables (7)

client (클라이언트)

  • id (ID) — LONG — Primary key — NOT NULL
  • name (이름)

headquarters (본부)

  • id (ID) — Primary key — NOT NULL
  • name (이름)

person_ae (담당AE)

  • id (ID) — Primary key — NOT NULL
  • headquarters_id (본부 아이디) — Foreign key → teams.headquarters_id — NOT NULL
  • team_id (팀 아이디) — Foreign key → teams.id — NOT NULL
  • headquarters (본부)

product (제작물)

  • id (ID) — Primary key — NOT NULL
  • name (이름)

teams (팀)

  • id (ID) — Primary key — NOT NULL
  • headquarters_id (본부 아이디) — Foreign key → headquarters.id — NOT NULL
  • name (이름)

users (회원정보)

  • id (ID) — LONG — Primary key — NOT NULL
  • role (권한) — VARCHAR
  • name (이름) — VARCHAR
  • password (비밀번호) — VARCHAR
  • email (이메일) — VARCHAR
  • position (직급) — VARCHAR
  • team (팀) — VARCHAR
  • created_at (생성 날짜) — TIMESTAMP
  • update_at (수정 날짜) — TIMESTAMP

works (작업일지)

  • id (ID) — LONG — Primary key — NOT NULL
  • user_id (회원 아이디) — LONG — Foreign key → users.id — NOT NULL
  • classification (대분류)
  • category (중분류)
  • division (소분류) — VARCHAR
  • schedule (일정) — TIMESTAMP
  • person (담당자)
  • products (제작물 (연동 x))
  • client (클라이언트 이름 (연동 x))
  • person_ae (담당AE)
  • title (제목)
  • content (내용)