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