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