divineskies - Laravel Schema Designer

tblUser

idUser increments
timestamps timestamps
fullname string (250)
email string (250)
password string (250)
company string (250)
address text
userCategory integer
softDeletes softDeletes
UserStatus integer

tblUserTypeDetail

idUserTypeDetail increments
timestamps timestamps
softDeletes softDeletes
idUser ^FK integer
idUserType ^FK integer

tblUserType

idUserType increments
timestamps timestamps
softDeletes softDeletes
UserTypeName string (250)

tblUserBaseAirport

idUserBaseAirport increments
timestamps timestamps
softDeletes softDeletes
idUser ^FK integer
idBaseAirport ^FK integer

tblBaseAirport

idBaseAirport increments
timestamps timestamps
softDeletes softDeletes
BaseAirportName string (250)

tblAircraft

idAircraft increments
timestamps timestamps
softDeletes softDeletes
idAircraftType ^FK integer
idAircraftMake ^FK integer
idAircraftModel ^FK integer

tblAircraftType

idAircraftType increments
timestamps timestamps
softDeletes softDeletes
AircraftTypenName string (250)

tblAircraftMake

idAircraftMake increments
timestamps timestamps
softDeletes softDeletes
AircraftMakeName string (250)

tblAircraftModel

idAircraftModel increments
timestamps timestamps
softDeletes softDeletes
AircraftModelnName string (250)

tblUserAircraft

idUserAircraft increments
timestamps timestamps
softDeletes softDeletes
idUser ^FK integer
idAircraft ^FK integer

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01