Evento

Tables (11)

Admin (admin)

  • Admin ID (admin_id) — Primary key — NOT NULL
  • User id (user_id) — Foreign key → User.User ID — NOT NULL
  • Calender id (calender_id) — Foreign key → Calender.Calender id — NOT NULL
  • Role Level (role_level)
  • Admin Invitation ID (admin_invitation_id)

Birtday (birthday)

  • Birthday ID (birthday_id) — Primary key — NOT NULL
  • User id (user_id) — Foreign key → User.User ID — NOT NULL
  • Calender id (calender_id) — Foreign key → Calender.Calender id — NOT NULL

Calender (calender)

  • Calender id (calender_id) — Primary key — NOT NULL
  • Calender Name (calender_name)
  • Calender Description (calender_description)
  • Is Public (is_public)
  • Cover Image (cover_image)

Comment (comment)

  • Comment Id (comment_id) — Primary key — NOT NULL
  • User id (user_id) — Foreign key → User.User ID — NOT NULL
  • Event Id (event_id) — Foreign key → Event.Event Id — NOT NULL
  • Content (content)

Contact (Untitled2)

  • Contact ID (contact_id) — Primary key — NOT NULL

Event (event)

  • Event Id (event_id) — Primary key — NOT NULL
  • Event Title (event_title)
  • Event Description (event_description)
  • Start Time (start_time)
  • End Time (end_time)
  • Location Id (is_public)

FavoriteEvents (favrotie events)

  • Favorite Envet ID (favorite_event_id) — Primary key — NOT NULL
  • Event Id (event_id2) — Foreign key → Event.Event Id — NOT NULL
  • D-day (d_day)

Location (Untitled)

  • Location Id (location_id) — Primary key — NOT NULL
  • Address Line1 (address_line1)
  • City (city)

Notification (notification)

  • Notification ID (notification_id) — Primary key — NOT NULL
  • User id (user_id) — Foreign key → User.User ID — NOT NULL
  • Event Id (event_id) — Foreign key → Event.Event Id — NOT NULL
  • Notification Time (notificiation_time)

Subscription (subscription)

  • Subscription ID (subscription_id) — Primary key — NOT NULL
  • User id (user_id) — Foreign key → User.User ID — NOT NULL
  • Calender id (calender_id) — Foreign key → Calender.Calender id — NOT NULL

User (user)

  • User ID (user_id) — Primary key — NOT NULL
  • User Birth (user_birth)
  • User Email (user_email)
  • User Password (user_password)
  • User Name (user_name)
  • User Profile Image (user_profile_image)