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 (내용)