Tripshare
Tables (9)
Copy Of Untitled (MeetArticle)
- Key (id) — string — Primary key — NOT NULL
- id (creator) — User — Foreign key → User.id — NOT NULL
- Field (title) — string
- Field2 (contents) — string
- Field3 (createdAt) — timestamp
- Field (city) — string
- Field (location) — map
- Field (address) — string
- Field2 (meetingAt) — timestamp
- Field5 (category) — string
Copy Of Untitled2 (DiaryComment)
- Key (id) — int — Primary key — NOT NULL
- id (creator) — User — Foreign key → Untitled.id — NOT NULL
- Field (contents) — string
- Field (createdAt) — timestamp
Untitled (CommunityArticle)
- Key (id) — string — Primary key — NOT NULL
- id (creator) — User — Foreign key → User.id — NOT NULL
- Field (title) — string
- Field2 (contents) — string
- Field3 (createdAt) — timestamp
- Field (images) — string[3]
- Field5 (tag) — string
- Field6 (bookmarked) — int — NOT NULL
- Field7 (liked) — int
- Field2 (comments) — array
Untitled (CommunityComment)
- Key (id) — int — Primary key — NOT NULL
- id (creator) — User — Foreign key → Untitled.id — NOT NULL
- Field (contents) — string
- Field (createdAt) — timestamp
Untitled (Plan)
- Key (id) — string — Primary key — NOT NULL
- id (creator) — User — Foreign key → User.id — NOT NULL
- Field (title) — string
- Field (dates) — timestamp[]
- Field (schedules) — array
- Field (location) — map
- Field2 (tags) — string[]
- Field3 (friendList) — array
- Field4 (coverImage) — string
- Field (dDay) — int
- Field (bookmarked) — int
- Field2 (liked) — int
Untitled (Schedule)
- Key (id) — string — Primary key — NOT NULL
- Key (date) — timestamp — Foreign key → Untitled.Key — NOT NULL
- Field (schedule) — array
Untitled (Attraction)
- Key (id) — string — Primary key — NOT NULL
- Field (placeName) — string
- Field (tag) — string
- Field (detail) — string
- Field (location) — map
- Field (coverImage) — string
- Field (star) — int
- Field (reviews) — array
- Field (tel) — string
- Field (createdAt) — timestamp
Untitled (Diary)
- Key (id) — string — Primary key — NOT NULL
- id (creator) — User — Foreign key → User.id — NOT NULL
- Field (title) — string
- Field (liked) — int
- Field (bookmarked) — int
- Field (image) — string
- Field (comments) — array
User
- id — string — Primary key — NOT NULL
- email — string
- name — string
- status — string
- Field (profileImg) — url
- createdAt — timestamp
- Field (currentCity) — string
- Field2 (myCity) — string[]
- Field3 (bookmarkList) — array
- Field (likedList) — array