Tourify Data Model: MySQL Schema and Relationships

Tourify’s MySQL schema is managed entirely by Laravel migrations in backend/database/migrations/. Eleven application tables cover authentication, tourism content, user interactions, and push notifications. Three of those tables — images, favorites, and reviews — use polymorphic relationships so they can belong to multiple entity types without duplicating columns.

Entity reference

roles

Seeded at deploy time. The default role for every new user registration is id = 2 (regular user).

Column	Type	Constraints
`id`	`bigint unsigned`	PK, auto-increment
`name`	`varchar`	unique
`label`	`varchar`	—
`description`	`text`	nullable
`created_at`	`timestamp`	—
`updated_at`	`timestamp`	—

Eloquent: Role → hasMany(User::class)

users

Created by the base Laravel migration. The push_token column is added by a separate migration (2026_05_04_add_push_token_to_users_table).

Column	Type	Constraints
`id`	`bigint unsigned`	PK, auto-increment
`role_id`	`bigint unsigned`	FK → `roles.id`, default `2`, cascade delete
`name`	`varchar`	—
`email`	`varchar`	unique
`password`	`varchar`	bcrypt-hashed
`remember_token`	`varchar(100)`	nullable
`push_token`	`varchar`	nullable
`created_at`	`timestamp`	—
`updated_at`	`timestamp`	—

Eloquent: User → belongsTo(Role), hasMany(Favorite), hasMany(Review), hasMany(Notification), hasMany(EventRegistration)

cities

Top-level geographic entity. Deleting a city cascades to its places and events.

Column	Type	Constraints
`id`	`bigint unsigned`	PK, auto-increment
`name`	`varchar`	—
`description`	`text`	nullable
`country`	`varchar`	—
`created_at`	`timestamp`	—
`updated_at`	`timestamp`	—

Eloquent: City → hasMany(Place), hasMany(Event), morphMany(Image, 'imageable')

categories

Used to classify places (e.g. museum, park, restaurant).

Column	Type	Constraints
`id`	`bigint unsigned`	PK, auto-increment
`name`	`varchar`	—
`description`	`text`	nullable
`created_at`	`timestamp`	—
`updated_at`	`timestamp`	—

Eloquent: Category → hasMany(Place)

places

A point of interest within a city, classified by a category.

Column	Type	Constraints
`id`	`bigint unsigned`	PK, auto-increment
`city_id`	`bigint unsigned`	FK → `cities.id`, cascade delete
`category_id`	`bigint unsigned`	FK → `categories.id`, cascade delete
`name`	`varchar`	—
`description`	`text`	—
`address`	`varchar`	—
`latitude`	`decimal(10,7)`	nullable
`longitude`	`decimal(10,7)`	nullable
`created_at`	`timestamp`	—
`updated_at`	`timestamp`	—

Eloquent: Place → belongsTo(City), belongsTo(Category), hasMany(Event), morphMany(Image, 'imageable'), morphMany(Review, 'reviewable'), morphMany(Favorite, 'favorable')

events

A time-bound event anchored to a city. Optionally linked to a specific place — if the place is deleted the FK is set to null rather than cascading.

Column	Type	Constraints
`id`	`bigint unsigned`	PK, auto-increment
`city_id`	`bigint unsigned`	FK → `cities.id`, cascade delete
`place_id`	`bigint unsigned`	FK → `places.id`, nullable, set null on delete
`title`	`varchar`	—
`description`	`text`	—
`date`	`timestamp`	—
`created_at`	`timestamp`	—
`updated_at`	`timestamp`	—

Eloquent: Event → belongsTo(City), belongsTo(Place), hasMany(EventRegistration), morphMany(Image, 'imageable'), morphMany(Review, 'reviewable'), morphMany(Favorite, 'favorable')

event_registrations

Join table between users and events. A unique constraint on (user_id, event_id) prevents duplicate registrations.

Column	Type	Constraints
`id`	`bigint unsigned`	PK, auto-increment
`user_id`	`bigint unsigned`	FK → `users.id`, cascade delete
`event_id`	`bigint unsigned`	FK → `events.id`, cascade delete
`created_at`	`timestamp`	—
`updated_at`	`timestamp`	—

Unique index: (user_id, event_id)Eloquent: EventRegistration → belongsTo(User), belongsTo(Event)

favorites — polymorphic

Stores any favorited item for a user. The favorable_type / favorable_id pair resolves to a Place, Event, or City. A unique constraint prevents saving the same item twice.

Column	Type	Constraints
`id`	`bigint unsigned`	PK, auto-increment
`user_id`	`bigint unsigned`	FK → `users.id`, cascade delete
`favorable_type`	`varchar`	Eloquent morph type (e.g. `App\Models\Place`)
`favorable_id`	`bigint unsigned`	PK of the related model
`created_at`	`timestamp`	—
`updated_at`	`timestamp`	—

