계정계
테이블 (6)
Departments (Untitled)
- id (Key) — 기본 키 — NOT NULL
- name (Field)
document_roles (Untitled4)
- d_id (Key) — 외래 키 → documents.d_id — NOT NULL
- team_id (Key2) — 외래 키 → teams.id — NOT NULL
- dept_id (Key3) — 외래 키 → Departments.id — NOT NULL
- min_role (Field)
documents (Documents)
- d_id (Key) — 기본 키 — NOT NULL
- author_id (Key2) — 외래 키 → members.m_id — NOT NULL
- createdAt (Field4)
- updatedAt (Field5)
- title (Field)
- isDone (Field3) — boolean
members
- m_id (Key) — 기본 키 — NOT NULL
- team_id (Key2) — 외래 키 → teams.id — NOT NULL
- dept_id (Key3) — 외래 키 → Departments.id — NOT NULL
- name (Field)
- email (Field2) — asdfsadfsf
- social_id (Field6)
- role (Field4)
service_accessibility (Untitled3)
- id (Key) — 기본 키 — NOT NULL
- team_id (Key2) — 외래 키 → teams.id — NOT NULL
- dept_id (Key3) — 외래 키 → Departments.id — NOT NULL
- m_id (Key4) — 외래 키 → members.m_id — NOT NULL
- service (Field)
- read (Field2) — boolean
- write (Field3) — boolean
- confirm (Field4) — boolean
- min_role (Field5)
teams (Untitled2)
- id (Key) — 기본 키 — NOT NULL
- name (Field)