gusto

Tables (10)

bookmark (Untitled6)

  • id (Key) — bigint — Primary key — NOT NULL
  • userId (Key2) — bigint — Foreign key → user.id — NOT NULL
  • restaurantId (Key3) — bigint — Foreign key → restaurant.id — NOT NULL
  • visitCount (Field) — int

category (Untitled4)

  • id (Key) — bigint — Primary key — NOT NULL
  • userId (Key2) — bigint — Foreign key → user.id — NOT NULL
  • restaurantId (Key3) — bigint — Foreign key → restaurant.id — NOT NULL
  • name (Field) — varchar(10)
  • description (Field2) — varchar(20)
  • open (Field3) — boolean
  • menuCount (Field4) — int

group (Untitled8)

  • id (Key) — bigint — Primary key — NOT NULL
  • userId (Key2) — bigint — Foreign key → user.id — NOT NULL
  • groupName (Field) — varchar(10)
  • personNum (Field2) — int
  • notice (Field3) — varchar(30)

restaurant (Untitled5)

  • id (Key) — bigint — Primary key — NOT NULL
  • address (Field) — varchar(1000)
  • officeHour (Field2) — varchar(10)
  • dayOff (Field4) — varchar(10)
  • phonNum (Field3) — varchar(30)

restaurantImage (Untitled)

  • id (Key2) — bigint — Primary key — NOT NULL
  • restaurantId (Key) — bigint — Foreign key → restaurant.id — NOT NULL
  • image1 (Field) — varchar(30)
  • image2 (Field2) — varchar(30)
  • image3 (Field3) — varchar(30)

review (Untitled3)

  • id (Key) — bigint — Primary key — NOT NULL
  • userId (Key2) — bigint — Foreign key → user.id — NOT NULL
  • restaurantId (Key3) — bigint — Foreign key → restaurant.id — NOT NULL
  • menuName (Field) — varchar(10)
  • taste (Field2) — int
  • spicy (Field3) — int
  • mood (Field5) — int
  • toilet (Field4) — int
  • parking (Field6) — int
  • content (Field7) — varchar(100)
  • like (Field9) — int
  • createdAt (Field10) — datetime(6)
  • updatedAt (Field11) — datetime(6)

reviewImage (Untitled7)

  • id (Key) — bigint — Primary key — NOT NULL
  • reviewId (Key2) — bigint — Foreign key → review.id — NOT NULL
  • image (Field) — varchar(30)
  • Field2

route (Untitled9)

  • id (Key) — bigint — Primary key — NOT NULL
  • userId (Key2) — bigint — Foreign key → user.id — NOT NULL
  • Field

routeList (Untitled10)

    user (Untitled2)

    • id (Key2) — bigint — Primary key — NOT NULL
    • nickname (Field) — varchar(13)
    • createdAt (Field2) — datetime(6)
    • updatedAt (Field3) — datetime(6)
    • status (Field4) — varchar(10)
    • inactiveDate (Field5) — datetime
    • reviewCount (Field6) — int
    • pinCount (Field7) — int
    • follower (Field8) — int