Unique index: (user_id, favorable_id, favorable_type)Eloquent: Favorite → belongsTo(User), morphTo('favorable')

reviews — polymorphic

User ratings and optional comments attached to places or events.

Column	Type	Constraints
`id`	`bigint unsigned`	PK, auto-increment
`user_id`	`bigint unsigned`	FK → `users.id`, cascade delete
`reviewable_type`	`varchar`	Eloquent morph type
`reviewable_id`	`bigint unsigned`	PK of the related model
`rating`	`tinyint unsigned`	1–5
`comment`	`text`	nullable
`created_at`	`timestamp`	—
`updated_at`	`timestamp`	—

Eloquent: Review → belongsTo(User), morphTo('reviewable')

notifications

In-app notifications delivered to a specific user. Optionally linked to a source entity via nullable morphs (notifiable_type / notifiable_id). The is_read flag is a boolean cast.

Column	Type	Constraints
`id`	`bigint unsigned`	PK, auto-increment
`user_id`	`bigint unsigned`	FK → `users.id`, cascade delete
`notifiable_type`	`varchar`	nullable morph type
`notifiable_id`	`bigint unsigned`	nullable morph PK
`title`	`varchar`	—
`message`	`text`	nullable
`is_read`	`boolean`	default `false`
`created_at`	`timestamp`	—
`updated_at`	`timestamp`	—

Eloquent: Notification → belongsTo(User), morphTo('notifiable')

images — polymorphic

One or more images attached to a city, place, or event via standard (non-nullable) morphs.

Column	Type	Constraints
`id`	`bigint unsigned`	PK, auto-increment
`url`	`varchar`	—
`imageable_type`	`varchar`	Eloquent morph type
`imageable_id`	`bigint unsigned`	PK of the related model
`created_at`	`timestamp`	—
`updated_at`	`timestamp`	—

Eloquent: Image → morphTo('imageable')

Polymorphic relationships

Laravel’s polymorphic relationships allow a single table to belong to multiple model types using a _type / _id column pair. Tourify uses three:

Images (imageable)

Table: images
Columns: imageable_type, imageable_id
Targets: City, Place, Event

Favorites (favorable)

Table: favorites
Columns: favorable_type, favorable_id
Targets: Place, Event, City

Reviews (reviewable)

Table: reviews
Columns: reviewable_type, reviewable_id
Targets: Place, Event

The _type column stores the fully-qualified Eloquent class name (e.g. App\Models\Place). When loading a polymorphic relation, Laravel uses this string to determine which table to join. Example — querying a place’s reviews:

$place = Place::with('reviews.user')->find($id);

foreach ($place->reviews as $review) {
    // $review->reviewable_type === 'App\Models\Place'
    // $review->reviewable_id  === $place->id
    echo "{$review->user->name}: {$review->rating}/5";
}

Example — adding a favorite from the API:

POST /api/favorites
Authorization: Bearer <token>
Content-Type: application/json

{
  "favorable_type": "App\\Models\\Event",
  "favorable_id": 3
}

Entity relationship diagram

roles ──────< users >──────< favorites >── [Place|Event|City]
                │                │
                │                └──── [polymorphic: favorable]
                │
                ├──< event_registrations >── events
                │
                ├──< reviews >─── [polymorphic: reviewable]
                │                 targets: Place, Event
                │
                └──< notifications

cities ────< places ──────< events
  │            │               │
  │            │               └── event_registrations
  │            │
  └── [images] └── [images, reviews, favorites]
  └── [images]     [polymorphic: imageable]

Cascade delete behavior:
Deleting a City cascades to all its Places and Events.
Deleting a Place cascades to its Reviews, Favorites, and Images (via ON DELETE CASCADE on the polymorphic FKs at the application level), and sets place_id to null on any associated Events rather than deleting them.
Deleting a User cascades to their Favorites, Reviews, Notifications, and EventRegistrations.

Get Started

Core Features

Admin Panel

Architecture

Tourify Data Model: MySQL Schema and Relationships

Entity reference

Polymorphic relationships

Images (imageable)

Favorites (favorable)

Reviews (reviewable)

Entity relationship diagram

Build docs developers (and LLMs) love

Get Started

Core Features

Admin Panel

Architecture

Documentation Index

​Entity reference

​Polymorphic relationships

Images (imageable)

Favorites (favorable)

Reviews (reviewable)

​Entity relationship diagram

Build docs developers (and LLMs) love

Entity reference

Polymorphic relationships

Entity relationship diagram