TripSnap - 2024-04-06 11:28:54

Tables (10)

Album Photo (album_photo)

  • AlbumPhotosId (album_photos_id) — INT(11) — Primary key — NOT NULL
  • Album Id (album_id) — INT(11) — Foreign key — NOT NULL
  • Thumbnail (thumbnail) — VARCHAR(50) — NOT NULL
  • Photo (photo) — VARCHAR(50) — NOT NULL
  • Date (date) — DATE — NOT NULL
  • MemberId (member_id) — INT(11)

Friend (friend)

  • MemberId (member_id) — INT(11) — Foreign key — NOT NULL
  • FriendId (friend_id) — INT(11) — Foreign key — NOT NULL

Friend Request (friend_request)

  • MemberId (member_id) — INT(11) — Foreign key — NOT NULL
  • FriendId (friend_id) — INT(11) — Foreign key — NOT NULL
  • Date (date) — DATE — NOT NULL

Group (travel_group)

  • GroupId (group_id) — INT(11) — Primary key — NOT NULL
  • OwnerId (owner_id) — INT(11) — Foreign key — NOT NULL
  • Title (title) — VARCHAR(100) — NOT NULL

Group Album (group_album)

  • Album Id (album_id) — INT(11) — Primary key — NOT NULL
  • GroupId (group_id) — INT(11) — Foreign key — NOT NULL
  • Latitude (latitude) — Number(16,13)
  • Longitude (longitude) — Number(16,13)
  • Address (address) — VARCHAR(100)
  • Thumbnail (thumbnail) — VARCHAR(50)
  • Date (date) — DATE — NOT NULL
  • MemberId (member_id) — INT(11)

Group Member Request (group_member_request)

  • GroupId (group_id) — INT(11) — Foreign key — NOT NULL
  • MemberId (member_id) — INT(11) — Foreign key — NOT NULL
  • Date (date) — DATE — NOT NULL

GroupMember (group_member)

  • GroupId (group_id) — INT(11) — Foreign key — NOT NULL
  • MemberId (member_id) — INT(11) — Foreign key — NOT NULL

Member (member)

  • MemberId (member_id) — INT(11) — Primary key — NOT NULL
  • Email (email) — VARCHAR(100) — NOT NULL
  • Password (password) — VARCHAR(255) — NOT NULL
  • Nickname (nickname) — VARCHAR(20) — NOT NULL
  • Photo (photo) — VARCHAR(50)

Notification (notification)

  • Notification ID (notification_id) — INT(11) — Primary key — NOT NULL
  • MemberId (member_id) — INT(11) — Foreign key — NOT NULL
  • Title (title) — VARCHAR(100) — NOT NULL
  • IsRead (is_read) — BOOL — NOT NULL

Temporary Member (tmp_member)

  • MemberId (tmp_member_id) — INT(11) — Primary key — NOT NULL
  • Email (email) — VARCHAR(100) — NOT NULL
  • Password (password) — VARCHAR(255) — NOT NULL
  • Nickname (nickname) — VARCHAR(20) — NOT NULL
  • Token (token) — VARCHAR(255) — NOT NULL
  • Date (date) — DATE — NOT NULL