목표 공유 앱
테이블 (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