outsourcing

Tables (5)

Menu (Untitled3)

  • menuId (Key) — Long — Primary key — NOT NULL
  • storeId (Key2) — Long — Foreign key → Store.storeId — NOT NULL
  • name (Field) — String
  • price (Field2) — int
  • deleted (Field3) — boolean
  • createdAt (Field4)

Order (Untitled4)

  • orderId (Key) — Long — Primary key — NOT NULL
  • userId (Key2) — Long — Foreign key → User.userId — NOT NULL
  • menuId (Key3) — Long — Foreign key → Menu.menuId — NOT NULL
  • status (Field) — Enum
  • createdAt (Field2) — LocalDateTime
  • updatedAt (Field3) — LocalDateTime

Review (Untitled5)

  • reviewID (Key) — Long — Primary key — NOT NULL
  • orderId (Key3) — Long — Foreign key → Order.orderId — NOT NULL
  • star (Field) — int

Store (Untitled2)

  • storeId (Key) — Long — Primary key — NOT NULL
  • ownerId (Key2) — Long — Foreign key → User.userId — NOT NULL
  • name (Field2) — String
  • openAt (Field) — LocalDateTime
  • closeAt (Field3) — LocalDateTime
  • deleted (Field4) — boolean
  • minPrice (Field5) — int
  • createdAt (Field6) — LocalDateTime
  • updatedAt (Field7) — LocalDateTime

User (Untitled)

  • userId (Key) — Long — Primary key — NOT NULL
  • email (Field) — String
  • nickname (Field7) — String
  • password (Field3) — String
  • deleted (Field4) — boolean
  • role (Field2) — Enum
  • createdAt (Field5) — LocalDateTime
  • updatedAt (Field6) — LocalDateTime