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
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