mobility-trip-db

Tables (7)

channelMembers

  • channelId — int — Foreign key → channels.id — NOT NULL
  • userId — int — Foreign key → users.id — NOT NULL
  • createAt — datetime
  • updateAt — datetime

channels

  • id — int — Primary key — NOT NULL
  • name — varchar(30)
  • createAt — datetime
  • updateAt — datetime

productFiles

  • uuid — int — Primary key — NOT NULL
  • originalName — varchar(100)
  • encoding — varchar(30)
  • mimeType — varchar(30)
  • size — varchar(30)
  • url — varchar(100)
  • createdAt — datetime
  • updatedAt — datetime
  • productId — int — Foreign key → products.id — NOT NULL

products

  • id — int — Primary key — NOT NULL
  • name — varchar(100)
  • description — text
  • destination — varchar(30)
  • private — tinyint(1)
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime

reservationFiles

  • uuid — int — Primary key — NOT NULL
  • documentName — varchar(30)
  • originalName — varchar(100)
  • encoding — varchar(30)
  • mimeType — varchar(30)
  • size — varchar(30)
  • url — varchar(100)
  • createdAt — datetime
  • updatedAt — datetime
  • reservationId — int — Foreign key → reservations.id — NOT NULL

reservations

  • id — int — Primary key — NOT NULL
  • homePickUpAt — datetime
  • arrivalsPickUpAt — datetime
  • returnPickUpAt — datetime
  • progress — varchar(30)
  • createdAt — datetime
  • updatedAt — datetime
  • productId — int — Foreign key → products.id — NOT NULL
  • userId — int — Foreign key → users.id — NOT NULL

users

  • id — int — Primary key — NOT NULL
  • email — varchar(30)
  • password — varchar(100)
  • name — varchar(30)
  • phone — varchar(30)
  • phoneAuth — tinyint(1)
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime