t
Tables (20)
Copy Of users (CopyOfusers)
- Key — Primary key — NOT NULL
- Key2 — Primary key — NOT NULL
- Key3 — Primary key — NOT NULL
- nickname — varchar(30) — NOT NULL
- password — varchar(100) — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- Field
- Field2
- Field3
category
- id — serial — Primary key — NOT NULL
- createdAt — timestamp — NOT NULL
- updatedAt — timestamp — NOT NULL
- name — varchar — NOT NULL
- coverImg — varchar
- slug — varchar — NOT NULL
channelchats
- id — int — Primary key — NOT NULL
- content — text — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- ChannelId — int — Foreign key → channels.id
channelmembers
- ChannelId — int — Foreign key → channels.id — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
channels
- id — int — Primary key — NOT NULL
- name — varchar(30) — NOT NULL
- private — tinyint(1)
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- WorkspaceId — int — Foreign key → workspaces.id
- Field
dish
- id — serial — Primary key — NOT NULL
- createdAt — timestamp — NOT NULL
- updatedAt — timestamp — NOT NULL
- name — varchar — NOT NULL
- price — int4 — NOT NULL
- photo — varchar
- description — varchar — NOT NULL
- restaurantId — int4
- options — json
dms
- id — int — Primary key — NOT NULL
- content — text — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- WorkspaceId — int — Foreign key → workspaces.id
- ReceiverId — int — Foreign key
mentions
- id — int — Primary key — NOT NULL
- category — enum('chat','dm','system') — NOT NULL
- chatId — int
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- WorkspaceId — int — Foreign key → workspaces.id
- ReceiverId — int — Foreign key
order
- id — serial — Primary key — NOT NULL
- createdAt — timestamp — NOT NULL
- updatedAt — timestamp — NOT NULL
- total — int4
- status — order_status_enum — NOT NULL
- customerId — int4
- driverId — int4
- restaurantId — int4
order_dishes_dish
- orderId — int4 — Primary key — NOT NULL
- dishId — int4 — Primary key — NOT NULL
order_item
- id — serial — Primary key — NOT NULL
- createdAt — timestamp — NOT NULL
- updatedAt — timestamp — NOT NULL
- options — json
- dishId — int4
order_items_order_item
- orderId — int4 — Primary key — NOT NULL
- orderItemId — int4 — Primary key — NOT NULL
payment
- id — serial — Primary key — NOT NULL
- createdAt — timestamp — NOT NULL
- updatedAt — timestamp — NOT NULL
- userId — int4
- restaurantId — int4
- transactionId — varchar — NOT NULL
restaurant
- id — serial — Primary key — NOT NULL
- createdAt — timestamp — NOT NULL
- updatedAt — timestamp — NOT NULL
- name — varchar — NOT NULL
- coverImg — varchar — NOT NULL
- address — varchar — NOT NULL
- categoryId — int4
- ownerId — int4
- isPromoted — bool — NOT NULL
- promotedUntil — timestamp
typeorm_metadata
- type — varchar — NOT NULL
- database — varchar
- schema — varchar
- table — varchar
- name — varchar
- value — text
user
- id — serial — Primary key — NOT NULL
- createdAt — timestamp — NOT NULL
- updatedAt — timestamp — NOT NULL
- email — varchar — NOT NULL
- password — varchar — NOT NULL
- role — user_role_enum — NOT NULL
- verified — bool — NOT NULL
users
- nickname — varchar(30) — NOT NULL
- password — varchar(100) — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
verification
- id — serial — Primary key — NOT NULL
- createdAt — timestamp — NOT NULL
- updatedAt — timestamp — NOT NULL
- code — varchar — NOT NULL
- userId — int4
workspacemembers
- WorkspaceId — int — Foreign key → workspaces.id — NOT NULL
- loggedInAt — datetime
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
workspaces
- id — int — Primary key — NOT NULL
- name — varchar(30) — NOT NULL
- url — varchar(30) — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime