TripSnap
Tables (10)
Album Photo (album_photo)
- AlbumPhotosId (album_photos_id) — INT(11) — Primary key — NOT NULL
- Album Id (album_id) — INT(11) — Foreign key → Group Album.Album Id — NOT NULL
- Thumbnail (thumbnail) — VARCHAR(200) — NOT NULL
- Photo (photo) — VARCHAR(200) — NOT NULL
- Date (date) — DATE — NOT NULL
- MemberId (member_id) — INT(11)
Friend (friend)
- MemberId (member_id) — INT(11) — Foreign key → Member.MemberId — NOT NULL
- FriendId (friend_id) — INT(11) — Foreign key → Member.MemberId — NOT NULL
FriendRequest (friend_request)
- MemberId (member_id) — INT(11) — Foreign key → Member.MemberId — NOT NULL
- FriendId (friend_id) — INT(11) — Foreign key → Member.MemberId — 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 → Member.MemberId — 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 → Group.GroupId — NOT NULL
- Title (title) — VARCHAR(100) — NOT NULL
- Latitude (latitude) — Number(16,13)
- Longitude (longitude) — Number(16,13)
- Address (address) — VARCHAR(100)
- Thumbnail (thumbnail) — VARCHAR(200)
- Date (date) — DATE — NOT NULL
- MemberId (member_id) — INT(11)
Group Member Request (group_member_request)
- GroupId (group_id) — INT(11) — Foreign key → Group.GroupId — NOT NULL
- MemberId (member_id) — INT(11) — Foreign key → Member.MemberId — NOT NULL
- Date (date) — DATE — NOT NULL
GroupMember (group_member)
- GroupId (group_id) — INT(11) — Foreign key → Group.GroupId — NOT NULL
- MemberId (member_id) — INT(11) — Foreign key → Member.MemberId — 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(200)
Notification (notification)
- Notification ID (notification_id) — INT(11) — Primary key — NOT NULL
- MemberId (member_id) — INT(11) — Foreign key → Member.MemberId
- 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