Table: Condominiums ID (PK) Name Address ... Table: Buildings ID (PK) Name Number…
- User
Table: Condominiums
ID (PK)
Name
Address
... Table: Buildings
ID (PK)
Name
Number
Address
Condominium_id (FK to Condominiums) Table: Departments
ID (PK)
Number
Owner
Floor
Description (nullable)
Building_id (FK to Buildings)
Owner_id (FK to Users) Table: Users
UserID (PK)
Name
Department_id (FK to Departments) Table: Voting
ID (PK)
Created_at
Finish_at
Building_id (FK to Buildings) Table: Options
ID (PK)
Description
Voting_id (FK to Voting) Table: Bills
ID (PK)
Created_at
Finish_at
Amount
'Type' ['Scheduled', 'Occasional']
Building_id (FK to Buildings)
Department_id (FK to Departments) genera modelos laravel incluyendo $protected fillable y funciones de relacion
- Assistant
Modelo: Condominiums
class Condominium extends Model { protected $fillable = ['name', 'address'];
public function buildings() { return $this->hasMany(Building::class); }}
Modelo: Buildings
class Building extends Model { protected $fillable = ['name', 'number', 'address', 'condominium_id'];
public function condominium() { return $this->belongsTo(Condominium::class); } public function departments() { return $this->hasMany(Department::class); }}
Modelo: Departments
class Department extends Model { protected $fillable = ['number', 'owner', 'floor', 'description', 'building_id', 'owner_id'];
public function building() { return $this->belongsTo(Building::class); } public function owner() { return $this->belongsTo(User::class, 'owner_id'); } public function users() { return $this->hasMany(User::class); }}
Modelo: Users
class User extends Model { protected $fillable = ['name', 'department_id'];
public function department() { return $this->belongsTo(Department::class); }}
Modelo: Voting
class Voting extends Model { protected $fillable = ['created_at', 'finish_at', 'building_id'];
public function building() { return $this->belongsTo(Building::class); } public function options() { return $this->hasMany(Option::class); }}
Modelo: Options
class Option extends Model { protected $fillable = ['description', 'voting_id'];
public function voting() { return $this->belongsTo(Voting::class); }}
Modelo: Bills
class Bill extends Model { protected $fillable = ['created_at', 'finish_at', 'amount', 'type', 'building_id', 'department_id'];
public function building() { return $this->belongsTo(Building::class); } public function department() { return $this->belongsTo(Department::class); }}