계정계

테이블 (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)