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