목표 공유 앱

테이블 (11)

Untitled (friendship)

  • Key (id) — 기본 키 — NOT NULL
  • (me) — 외래 키 → user.id — NOT NULL
  • (follower) — 외래 키 → user.id — NOT NULL
  • Field (isAccepted) — NOT NULL

Untitled (calender)

  • Key (id) — 기본 키 — NOT NULL
  • (user) — 외래 키 → user.id — NOT NULL
  • Field (createdDate) — NOT NULL

Untitled (todolist)

  • Key (id) — 기본 키 — NOT NULL
  • Key (calender) — 외래 키 → Untitled.Key — NOT NULL
  • Field (contents) — NOT NULL
  • Field (isSucceed) — NOT NULL

Untitled (diary)

  • Key (id) — 기본 키 — NOT NULL
  • Key (calender) — 외래 키 → Untitled.Key — NOT NULL
  • Field (contents) — NOT NULL

Untitled (goal_personal)

  • Key (id) — 기본 키 — NOT NULL
  • (user) — 외래 키 → user.id — NOT NULL
  • Field (contents) — NOT NULL
  • Field (isSucceed) — NOT NULL
  • Field (deadline)

Untitled (organization)

  • Key (id) — 기본 키 — NOT NULL
  • (admin) — 외래 키 → user.id — NOT NULL
  • Field (teamName) — NOT NULL
  • Field (partyMemberCount) — NOT NULL

Untitled (organization_member)

  • Key (id) — 기본 키 — NOT NULL
  • Key (organization) — 외래 키 → Untitled.Key — NOT NULL
  • (user) — 외래 키 → user.id — NOT NULL

Untitled (organization_goal)

  • Key (id) — 기본 키 — NOT NULL
  • Key (organization) — 외래 키 → Untitled.Key — NOT NULL
  • Field (contents) — NOT NULL
  • Field (deadline) — NOT NULL

Untitled (schedule)

  • Key (id) — 기본 키 — NOT NULL
  • Key (calender) — 외래 키 → Untitled.Key — NOT NULL
  • Field (contents) — NOT NULL
  • Field (isSucceed) — NOT NULL

Untitled (organization_goal_completed_member)

  • Key (id) — 기본 키 — NOT NULL
  • Key (organizationUser) — 외래 키 → Untitled.Key — NOT NULL
  • Key (goal) — 외래 키 → Untitled.Key — NOT NULL
  • Field (isSucceed) — NOT NULL

user

  • (id) — 기본 키 — NOT NULL
  • Field (name) — NOT NULL
  • Field (school) — NOT NULL
  • Field (grade) — NOT NULL
  • Field (group) — NOT NULL
  • Field (number) — NOT NULL
  • Field (isPublic) — NOT NULL
  • Field (createdDate) — NOT NULL