DB

Tables (9)

Coupon (Untitled7)

  • Key — Primary key — NOT NULL
  • user_id (Key2) — bigint(20) — Foreign key → User.user_id — NOT NULL
  • name (Field)
  • discountRate (Field2)
  • category (Field3)
  • content (Field4)
  • createdDate (Field5)
  • modifiedDate (Field6)
  • expiredDate (Field7)

Diary (Untitled3)

  • diary_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — bigint(20) — Foreign key → User.user_id — NOT NULL
  • title (Field) — bigint(20)
  • createdDate (Field2) — timestamp
  • modifiedDate (Field3) — timestamp
  • content (Field4) — varchar(255)
  • picture (Field5)

Like (Untitled6)

  • user_id (Key) — bigint(20) — Foreign key → User.user_id — NOT NULL
  • place_id (Key2) — Foreign key → Place.place_id — NOT NULL
  • createdDate (Field)
  • modifiedDate (Field2)
  • Y/N (Field3)
  • likeCnt (Field4)

Pet (Untitled2)

  • pet_id (PK) — bigint(20) — Primary key — NOT NULL
  • user_id (Key) — bigint(20) — Foreign key → User.user_id — NOT NULL
  • name (Field) — varchar(255)
  • species (Field2) — varchar(255)
  • age (Field3) — bigint(20)
  • content (Field4) — varchar(255)
  • createdDate (Field5)
  • modifiedDate (Field6)

Place (Untitled4)

  • place_id (Key) — Primary key — NOT NULL
  • diary_id (Key2) — Foreign key → Diary.diary_id — NOT NULL
  • address (Field)
  • hour (Field2)
  • name (Field3)
  • category (Field4)
  • picture (Field5)
  • createdDate (Field6)
  • modifiedDate (Field7)

Reservation (Untitled8)

  • reservation_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — bigint(20) — Foreign key → User.user_id — NOT NULL
  • reservedDate (Field)
  • price (Field2)
  • createdDate (Field3)
  • modifiedDate (Field4)

Review (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • rating (Field)
  • content (Field2)
  • picture (Field3)
  • createdDate (Field4)
  • modifiedDate (Field5)
  • user_id (Key2) — bigint(20) — Foreign key → User.user_id — NOT NULL
  • place_id (Key3) — Foreign key → Place.place_id — NOT NULL

Untitled9

    User (Untitled)

    • user_id (Key) — bigint(20) — Primary key — NOT NULL
    • name (Field) — varchar(255)
    • phone_number (Field2) — bigint(20)
    • address (Field3) — varchar(255)
    • email (Field4) — varchar(255)
    • createdDate (Field5)
    • modifiedDate (Field6)