Database Schema: Mega Creative Tables and Relationships

Mega Creative stores all application data in MySQL across seven tables. Six of these are application-specific tables that manage students, academic programs, lookup values, and geographic data. The seventh is a Laravel-internal table used by the queue system. Every table is created through Artisan migrations, which means the schema is fully version-controlled and reproducible across environments.

Tables Overview

The six application tables form a hub-and-spoke structure where estudiantes sits at the centre and holds foreign keys to every other application table.

Table	Purpose	Timestamps
`estudiantes`	Core student records — personal details, enrollment, and location	✅ Yes
`carreras`	Academic programs a student can be enrolled in	❌ No
`statuses`	Lookup: enabled / disabled status for students and programs	❌ No
`sexos`	Lookup: sex options for a student	❌ No
`paises`	Lookup: countries for a student’s address	❌ No
`estados`	Lookup: states / provinces for a student’s address	❌ No
`ciudades`	Lookup: cities for a student’s address	❌ No

The failed_jobs table is scaffolded automatically by Laravel and records queue jobs that throw an unhandled exception. It is not used by any application model and requires no manual management.

estudiantes

The primary application table. Each row represents one registered student.

Column	Type	Constraints	Notes
`id`	`BIGINT UNSIGNED`	PK, auto-increment	Surrogate primary key
`nombres`	`VARCHAR(100)`	NOT NULL	Student’s given name(s)
`apellidos`	`VARCHAR(100)`	NOT NULL	Student’s surname(s)
`sexo_id`	`TINYINT UNSIGNED`	NOT NULL, FK → `sexos.id`	References the sex lookup
`fecha_de_nacimiento`	`DATE`	NOT NULL	Date of birth
`email`	`VARCHAR(100)`	NOT NULL, UNIQUE	Contact email address
`carrera_id`	`TINYINT UNSIGNED`	NOT NULL, FK → `carreras.id`	Academic program enrolled in
`status_id`	`TINYINT UNSIGNED`	NOT NULL, FK → `statuses.id`	Active/inactive status
`pais_id`	`TINYINT UNSIGNED`	NOT NULL, FK → `paises.id`	Country of residence
`estado_id`	`TINYINT UNSIGNED`	NOT NULL, FK → `estados.id`	State / province of residence
`ciudad_id`	`TINYINT UNSIGNED`	NOT NULL, FK → `ciudades.id`	City of residence
`created_at`	`TIMESTAMP`	Nullable	Set by Laravel automatically
`updated_at`	`TIMESTAMP`	Nullable	Set by Laravel automatically

carreras

Stores the academic programs available for student enrollment. Each program has a display name, a short description, and its own enabled/disabled status.

Column	Type	Constraints	Notes
`id`	`TINYINT UNSIGNED`	PK, auto-increment	Surrogate primary key
`nombre`	`VARCHAR(100)`	NOT NULL, UNIQUE	Program name
`descripcion`	`VARCHAR(180)`	NOT NULL	Short description of the program
`status_id`	`TINYINT UNSIGNED`	NOT NULL, FK → `statuses.id`	Whether the program is accepting students

carreras does not use Laravel’s $table->timestamps(). The created_at and updated_at columns are absent from this table.